Part Transaction History Tracker

[ypgpatel (Yash Patel)]

Is there a formula to get the running total column values of all transactions pulled into a BAQ?

[andrew.johnson]

In general, I think you will need a calculated field to calculate the sum of TranQty by the TranNum or TranDate, something like: SUM([TranQty]) OVER (ORDER BY [TranNum])

But you will need to take the TranType into account, so there would be some CASE WHEN… ELSE… involved.

[djonason (Darius Jonason)]

I don’t know how to do that directly in a BAQ, I have to export and do it in Excel. but one thing to watch out for is that not all PartTran rows mean the same thing by quantitiy. for example a Positive MFG-STK tran increases inventory. A positive STK-MTL tran decreases inventory. A negative STK-PLT tran increase inventory…

[danbedwards (Dan Edwards)]

Did you take a look at this thread? I believe it answers your question.

PartTran BAQ: Calculating the "Running Total" of the History Tracker

Ignore the Before and After Qty’s. You’ll have to use some moderately tricky techniques in the BAQ to make a running sum. Something like a “Sum over Partiton” Search this site there’s some examples on running sum.