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 Reply Children
  • 0 in reply to KathyW

    If their work stations are Multi Processors would totally recommend them upgrading Excel to x64.

    The 8GB ram is the biggest issue. Excel is a dog with that amount and that's probably were the majority of run time is coming from. Maybe recommend increasing it on the user's work station who will be running the report?