NAV Inventory valuation Report Issue

NHP
Member Posts: 3
Hi,
On Inventory valuation report for some items there was only inventory value. Remaining quantity and and unit cost are blank. While analyzing the reason , we could conclude that there is a difference in Cost Amount(Actual) in item ledger entry for those items. We are aware that if there is any unit cost difference between inbound and outbound Item entry. Adjust cost item entries process will create a adjustment entry for the difference amount in value entry.
But this is not happening for this particular items. How shall we post the cost difference and avoid the inventory value in inventory valuation report.
Please provide your suggestions to overcome this issue.
Thanks,
Hari
On Inventory valuation report for some items there was only inventory value. Remaining quantity and and unit cost are blank. While analyzing the reason , we could conclude that there is a difference in Cost Amount(Actual) in item ledger entry for those items. We are aware that if there is any unit cost difference between inbound and outbound Item entry. Adjust cost item entries process will create a adjustment entry for the difference amount in value entry.
But this is not happening for this particular items. How shall we post the cost difference and avoid the inventory value in inventory valuation report.
Please provide your suggestions to overcome this issue.
Thanks,
Hari
0
Answers
-
We have seen this before if the entries are in different months and the report is date filtered. For instance if the item was posted as receipt invoiced on December 1st, but was posted as sold November 30, and the report used a date filter starting or ending December 1st. I can't recall if we saw the value if the report was run for November or for December, but this is an example of something that could cause the report to look odd.
The long and the short though was that if you ran the report spanning both months there would be no issue, so there was nothing to correct, only something to note.
Hope this makes sense.0
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