I have over 50,000 customers with 300,000 history transactions. It take over a half an hour to renumber one customer. I have to renumber 300 customer. 150 hours to renumber!!! That is unacceptable.
by: John R. | over a year ago | General Enhancements
Comments
Can you try this -- in AR options turn off the recalculate option to "Never" instead of "Always" and see if that speeds it up?
The entire renumbering approach needs updating (customers / vendors / items). We typically merge obsolete ItemCodes into one ZZZZZZZ code to reduce clutter and the time it takes is quite unreasonable. Redoing customer / vendor divisions is incredibly time consuming. Spending hours and hours and hours at night to do this work should not be necessary.
With Premium / SQL I've done some of this stuff in seconds (not hours)... admittedly skipping the summary tables, but a "recalculate" utility for each module could separate out those to be done in bulk after the renumbering.