My 2p about ERP Solutions, Information Worker Solutions and other software products (mainly Microsoft Dynamics AX and Microsoft SharePoint).

24 January 2009

Cost and Sales Price BOM Calculations

by Patrik Luca 4 comments

Tag



In Dynamics AX 2009, users can run BOM calculations to view the estimated BOM price on all BOM levels and update it on the BOM item.

To be able to run BOM calculations some basic data needs to be set up such as:

  • Calculation Groups
  • Cost Groups
  • Costing Versions

All of this is greatly explained in the Bill of Material in Microsoft Dynamics AX 2009 course in chapter 5.

Running the BOM calculation can be started up from different places, one of them being the item form.

Problem description: Price results of BOM calculations not stored by configuration

I got everything working as it should, except for BOMS with the item dimension configuration enabled. The calculated prices didn’t get stored by configuration although a configuration was entered upon starting the BOM calculation. As such, each time the BOM calculation was executed with another configuration, the previously calculated prices were overwritten.

Running BOM calculation for a specific configuration config. for BOM item BOM.

 

 

Prices are not calculated by configuration nor stored as such when you activate them.

 

 

Solution: configure the BOM item for using combination cost price

The BOM item should be configured properly to be able to store cost and sales prices calculated with the BOM calculation functionality by configuration. To do so, go to the item form of the BOM item. Select the General tab. Check Use combination cost price in the Item dimensions – Setup field group.

 

 

Rerun the BOM calculation and your calculated prices will be stored by configuration:

 

Comments 4 comments
Riyas said...

you have beautifully implemented daily inspired blog! great work!

Bariski said...

heya buddy.
http://woork.blogspot.com/2008/10/daily-inspired-blogger-template.html#comment-3728059714506822472

hope I can help:
http://i333.blogspot.com/ :)

see you there

Riyas said...

Thanks Bariski!!

Xier said...

Hi Patrik,

I tried to make the bom calculation, when I used standard cost version, I got infolog like:

calculating bom
The route for operation number 400 does not end in Zero.

I have checked all the route, they are ended in zero.

when I used planned version to do the calculation, then I cannot activate the price.

Can you help me what I shall do?

thanks in advance!
my email aaa510@gmail.com

best wishes!

jie

Patrik Luca, Ieper, BELGIUM
Feel free to use or spread all of the content on my blog. In return, linking back to my blog would be greatly appreciated. All my posts and articles are provided "AS IS" with no warranties.

Subscribe feeds via e-mail
Subscribe in your preferred RSS reader

Subscribe feeds rss Most Read Entries

Subscribe feeds rss Recent Entries

Categories

Recommended Books


Subscribe feeds rss Recent Comments

This Blog is part of the U Comment I Follow movement in blogosphere. Means the comment field of this blog is made DOFOLLOW. Spam wont be tolerated.

Live Traffic Feed

Recent Visitors

Blog Archive

My Blog List

Followers

Guest Links