item costing

patrickm

I have the following scenario

i purchased the same item with two different prices. i am going to use the whole quantity i purchased in a production order. how can i get the correct costing of the item? ex. i bought the same item for 10c and 20c. together with another item which cost 30c they make up my BOM. the costing should be 10+20+30 = 60c. but AX is giving me a different cost price using FIFO. Can anyone advise how i manage to get the correct price to clacualte my cost? i hope i explained myself well

thanks
patrick

AdamRoue

What version?

The BOM calculation will take the current average, it will tell you the cost. To get the cost you want you need to actually process through production, complete the picking list, end the production order and then run the inventory month end. This should then reflect your cost, although in fairness in your example it would work anyway as the average is 20 and you use 3 so the cost is 60!

patrickm

the version is AX4. so to confirm that i understood you correctly, i have to do the recalculation of the stock after the workorder to update the item cost. this means also that if i have to do another workorder i have to recalcualte the bom to re-evaluate the BOM. this will reflect the item cost updated from the previous stock recalcualtion.

thanks
patrick

AdamRoue

Essentially no.

The updating of the item cost depends upon the settings on the item card.

To update the cost of the finished goods item only where the cost differences of the FIFO differ from the actual will be handled by the month end routine.

The next works order simply takes the latest cost if you are set to do this, or the cost defined, and the actual cost in teh ledgers is adjusted as required through teh month end process.