A
amber
I have an inventory report that has a running sum set up:
Date Requirement Type Quantity Available Qty
6/29/09 Intentory Balance 27,746 27,746
6/30/09 PO #123456 45,194 72,940
7/6/09 Planned Work Order 36,000 36,940
7/13/09 Planned Work Order 36,000 940
7/20/09 Planned Work Order 36,000 -35,060
7/27/09 Planned Work Order 36,000 -71,060
What I am trying to do is when the Available Qty gets down to less than
zero, a "Planned PO" line will be inserted with the Quantity being whatever
amount it will take to then make the Availability Qty zero (i.e. just below
the 7/20/09 Planned Work Order, a "Planned PO" line will be inserted with a
Quantity of 35,060 and a resulting Available Qty of zero...the next line
would then be the 7/27/09 Planned Work Order and just below that would be
another inserted "Planned PO" line with a Quantity of 36,000 and a resulting
Available Qty of zero). Any help is greatly appreciated.
Date Requirement Type Quantity Available Qty
6/29/09 Intentory Balance 27,746 27,746
6/30/09 PO #123456 45,194 72,940
7/6/09 Planned Work Order 36,000 36,940
7/13/09 Planned Work Order 36,000 940
7/20/09 Planned Work Order 36,000 -35,060
7/27/09 Planned Work Order 36,000 -71,060
What I am trying to do is when the Available Qty gets down to less than
zero, a "Planned PO" line will be inserted with the Quantity being whatever
amount it will take to then make the Availability Qty zero (i.e. just below
the 7/20/09 Planned Work Order, a "Planned PO" line will be inserted with a
Quantity of 35,060 and a resulting Available Qty of zero...the next line
would then be the 7/27/09 Planned Work Order and just below that would be
another inserted "Planned PO" line with a Quantity of 36,000 and a resulting
Available Qty of zero). Any help is greatly appreciated.