YTD only data for Income Statement and balance Sheet - tree with 60+ companies

I have a customer that we are converting from MAS90 ver 4.3 Frx to Sage 100 ver 2017 SI.

Their old Frx reports ran in a matter of minutes.

The SI reports for P&L with 64 companies in the tree take only 9 min on my stand alone system with their data.

However, this same report takes 40 min on their server and we stopped it after 2 hours on the workstation.

Both machines only have 8gb of memory and we are looking to increase that.

In the meantime, is there a way, if I create a parameter to select the month and year to only pull YTD data?

no drill down needed for Income Statement and Balance Sheets.

The Trial Balance for all companies will need to be detail data YTD for drill down purposes.

Any other suggestions besides the memory increase for speeding up the processing time?

As always, thanks in advance for your assistance.

Parents
  • 0

    All great suggestions. At the risk of explaining the obvious just make sure the report is using Sage Intelligence formulas and not copied formulas from FRx. I've seen reports that were using copied FRx formulas and the run time was much longer, similar to what you have described. Once we changed the formulas to Sage Intelligence ones the report ran quickly.  Again, my guess is you are using SI formulas but I just want to make sure that point is checked. Slight smile

Reply
  • 0

    All great suggestions. At the risk of explaining the obvious just make sure the report is using Sage Intelligence formulas and not copied formulas from FRx. I've seen reports that were using copied FRx formulas and the run time was much longer, similar to what you have described. Once we changed the formulas to Sage Intelligence ones the report ran quickly.  Again, my guess is you are using SI formulas but I just want to make sure that point is checked. Slight smile

Children