Another issue for our new controller. Over the last few months, GL inventory has dropped dramatically and I am trying to track down the issue. Using November 2024 as an example, the stock status from beginning of the month to end of the month shows a decrease of $12,000. The GL account shows a decrease of $224,000. I ran the material transaction detail report and reviewed all the associated transaction types and that shows a decrease of $242,000. Is there anywhere else that I can see what affects the trial balance? I know inventory and cost adjustments can sway these numbers but it has happened several months in a row.
Do a BAQ on GLJrnDtl for the inventory GL account(s). We’ve had similar trouble figuring out the numbers on inventory, sales and cash accounts. Usually ended up being a GL mapping issue in a particular area (i.e returns, cost of returns, etc) - either an incorrect or missing value for a partclass or product group.
2 Likes
Thanks for the reply John. I ran the BAQ you recommended and see the same numbers. There are a couple of odd ball cost and qty adjustments but otherwise mostly PUR-STK and STK-MTL (backflush) transactions. Makes me think it is something not posting to the inventory account which would most likely be purchasing. Is there somewhere on the non-GL side that I can see the purchasing transactions?
PartTran is the table for the inventory transactions.
The GLTrnDtl BAQ should show anything hitting the account - journal entries, unexpected transaction types (PUR-UKN for example).
BAQ tip…specifically look at SegValue1 for the inventory account…that’s how we found some issues in our sales transaction mapping where certain partclass/productgroup assignments were missing/incomplete.
Example: Segvalue1=‘123456’, Segvalue2=‘500’, Segvalue3=‘300’…the full GLAccount value SHOULD have been “123456|500|300” but instead was only “123456”…so we had to get a datafix to remedy that problem on future transactions (with JEs required to clean up the past).
1 Like
Take a look at this KB0039633
This will help you with joining the Parttran table to the tranglc, which is the table that stores all the GL transactions in it. You will find this will help you tracking down any issues.
I’d also run the inventory/WIP recon as well by transaction type to see if you see anything there… What typically happens is you will have a the same account on a multiple GL controls that effectively cancels things out and then stuff goes missing.
There was fine post by @gpayne, but for the life of me I can’t find it.
1 Like
here is what we use, but you may have to fit to your data. This balances to the gl accounts even when stock status may differ.
Stock status looks by warehouse and Epicor specifically states it is not a subledger balancing report. The GL uses the hierarchy regardless of warehouse. We use Part Class, so that is what the baq uses, but your hierarchy will dictate how you need to link things.
Some who work for us assume when you move a quantity into a finished goods warehouse it will be in the finished goods GL account associated with that warehouse, but Epicor doesn’t care about location only the GL controls.
StockStatusClink.baq (53.4 KB)
2 Likes
Thanks for all the assistance. I am going to dig into this further but I am dealing with a time period handled by an ex-employee that tended to do things her own way and then the new controller that during her training, they weren’t checking the “Post COS/MFG Variance” box in the capture process. Thinking the problem was in the costing/backflushing, they were making manual transactions for what was missing. Making it very hard to track anything down.
I am utilizing what I have learned to create a better way of making sure that the GL stays close to the Stock Status and WIP Report. Thanks again.
1 Like