A recurrent issue that we have in our customers is the "Inventory Valuation Report" with the "Expected Cost".

People struggles to understand why a Stocks report must have the "Expected Cost" field activated in order to have the complete stocks and valuation. Having the field "Include the Expected Cost" activated by default is not enough, because the report is difficult do read.

My Suggestion is :

• Line with the item reference is the one that should include the total inventory and cost (actual+expected). Evermore because users like to export the report for Excel and sometimes using VLOOKUP functions, which aren't possible because the actual report doesn't have the item reference in the line that includes the expected cost.
• If Expected cost option should be to :
• Include Expected Cost (which should be activate by default)
• Not include Expected Cost (field before not activated)
• Detail Expected Cost (detail in a line bellow the expected cost included in the main line)
• There should be also available 3 more maps:
• Expected Cost Detailed per Item grouped by Inventory Posting Group (this would allow to check the amounts in the trial balance if a specific account for items shipped or reveied but not yet invoiced)
• Expected Cost Detailed per Customer grouped by Customer Posting Group (this would allow to check the amounts in the trial balance if a specific account for shipped not yet invoiced to customers)
• Expected Cost Detailed per Vendor grouped by Vendor Posting Group (this would allow to check the amounts in the trial balance if a specific account for received not yet invoiced from vendors)
• The previous reports and constantly asked by all our customers and chartered accountants. Besides, those maps allow to make a "cut-off" (filtering per item ledger entry date vs item value entry date) which is an usual auditing procedure