Skip to Content
Former Member
May 06, 2013 at 06:02 AM

Prod Order


I want to restrict the Product Order to be raised in below condition.

for a sale order say 101 which contains 3 item say Item1, Item2, Item3.

Then Prod order should be raise for sale order 101 and for item1 only once. Means

Multiple production order based on a sale order for an item(finished goods) should be blocked..

Can anybody let me know how can i achieve this via Stored Procedure.