Hello,
I am trying to create a report that displays balance impacting
inventory transactions. I can easily pull the current on-hand balance
in one query and the transaction history in another query. However, I
am struggling with putting these 2 queries together for a report that
looks like this:
PartNum TransDate Transaction Qty CurrentBalance PrevBal
ABC 11/01/05 Shipment 5 50 55
ABC 10/31/05 Receipt 20 55 35
ABC 10/28/05 InvAdj -3 35 38
ABC 10/15/05 Receipt 10 38 28
ABC 10/14/05 Shipment 10 28 38
ABC 10/10/05 Receipt 30 38 8
Obviously the PrevBal is the same as the CurrentBalance from the
previous transaction. I want this report to calculate backward into
history because all I have is the current balance and the historical
transactions.
Any help is appreciated.
Thanks,
rxfrenc