Prod. Order Restriction

[Former Member]

Hi xperts,

I want to restrict the multiple production order based on Sales Order Items.

Suppose i am having SO say 1001 which contains four items(finished goods) say I1, I2, I4, I5.

Now i raised Production Order by selecting the SO 1001 and i have taken only one item(finished goods) I2.

Then in second time if i select same Item for same SO it should not allow me to add production order.

i have written below query but unable to map it.

Select Distinct T0.Series, T2.Series, T0.DocNum, T2.DocNum, T0.OriginNum, T0.ItemCode from OWOR T0 inner join WOR1 T1 on T1.DocEntry = T0.DocEntry

inner join ORDR T2 on T2.DocNum = T0.OriginNum and T2.CardCode = T0.CardCode

inner join RDR1 T3 on T3.DocEntry = T2.DocEntry and T3.ItemCode = T0.ItemCode

Where T0.OriginNum = '67'

and T0.ItemCode = 'P10001'

Thanks

[kothandaraman_nagarajan]

Hi,

If you got the answer, please close the thread by marking correct/helpful answer.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi Team bone,

You can't use SP to block production order. Please consider the following points:

1. If any rejection for the part, how do you create new production order with the same part number and sales order number?

2. If same item repeats under sales order, then SP will not allow to create production order.

May be better option is to provide training to end user or may be go for approval process.

Please correct if anything wrong....

Thanks & Regards,

Nagarajan

[KennedyT21]

Hi Team BOne...

You can Use Tnsp to block...

Regards

Kennedy

[Rafaee_Mustafa]

Dear Bone,

Put a Store Procedure (Transaction Notification). Select the OriginNum and ItemCode into a variable and compare those variable into the query If Exists then it will notify you.

Regards,

Rafaee M