Report Inventory valuation does not show correct quantities
alsol
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
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
0
Comments
-
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...0
-
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.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
