Help with Running Total Logic in Part Transaction History Tracker (BAQ)

[Mark_Wonsil]

In the PartTran record, there is a BeginQty and an AfterQty. I imagine you could find the last AfterQty on the previous day and use that as a starting point and then add/remove the delta between those fields.

As for doing the running total, you can use Window Functions in SQL as done here:

Running Total BAQ

I am trying to do a BAQ with a running total. The column I need as a running total is called “Month To Date Shipped”. I exported the BAQ so if anyone could help me I would appreciate it. GS_RPT_Daily_Invoices.baq (33.0 KB)