Inventory Value Zero field on Item card

dannyboy
Member Posts: 13
Hi
We have a situation here, where in the customer has wrongly ticked the "Inventory Value zero" field on Item card for few items and due to which the cost is not updated during the Purchase invoice. Now he has realized that and the tick had been removed now. I am sure that any further transactions will be posted with cost.
Now how to update the cost for previous Purchases and sales? Is there any standard way of doing it. Infact we tried to run the ACIE and Post cost to GL after removing the tick and there is no updation...
Please let us know
We have a situation here, where in the customer has wrongly ticked the "Inventory Value zero" field on Item card for few items and due to which the cost is not updated during the Purchase invoice. Now he has realized that and the tick had been removed now. I am sure that any further transactions will be posted with cost.
Now how to update the cost for previous Purchases and sales? Is there any standard way of doing it. Infact we tried to run the ACIE and Post cost to GL after removing the tick and there is no updation...
Please let us know
0
Comments
-
Goto Warehouse>Inventory>Revaluation Journals and apply the correct costs in that journal for each item separately for each single PO line using the "Applies-to Entry" field (in either "Unit Cost (Revalued)" or "Inventory Value (Revalued)") and post the journal. That will update the cost on the purchases. Afterwards you need to run ACIE once more to apply these costs to the sales as COGS.Kai Kowalewski0
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