LittleJohn
26th April 2005, 08:20
Hi,
I need some guidance for the below scenario. This is in Baan Vc.
I have a Production Order, 1.. with 10 pieces on it.
At some operation I send it out for subcontracting. (Created a Purchase Order and the respective data is linked in the tdpur451 & tdpur402 tables).
Only 4 pieces came back from subcontracting.
When I recieve the 4 pieces from subcontracting, since its a partial, there is a back order created for that Pur ord line. A new sequence is created in the tdpur402 table. (session tisfc2410m000, helps a bit).
At this time, We create a brand new production order of 6 pieces, for the same item on Production Order 1. Then, We transfer 6/10th of material, labor and costs to the new prod order , # 2. All Quantities on the Order # 1 are adjusted to 4, including the planning. Estimated Quantities & the Planned Inv Qty is also adjusted. So.. at this point... the Order # 1, which started with 10 pieces... looks like it started with 4 pieces to begin with.
(The reason why we are doing this process of splitting... we'll get to that later :) )
Since, from the qty standpoint... I've received 4 from subcontracting and satisfied this order... this order can move on. The new order # 2, will wait till we receive the balance material of 6. The problem is, since the Purchase order is linked to the Prod Order #1, I cannot receive these subcontracted materials against the production order #2.
IF.. ahem :D , I change the Production Order number in the tdpur402 table, thru GTM, from 1 to 2 (old to new)... I can receive the balance Qty for the new production order. The system lets me do this. (I can close the order # 1 without any errors as well).
My concern is... Am I missing any other tables (in wh/td/ti) or am I messing up any data.
Please advice. Thanks
Regards
LittleJohn
I need some guidance for the below scenario. This is in Baan Vc.
I have a Production Order, 1.. with 10 pieces on it.
At some operation I send it out for subcontracting. (Created a Purchase Order and the respective data is linked in the tdpur451 & tdpur402 tables).
Only 4 pieces came back from subcontracting.
When I recieve the 4 pieces from subcontracting, since its a partial, there is a back order created for that Pur ord line. A new sequence is created in the tdpur402 table. (session tisfc2410m000, helps a bit).
At this time, We create a brand new production order of 6 pieces, for the same item on Production Order 1. Then, We transfer 6/10th of material, labor and costs to the new prod order , # 2. All Quantities on the Order # 1 are adjusted to 4, including the planning. Estimated Quantities & the Planned Inv Qty is also adjusted. So.. at this point... the Order # 1, which started with 10 pieces... looks like it started with 4 pieces to begin with.
(The reason why we are doing this process of splitting... we'll get to that later :) )
Since, from the qty standpoint... I've received 4 from subcontracting and satisfied this order... this order can move on. The new order # 2, will wait till we receive the balance material of 6. The problem is, since the Purchase order is linked to the Prod Order #1, I cannot receive these subcontracted materials against the production order #2.
IF.. ahem :D , I change the Production Order number in the tdpur402 table, thru GTM, from 1 to 2 (old to new)... I can receive the balance Qty for the new production order. The system lets me do this. (I can close the order # 1 without any errors as well).
My concern is... Am I missing any other tables (in wh/td/ti) or am I messing up any data.
Please advice. Thanks
Regards
LittleJohn