Weighted average cost method -

kartik5295
Member Posts: 2
We are using NAV 5.0 Version.
As per Inventory Set up, the average cost calculation type is 'Item & location & Variant'.
Average Cost Period is Day.
the following is the inventory ledger of a part no.
posting date Document No. Entry Type Item No. Location Code Quantity Cost Amount (Actual)
19-Oct-10 M-SFTR01810 Transfer IN960023 U1 PROD 4 227,917.25
26-Oct-10 M-SFTR01833 Transfer IN960023 U1 PROD 1 57,451.93
26-Oct-10 RC-02816 Consumption IN960023 U1 PROD -4 -228,295.34
the weighted average cost is (227917.25+57451.93) / (4+1) is 57073.84
The receipt of 4 qty entry has been applied to the issue entry.
but still the cost do not match.
Can anyone help me understand what could have gone wrong?
As per Inventory Set up, the average cost calculation type is 'Item & location & Variant'.
Average Cost Period is Day.
the following is the inventory ledger of a part no.
posting date Document No. Entry Type Item No. Location Code Quantity Cost Amount (Actual)
19-Oct-10 M-SFTR01810 Transfer IN960023 U1 PROD 4 227,917.25
26-Oct-10 M-SFTR01833 Transfer IN960023 U1 PROD 1 57,451.93
26-Oct-10 RC-02816 Consumption IN960023 U1 PROD -4 -228,295.34
the weighted average cost is (227917.25+57451.93) / (4+1) is 57073.84
The receipt of 4 qty entry has been applied to the issue entry.
but still the cost do not match.
Can anyone help me understand what could have gone wrong?
0
Comments
-
Run the Adjust Cost - Item Entries process before you do any inventory analysis.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0
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