GL inventory Balance Larger than Qty On Hand * Standard Cost

Epicor ERP 10
1

At the end of the month we have a GL balance for our raw inventory that is larger than the on hand total * standard cost.

Is there any way to drill into this? I am lost as to why the balance is larger than what the on hand total is at the end of the month. We are using partbin.onhandqty * standard cost to get the value of on hand inventory.

2

I would start drilling down to one part number’s inventory, and analyze that. If there is no difference, then find the parts that have the difference. If there is a difference, what is it?

3

Question is Andris, how do I drill down on one part’s affect on the GL account throughout the period that I am analyzing?

I keep hitting this periodic posting transaction… I am trying to understand how to get into that detail. I know TranGLC and GLJrnDtl, but I am still having trouble tying out the journal entry with the tran GLC transactions.