production BOM costs
lanemark
Member Posts: 83
We currently use production BOM's for manufacturing some items. We have a problem though when it comes to checking prices of the BOM, when quoting for new orders because the cost on the item card shows last cost or unit cost, neither of which are an accurate cost of what the item will be next time we make one. Does anyone have an idea of how we get a report to show component costs.
We have been using Detailed last Costs report, this shows components costs as well as last cost, but if the BOM has some items which have BOMS themselves these prices could be wrong.
Alan
We have been using Detailed last Costs report, this shows components costs as well as last cost, but if the BOM has some items which have BOMS themselves these prices could be wrong.
Alan
0
Comments
-
How do you propose getting accurate future cost for you to base your quote on? :-kConfessions 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 -
I think we can only rely on our last cost for each component on the BOM from the item card.
The problem we have at the moment is, if we are quoting a new job and the potential order is made up of items that need to be manufactured, and therefore have a BOM, we cannot rely on the last cost on the item card of each assembly because we may not have made one for 2 years, so we need to see the projected cost based on current costs of all the components.
Alan0 -
Hi Alan,
The only way I got around this is to code it. It's not that bad - loop through the components and calculate fresh from the item card ( don't forget resources). I put this on the item and quote screen as info and it didn't effect performance.
Hope this helps0 -
An alternative function is to take a look at the Calc. Standard Cost function on the item card.
This process rolls up the cost for all levels in your production BOM. You may need to modify the process to look at the Last Direct Cost instead of the Standard Cost.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.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
- 329 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