Finding the DMRHead record creation date

[ckrusen (Calvin Krusen)]

If you search this site, you’ll find a list of the sign (-1, 0, or 1) to use as a multipler for each transaction type.

edit

see this post. It’s probably not all the trantypes…

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

@Alice_Elizabeth Make a CalcField SignedTranQty with expression (case when PartTran.TranType IN ('STK-ASM', 'STK-CUS', 'STK-INS', 'STK-KIT', 'STK-FAM', 'STK-MTL', 'STK-PLT', 'STK-STK', 'STK-UKN', 'STK-DMR') then -1 when PartTran.TranType IN ('ADJ-CST', 'ADJ-QTY', 'AST-STK', 'DMR-STK', 'INS-STK', 'MFG-STK', 'PLT-STK', 'PUR-STK', 'STK-STK', 'SVG-STK') then 1 else 0 end) * PartTran.TranQty Then another Calc field RunningQOH with the expression SUM(SignedTranQty) OVER (Order By …