Inventory Item Valuation Report needs to run faster! It needs to be optimized.
by: E K. | over a year ago | Operations Management
Comments
I absolutely agree with this. Waiting 3 to 4 hours for your report is ridiculous.
Use Location Detail Costs instead of the default Transaction Costs.
It already appears much faster in 5.6
Yes, that report has been improved in 5.6! In a 1.46 GB database with 189,184 records, these were the benchmark results between 5.5 PU2 and 5.6: Transaction costs Details: 14:30 mins vs. 8:00 mins Transaction Costs (From/To Cutoff): 12 mins vs. 5:15mins Transaction Costs (Sum) : 15 mins vs. 8 mins Transaction Costs (From/To Cutoff Sum): 12 mins vs 5:15mins
Comments
I absolutely agree with this. Waiting 3 to 4 hours for your report is ridiculous.
Use Location Detail Costs instead of the default Transaction Costs.
It already appears much faster in 5.6
Yes, that report has been improved in 5.6! In a 1.46 GB database with 189,184 records, these were the benchmark results between 5.5 PU2 and 5.6:
Transaction costs Details: 14:30 mins vs. 8:00 mins
Transaction Costs (From/To Cutoff): 12 mins vs. 5:15mins
Transaction Costs (Sum) : 15 mins vs. 8 mins
Transaction Costs (From/To Cutoff Sum): 12 mins vs 5:15mins