Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 320 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
Options
How do i correct Invemtory valuation report that shows item with 0 quantity but value
Yemi
Member Posts: 2
Good day everyone,
I currently work as an ERP Analyst and we use NAV 2017.Recently, when we run our inventory valuation report, we discovered there are some items that have 0 quantity but with value
Please note:
1.Our Average Cost Calc Type in Inventory Setup is set to Item.
2.When we run the inventory valuation, we run for all locations.
How do i go about correcting this please?
Thanks for your help.
I currently work as an ERP Analyst and we use NAV 2017.Recently, when we run our inventory valuation report, we discovered there are some items that have 0 quantity but with value
Please note:
1.Our Average Cost Calc Type in Inventory Setup is set to Item.
2.When we run the inventory valuation, we run for all locations.
How do i go about correcting this please?
Thanks for your help.
0
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
1. Try using the Boolean (expected cost) in the report request page.
2. Did you adjust the cost, if not run the "adjust cost- item entries" batch, before starting the batch try to backup because this batch will post many entries to different ledgers.
3. Check there are any cuatomizations in the report or entry tabels like Value Entry, Item Ledger Entry and G/L Entry which will effect the report data.
Srinivas.