Report Inventory valuation does not show correct quantities

alsolalsol Member Posts: 243
Hi to all
We have a problem with the inventory valuation report (1001):

Because it show only the invoiced quantities it does not match the inventory in General Ledger. We have many sales shipments and received purchase orders which aren't invoiced. But the value of the shipment has already posted into GL.
Is it possible to run this report (or another one) based on the field quantity in the item ledger entries instead of invoiced quantity?

Best regards

Comments

  • kinekine Member Posts: 12,562
    Inventory valuation is not correct till you invoice all inputs... it is only expected value and it is why it is printed in this way...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • radianisradianis Member Posts: 49
    In this report there is an option "Include Expected Cost" click Help and see the definition :
    The printed document always shows costs posted as invoiced. If you place a check mark in this field, the report will also print the expected cost of entries that have been posted as received or shipped.

    So if you want to see the correct quantity and value. Just click this option and you get the right figure.
Sign In or Register to comment.