Inventory Item Valuation Report needs to run faster! It needs to be optimized.

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