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

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.

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-…

Did you take a look at this thread? I believe it answers your question. [image] PartTran BAQ: Calculating the "Running Total" of the History Tracker ERP 10 Ignore the Before and After Qty’s. You’ll have to use some moderately tricky techniques in the BAQ to make a running…

Part Transaction History Tracker

Kinetic ERP

danbedwards (Dan Edwards) February 8, 2023, 12:54pm 4

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

Topic		Replies	Views
PartTran BAQ: Calculating the "Running Total" of the History Tracker Epicor ERP 10 e10 , epicor , baq	25	9555	April 14, 2020
Running Total Error BAQ: Part Tran History Kinetic ERP	13	2406	February 23, 2023
Running total Epicor ERP 10 e10 , epicor , baq	7	950	August 14, 2023
Error on Running Total: Part Tran History Kinetic ERP baq , dashboard	7	1544	August 10, 2022
Calculate Inventory running total Epicor ERP 10 inventory	5	5525	July 25, 2019

Part Transaction History Tracker

Related topics