Creating Lines in Requisition Worksheet

Elie

Even if the item is in stock or part of the quantity sold is in stock, they want the Calculate Plan function to create a Requisition Line to replenish the quantity of items sold from stock at a Direct Unit Cost of 49% of Unit Price. The Requisition Line for the replenishment would be a separate line from the Requisition Line that is tied to the Sales Order by a Reservation.

For example, if the Sales Order is for a quantity of 10 and 10 are in stock, the Requisition Line would be for a quantity of 10 and would not be tied to the Sales Order by a Reservation. If the Sales Order is for a quantity of 10 and only 4 are in stock, then there would be two Requisition Lines—one for 6 which would be tied to the Sales Order by a Reservation, one for 4 to replenish stock and would not be tied to the Sales Order by a Reservation.

Any Ideas on How can I do that?