FormerMember

Stock Valuation Report takes days to run

Posted By FormerMember
Good day Experts
We have implemented Sage X3 ERP ver 11. Its a great product but however we have teething problems in the following areas:
Stock Valuation Report takes hours to run and produce results. Example if I select one company and restrict to a range of 5 sites, the report takes over 6 Hrs to execute, if it does at all, otherwise we get a system timeout. Having more than 5 sites, we repeat the process for the next set of sites, wait 6 Hrs and the cycle continues.
Access via: Stock - Periodic processing - Stock Valuation report
Costing method: Moving Average
Volumes: ITMMASTER has 36000 records and each product site record has a similar no of records to the ITMMASTER
Many thanks upfront
Regards
Itai