Hi there, I’m new to Epicor and for my company I’m responsible for al the BI reports. Now I’m trying to make a BAQ in which I can calculate the stock movements from all the parts and also calculate the stock on hand on a specified date. The BAQ is to load the data to our datawarehouse and do the st…

ah ha! this one starts at the beginning of time and counts forwards [image] Stock Status Report - Zero Value on Part Epicor ERP 10 Hi All, we are newly live on Epicor and I am trying to reconcile the stock status report to my Inventory account. The main thing that is thr…

You would need to look at the specific tran types to see what transactions are actual on hand movements. There is a section in the Kinetic help called ‘Understanding Transaction Types’ that should help with this :+1: [image]

Yes, my understanding was that it should be a combination of TranClass, InventoryTran and TranTyp. Maybe I’m wandering if anyone has a table or a if-statement in which you should increase/decrease/neutral to the stock

Somewhere on this website is a BAQ example of exactly what you’re looking for. I just can’t find it. I used it to make a baq that could show us how many times we ran out of stock in a certain time frame so I know it exists. Search all of the threads for Stock Status and you will probably come across…

Thanks a lot. I’ve used the subquery from the BAQ from Banderson and made my own one. I used his Calculated Field for TransactionQuantity (determine if it should decrease/increase). Also I’ve filtered a lot of TranTypes out of my query (see below). I managed to calculate all the correct Quantities f…

BAQ Stock movement

Kinetic ERP

cpilinko (Christian Pilinko) August 28, 2025, 12:18pm 5

ah ha!

this one starts at the beginning of time and counts forwards

Banderson modified it here to count backwards. I counted forward for mine and it arguably has issues so I would take a look at this one.