Monday, May 23, 2016

Dynamics NAV - Item Age Composition vs Inventory Valuation Report

  • Item Age Composition Report
    • Shows the CURRENT value of stock, broken into aging buckets
    • Uses the total of open item ledger entries
    • Automatically Uses Expected Costs for receipts with no posted invoices
    • Displays value in aging buckets for three periods before the current date
  • Inventory Valuation Report
    • Shows the Value of Stock AS AT a given date
    • Uses the total of open item ledger entries
    • By default, the report will only display line items with posted invoices
    • User must tick "Expected Costs" to include any line items with unposted invoices, and use an expected cost to value those lines
    • Displays total of all transactions in the range selected
  • These two reports are not supposed to match for historical dates.
  • They will only match for current dates.

2 comments: