NAV 2013 Calculate Rolled-up Material Cost
MiSta78
Member Posts: 3
Hi all,
I have a problem / question regarding the calculation of standard cost in NAV 2013:
Item A is a finished good with costing method standard. It has no routing and a production BOM with only one item, item B (raw material, costing method average). I use the standard cost worksheet to calculate the standard cost of item A.
Last calculation item B had unit cost of 100, standard cost of 100 and rolled-up material cost of 100. So after the calculation, item A also had
standard cost of 100 and rolled-up material cost of 100.
In the meantime unit cost of item B changed to 120. Now I use the standard cost worksheet again to calculate the standard cost of item A. The new standard cost and new rolled-up
material cost of item A is calculated to 120. Fine.
BUT:
I also want to update the standard cost and rolled-up material cost of item B. No matter how I try, it always stays 100.
This causes a problem i.e. in the report rolled-up cost shares. Here item B has material cost of 100 and in the total item A has material cost of 120. The difference cannot be
explained so easily.
Am I doing something wrong? Is there a way to handle this properly in NAV 2013? Or does this have a reason?
Thanks in advance
MiSta78
I have a problem / question regarding the calculation of standard cost in NAV 2013:
Item A is a finished good with costing method standard. It has no routing and a production BOM with only one item, item B (raw material, costing method average). I use the standard cost worksheet to calculate the standard cost of item A.
Last calculation item B had unit cost of 100, standard cost of 100 and rolled-up material cost of 100. So after the calculation, item A also had
standard cost of 100 and rolled-up material cost of 100.
In the meantime unit cost of item B changed to 120. Now I use the standard cost worksheet again to calculate the standard cost of item A. The new standard cost and new rolled-up
material cost of item A is calculated to 120. Fine.
BUT:
I also want to update the standard cost and rolled-up material cost of item B. No matter how I try, it always stays 100.
This causes a problem i.e. in the report rolled-up cost shares. Here item B has material cost of 100 and in the total item A has material cost of 120. The difference cannot be
explained so easily.
Am I doing something wrong? Is there a way to handle this properly in NAV 2013? Or does this have a reason?
Thanks in advance
MiSta78
0
Comments
-
Hi,
"roll up standard cost" function on the standard cost worksheet works for only produced items.
for raw materials (I mean purchased items), run "Calc. Standard Cost" batch on the item card.0
Categories
- All Categories
- 73 General
- 73 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 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