Stock Status Report

We are using Epicor 9.05. and there is a negative balance on my stock status report and I am unclear as to where it is coming from. We made adjustment and had to reverse them because they were in the wrong period. The reverse of those transactions took place (in that period) and the transactions that should have been completed in the current period were done. Does anyone know what could have caused a negative balance on the stock status report when the cut-off was for the current period?

Qty Adjustments lets you pick a Date and fat fingering the date is quite common. So someone might have added a Qty Adjustment with a date of let’s say 2090. Since the Stock Status Report is an “as-of” report, it will go for many years into the future.

If you go to one of the Part Tran, Transactions, History trackers - don’t set a cut-off date and see if you can find a Transaction way out there, light-years away.

Or create a BAQ and run it

SELECT * FROM Erp.PartTran WHERE TranDate >= '01/01/2020'

Additional Reading:

So regardless of the date selected, if there are transactions in the future they will be included? Is this correct?

The transactions to me should not show. I am still wondering what causes the negative balance.


Yes, if you read the Stock Status Date field it says

Stock Status as of: Date. It is not a cut-off date. For example:


Means: 1/4/2019 - 1/1/9999 (As of 1/4 to forever)

If after setting the cut off date in Part Tran History Tracker to some year of 2999 or greater and it still doesn’t find the rogue transaction, run conversion program 6430. We run this conversion program 6430 once every month to balance our transactions.

How epicor is calculating MtlUnitCost and MtlBurCost Plant wise.