Query to show Inventory Quantity Adjustment Before and After

Kinetic ERP
1

I would like to create a BAQ that shows the Quantity Adjustments from the previous day. The users would like to see the OnHand Before and After (adjustment quantities).

I thought there might be a couple of fields in the PartTran that showed at least the “Before” qty - then i could calculate the new Qty - however, i do not see that in PartTran.

Is there a PartHistory table somewhere?

Thanks,
DaveO

2

I believe you’ll need to do the calculations in the BAQ. Take the PartWhse.OnHandQty and a subquery calculating the amount adjusted on PartTran. You just looking for ADJQTY tran type?

3

Mr. Randy: I had not thought of that.

Yes i am just looking for ADJ-QTY.

I could do the math to take out the adjustment. My concern is my plan is to send this as a report late at night and there may have been multiple transactions INV-CUS etc that happened during the day - so the “Previous” qty may not match the Part Transaction History tracker.

DaveO