I am working for an end user using AX 2009 that has a large number of products with LOTS of colors assigned to each for the purpose of having configurable color selection all over the bill of materials. There has been a noticeably large number BOM calculation tables add as a result of the numerous colors and using "costing by dimension". This is the equivalent of costing by variant in 2012. To get the situation under control I have proposed deactivating costing by dimension combination since the paint, while it varies in cost, is not a key contributor to the cost of the products.
This is where things are getting dicey. The functional users are looking for some kind of middle ground between a single cost and costing by dimension combination. While this is admirable I don't see how it's possible out of the box. I have two reasons for writing this post.
- I'd like to know if I'm wrong and what they're asking for is actually possible without extensive modification.
- I'd also like to know if the functionality regarding variant costing is any different in 2012 r3 or ax 365.
What I have been telling the end users is that by default the combination cost price is deactivated. With this setting there will only ever be one active cost price regardless of how many colors have been added. If somebody checks the combination cost price and activates then there MUST BE a price for each and every color variant.
The end users are proposing that we set a generic price that is colorless and then create a couple more specific prices for key colors in the mix. Or their alternative is to calculate a cost price that runs the average of all colors and sticks it in a single cost price record. The BOM and route versions offer the ability to create version records without a color that work broadly when a more specific one doesn't exist, but I haven't seen anything to suggest that this sort of approach would also work with costing.
Is costing variants EACH or ALL like I suspect it to be or is there another approach that can be used as a hybrid?
*This post is locked for comments
I have the same question (0)
