So if you look at the Part Transaction History Tracker, it shows you a running total of inventory based on the quantities and transaction types. I have the inventory transactions tech ref, but it doesn’t describe the sign changes as to how to use it to calculate the running total. For some analyti…

There is a technical reference guide called “Hierarchy of Inventory Trans” that you can grab from EpicWeb and that will help a lot to understand all the Transaction Types.

@mchinsky i am not sure if this what you looking for, but this is my BAQ to calculate inventory/stock values as per selected cut off date [image] Stock Status Report - Zero Value on Part ERP 10 Bev_StockStatus.baq (41.8 KB) My Stock Status BAQ to calculate Running Total …

So looking at your query, are you saying basically to ignore all transactions unless they have STK on one side or the other of the transaction type with the exception of Adjustments?

if you only want to know the Stock level, then yes i tested it in my environment against the running total in Part Transaction History, for many parts and it gave the correct answers, you more than welcome to check/validate the principle in your environment and correct it if applicable, please let m…

Calculate Inventory running total

Epicor ERP 10

markdamen (Mark Damen) July 25, 2019, 2:02pm 2

I’m sure there has been a newer post on this topic, but here is one where @josecgomez provided a -1, 0 or 1 against each Tran Type indicating what effect it has to stock.

Topic		Replies	Views
PartTran BAQ: Calculating the "Running Total" of the History Tracker Epicor ERP 10 e10 , epicor , baq	25	9534	April 14, 2020
I want to know how epicor calculates inventory at any point in time? Epicor ERP 10 e10 , epicor , bpm , customization , baq , dashboard	10	2561	August 25, 2023
How to deal with backdated transactions on running totals Epicor ERP 10 e10 , epicor , baq	1	872	August 25, 2023
Inventory Balance at a Date Epicor ERP 10 e10	1	1344	March 9, 2022
Part Transaction History Tracker Kinetic ERP parttran	3	2155	February 8, 2023

Calculate Inventory running total

Related topics