N 5.00 Pb of Adjust cost-Items with Average Costing method
NELLIO
Member Posts: 13
Hi,
We have a customer who begin to work on Nav 5.00 the 1 january 2008. He has entered the positive adjustment of their items in the Item Journal the 31 December 2007. He used costing method “Average”. Some items have a Base UOM different of the Purchase UOM. So he made some mistakes of unit cost.
To correct these mistakes we’ve thought at one solution:
1- By Object Designer we run the Value Entry table (5802) and changed the value of “Cost Per Unit” and “Cost amount (Actual)” in the value entry of the positive adjustment of the 31 December 2007 for the item.
2- We uncheck in the “Avg. Cost Adjmt. Entry Point” table (5804) the field “Cost is adjusted” to force system to recalculate the exact average cost for the item.
3- We execute a new “Adjust Cost” for this item in Financial Management and it seems the system adjust correctly all the “Entry type” of this Item.
Is it a good solution ? or are there better solutions in Navision to correct this ?
We have a customer who begin to work on Nav 5.00 the 1 january 2008. He has entered the positive adjustment of their items in the Item Journal the 31 December 2007. He used costing method “Average”. Some items have a Base UOM different of the Purchase UOM. So he made some mistakes of unit cost.
To correct these mistakes we’ve thought at one solution:
1- By Object Designer we run the Value Entry table (5802) and changed the value of “Cost Per Unit” and “Cost amount (Actual)” in the value entry of the positive adjustment of the 31 December 2007 for the item.
2- We uncheck in the “Avg. Cost Adjmt. Entry Point” table (5804) the field “Cost is adjusted” to force system to recalculate the exact average cost for the item.
3- We execute a new “Adjust Cost” for this item in Financial Management and it seems the system adjust correctly all the “Entry type” of this Item.
Is it a good solution ? or are there better solutions in Navision to correct this ?
0
Categories
- All Categories
- 75 General
- 75 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
- 610 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions