How to correct values and amounts in Inventory Valuation

dn
Member Posts: 71
Hi
When we running the Inventory Valuation report we noticed there is some stranges items.
Some items have Quantity 0 and value is 0.01 and Inventory Cost posted tol GL is also 0.01 and some items have value -0.01 and InvCostPostedToGL is -0.01.
The is also an item who have zero quantity but have value -3000 and InvCostPostedToGL -3000
Is there some way to correct the items so values and InvCostPostedToGL can set to zero when we run Inventory Valuation next time?
:-k
When we running the Inventory Valuation report we noticed there is some stranges items.
Some items have Quantity 0 and value is 0.01 and Inventory Cost posted tol GL is also 0.01 and some items have value -0.01 and InvCostPostedToGL is -0.01.
The is also an item who have zero quantity but have value -3000 and InvCostPostedToGL -3000
Is there some way to correct the items so values and InvCostPostedToGL can set to zero when we run Inventory Valuation next time?
:-k
0
Comments
-
Have you run the adjust cost item entries batch job, this often clears up these small anomalies. What kind of costing system are you running?
Andrew0 -
andrewcoper wrote:Have you run the adjust cost item entries batch job, this often clears up these small anomalies. What kind of costing system are you running?
Andrew
Yes..we do run the adjust cost item everyday..but the batch job did not clean up the values.
The costing method we use is Standard and FIFO on some items.
Do u have more hints??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