Supply chain | Supply Chain Management, Commerce

Cost calculation with track and trace serial and batch numbers for manufacturing.

(1) Share

Report

Posted on by Peter Kulikov (N.pr...

Hello experts!
I was exploring the new feature in manufacturing process which has been in general availability (but in preview) since June 7^th (10.0.40). If you aware about this feature it makes possible to track and trace serial and butch numbers of components used in production and link them to serial and batch numbers of finished goods (even for production orders with quantities exceeding one unit).
I find this feature very promising to reduce efforts and labor during manufacturing accounting. But in the course of my investigation, I came across the problem of calculating the cost of finished products.
Let me share the details of the case I’ve tested.
First of all, I created a BOM:

Then, I invoiced purchase orders for all components. I’ll not share all of them here, but only one where I brought the same item (PM8002) in different price. Also, for this Item I’ve created a special Tracking dimension group where Batch Number dimension used for Financial inventory:

And those are transaction details for the components I used in manufacturing:

So, as you may see there are different cos amounts for different Butch Number.
Then, I’ve created a production order for 2 units. This is the Picking List journal. You can see the same Butch numbers in it:

Using the new “Tracked components” form I’ve associated finished goods with serial and butch numbers of components (finished goods also has the Tracking Dimension group with financial inventory for Butch number dimension):
First piece:

Second piece:

I’ve processed the production order for the End status to calculate cost amounts for finished goods. But both pieces have the same cost amount:

If we are going to take a look on financial voucher then we’ll see that material costs are absolutely the same for both lines and calculated as average cost for PM8002 item instead of FIFO like it settled in Item Model Group.
So, from my point of view looks like it doesn’t work correct. Does somebody have opinion on this case? I’ll be please on any assist with this question, because without correct cost accounting it seems useless.

Categories:

Production Control

All responses (4)

Answers (0)

PK-21061314-0 on at

Like (0)

Report

Cost calculation with track and trace serial and batch numbers for manufacturing.

Hi Andre!
Yes, both items have the same Tracking dimension group:

And this is the inventory transaction lines. They do have unique Batch and Serial numbers.

Actually, as I aware, without this feature cost accounting for finished goods calculated as average (summarize all costs for raw materials consumed and then divide on the amount of finished goods) That’s why it was crucial to create one Product order for each unit of finished goods to get the correct cost.
André Arnaud de Cal... 283,860 Moderator on at

Like (0)

Report

Cost calculation with track and trace serial and batch numbers for manufacturing.

Hi Peter,

Both items, finished goods and the BOM item have the same tracking dimension group? Then even without the new feature (I haven't tried it myself yet) I would expect an adjustment during a recalculation. Does the production line inventory transaction now also have different batch and serial numbers?
Peter Kulikov (N.pr... 33 on at

Like (0)

Report

Cost calculation with track and trace serial and batch numbers for manufacturing.

Hello Andre!
Thank you very much, I'll read the article you suggested, but actually I did run recalculation for this one item PM1002 right after I saw that the cost amount is calculated as average:

But the result I saw on “on-hand inventory” list is still the same:

Maybe I did recalculation wrong.
Suggested answer

André Arnaud de Cal... 283,860 Moderator on at

Like (0)

Report

Cost calculation with track and trace serial and batch numbers for manufacturing.

Hi Peter,

Thanks for the well-documented question. I would suggest reading more about inventory costing where closing and recalculation is a mandatory step when using an actual costing method like FIFO.
When using FIFO, initially it takes an average price as you described. When running a recalculation, it will make adjustments according to the settings of the item model group and inventory dimension setup.

You can read more here: FIFO with physical value and marking - Supply Chain Management | Dynamics 365 | Microsoft Learn