A
amber
I have a report that shows inventory activity. It starts with the beginning
balance and shows, in order by date, activity such as work order consumptions
and purchase order receipts. I have a running sum set up. What I would like
to know: is there a way I can have this add a row in the report when the
running balance gets to below zero to show a "planned order" amount, and then
include that in the running balance itself?
Example:
Amount Cumul Total
Beg Inv 20 20
Work order -10 10
PO Recp 20 30
Work order -50 -20
*Planned PO* 20 0
Work order 10 -10
*Planned PO* 10 0
Where *Planned PO* is the line added.
Thanks!
balance and shows, in order by date, activity such as work order consumptions
and purchase order receipts. I have a running sum set up. What I would like
to know: is there a way I can have this add a row in the report when the
running balance gets to below zero to show a "planned order" amount, and then
include that in the running balance itself?
Example:
Amount Cumul Total
Beg Inv 20 20
Work order -10 10
PO Recp 20 30
Work order -50 -20
*Planned PO* 20 0
Work order 10 -10
*Planned PO* 10 0
Where *Planned PO* is the line added.
Thanks!