Dynamics Community Forum Thread Details

Tracking of active ingredients within purchased products through intermediate products to final product.

I have a particular challenge I could do with the communities guidance with! Considering the example below please could anyone advise on what functionality could be used to manage it.

Example:

I purchase a batch of Product A from a supplier; and this product is batch controlled.

I buy 100 kilo's of Batch123 and I invoice the 100kg's. However within this product there is 10.21kg's of "active ingredient 1". The level of active ingredient changes batch by batch and the amount can be entered when a batch is receipted in.

I use 10kg's of batch 123 to make 100kg's of an intermediate product; Product B Batch 456. Because I consumed 10kg's, I can calculate that I consumed 1.021Kg's of the active ingredient. After I made Product B; Batch 456, I consume the10KG's from stock. Batch 456 now contains the 1.021KG's of active ingredient.

I now use 100% of Product B; batch 456, to product my saleable product; product C Batch 789. I consume 100% of Batch 456 from stock and now Batch 789 contains the 1.021kg's of active ingredient.

Requirement

On receipt of a raw material i need to be able to enter the batch, and amount... but I need to enter the "assay" or amount of active ingredient in the receipted batch.

When I use any amount of the raw material batch, I need to be able to trace the proportional amount of the batches active ingredient that then passes to the next batch in the process. I must not have a manual calculation or entry to do at this stage, this must be system driven.

When I consume the intermediate product to make my final saleable product, again I need to be able to trace the proportional amount of the batches active ingredient that then passes to the next batch in the process. I must not have a manual calculation or entry to do at this stage, this must be system driven.

I must have this information in a formal where i can generate a powerbi report that shows me the amount of active ingredient i have by site.

Current Considerations/challenges

1) I've looked into caught weight functionality but I feel the invoicing would be an issue, and I believe this would be a manual solution

2) I've considered using quality orders, batch attributes and inheritance but i don't believe i can inherit a proportion of an attribute

3) There is not a standardized amount of active ingredient in each batch, and it needs to be traced to the gram for regulatory purpoises.

Any help with this challenge would be greatly appreciated!

Hello KieranMoss,

Cant you call that batch attricute PctPotency and track it as a percentage (or concentration)? And then use batch inheritance on the formula so that the intermediate product inherits the to pass the PctPotency to the intermediate product batch and its saleable product.

Otherwise, I do not think you can avoid a personalistion for that requirement. I am sure that if we were to ask for use cases, you would have different cases of various complexities where different batches of Product A are used for the same Product B or different batches of Product B are used to make Product C...

Rather than <Batch Attributes>, I would personnaly lean towards a new tracking dimension <weight active ingredient> that for Product A has its value fixed by product receipt of batch (just like the batch number).

For Product B and C, that <weight active ingredient> would have to be calculated based on proportions used from the various batches consummed.

I prefer Tracking Dimesnion over batch attributes because I find it much more accessible. You would be able to display on the Inventory On-hand just like any other inventory dimensions.

There are extendable inventory dimensions available, well, for extensions. : docs.microsoft.com/.../inventory-dimensions

They can be activated from License Configuration (under the node <Trade>), but logic must be developped to make them work properly.

Quick Links