Batch traceability batch by batch in one process order

[Former Member]

Hi  guys

Now our plant will consume two batch raw material A (batch A1,A2) to product two batch finished goods B (batch B1, B2) in one process order. The relation between raw material and finished goods is that A1 product B1 and A2 product B2. But now I use BMBC to do batch traceability for batch B1, the batch A1 and A2 will be displayed. I only want to trace the batch A1. So how can I do this? By the way, I cann't split this process order to two process order , because i only know the total quantity of finished goods B.

[JL23]

What sense does it make to split the finished good into 2 batches if you do not even know the individual  quantity of those? If you assume the quantity, then you can split your order as well on this assumption.

And this assumption can usually be made based on the ratio between component issued and finished goods received.

[Former Member]

Firstly ,our plant is poultry industry. I don't know how many 30~40g Chicken wings will  be producted. But I know I want to the quantity of 30~40g Chicken wings. After production ,I will know the actual quantity of 30~40g Chicken wings by each batch of broiler. So i can't split my ourder on assumption. Maybe i will have 4~6 batch of broiler in one day.

[JL23]

But what do you expect from splitting the batches? and how do you add the quantity to your batches B1 and B2 if it is not on assumption?

[Former Member]

Maybe I haven't explain very clearly. I will list some example:

First , I have the requirement 1000KG for material 30~40g Chicken wings(material B). I know I have 3 batch broiler(material A) will be slaughtered. Batch A1 is 10000EA which average weight is 1.5KG, Batch A2 is 8000 EA which average weight is 2.0 KG, Batch A3 is 7000EA which average weight is 1.9 KG.But I don't know the quantity will be product by every batch. So I will create only one production order of material B which order quantity is 1000KG.After production finished, we know batch A1 product 300KG material B which batch is B1 and batch A2 product 550KG material B which batch is B2 and batch A3 product 150KG material B which batch is B3. These confirmation will be entered in one process order. When batch traceability for batch B2, the batch  A1,A2,A3 will be displayed in together. But the result we want to is just to display the batch A2.

[JL23]

you do not have a 1:1 relation, hence you cannot get this traceability. your relation is 3:3, so you get always 3 batches if you search with 1, in either direction of the search.

I still don't get it why you cannot create 3 smaller production orders. Is it just because you want almost no variation between planned vs actual quantity?

[Former Member]

There are so many reasons in this process. First, I don't know how many batch of broiler will achieve the order quantity of material B. so I don't know how many smaller order I should split to. Second, Process order is the production instruction for worker in the workshop. They only want to know the total quantity of material B. Many smaller order is confused to them. Third, the works can see the unfinished order quantity if we use one process order to manage it. Fourth, we will have more than 50 process order every day. If each process order need be split, the workload of schduler will be more high.

So i want to know if it can be traced 1:1 after do some enhancement.For example,

"You can use Business Add-In (BAdI) VB_GET_EXT_BATCHES to integrate additional

data sources in the batch where-used list."

[JL23]

you don't have external data here. External data means data that is taken from an external interfaced system.

You would need to write this info into table CHVW_EXTERN, which does not really make a bigger difference to the existing CHVW.

What you want is a kind of logic that shows the relation between B1 and A1

Can you phrase this logic? Do you store this relation somewhere?

A relation betwen B1 and A1 according to your example is the second character of the batch number. But this is probably just a simplification. So the question is how do you know which component batch relates to what finished goods batch? 

[Former Member]

Hi Mars,

Is there any impact on Batch Valuation? What Pricing method do you follow?

Apart from tracebility is there any driving factor for your requirement like Raw Material Planning (A1,A2...)?

Before devicing any solution, it is better to consider these aspects in view.

Regards

[Former Member]

Thanks for your kindly help.

We will do good issue of material A batch A1 and good receipt of material B batch B1 in the one confirmation all at once. So do batch A2 and batch B2 etc.

[Former Member]

I don't know if there is any impact on Batch Valuation.it's finance consultant's business.

Secondly, the BOM of material B will be very complex, so we don't have the MRP process for material A.