cost correction - COGS

slmaluwa
Member Posts: 366
This may be discussed earlier and couldn't find the exact solution.
Bad Scenario was:
A user posted a Positive Adjustment Item Journal with ZERO cost of a particular item.
And sales has already sold these items. and another user ran "Adjust Cost - Item Entries" batch job.
The cost posted to COGS is now wrong. How can I correct this issue. Revaluation and Phy. Inventory Adjustment (i feel) only adjusts the current cost of remaining items.
Your help is much appreciated.
Bad Scenario was:
A user posted a Positive Adjustment Item Journal with ZERO cost of a particular item.
And sales has already sold these items. and another user ran "Adjust Cost - Item Entries" batch job.
The cost posted to COGS is now wrong. How can I correct this issue. Revaluation and Phy. Inventory Adjustment (i feel) only adjusts the current cost of remaining items.
Your help is much appreciated.
"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
0
Comments
-
Hello,
you can use a revaluation journal to revalue the positive adjustment to the correct amount. All you need to do is apply this revaluation to that original positive adjustment (applies-to entry).
When you run the 'adjust cost - item entries' job after that it will correct all sale-entries that were posted already at an incorrect cost.0 -
Thanks for the reply
I tried it but getting an error message as below
Microsoft Dynamics NAV
You must not enter Applies-to Entry in a revaluation sum line.
OK"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."0 -
Check whether any modifications are done.
I tried the process in base product and works fine.Regards,
Deep
India0
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