Physical Inventory Not Posted to GL

Epicor ERP 10
,
1

Just completed a full physical the end of November and we posted the adjustments. The adjustments show up in the PartTran table but some of them did not get posted to the GL.

Prior to starting the full physical, we un-allocated all of the parts for jobs, but there still were allocations for orders.

I have looked for non-nettable bins (no), warehouses, compared parts, part classes, product groups, and I cannot see what is wrong. Even went to see if there was a custom posting rule and I did not see anything strange in there.

Compared the PartTran to TranGLC and visa versa. No joy.

I am at a loss for where to look for reasons why or how to fix this. Was told this has happened in previous years, (I just started 8 months ago). Trying to get this fixed for next year.

We are on an old version (10.1.600.15) and are not paying for Epicor maintenance. Any assistance given would be greatly appreciated.

2

have you run the capture cost/wip process?

3

Accounting ran Capture COS/WIP prior to counting WIP on Weds before we started counting inventory on Thursday.

4

you will need to run capture cost/wip AFTER posting inventory to capture the changes that were caused by the inventory adjustements.

1 Like
5

Capture COS/WIP was ran 3 times by two different people after Posting the Counts.

image
image982Ă—595 12.9 KB

6

Thanks for replying BTW.

7

Does the total adjustment $$ value match the $$ change in your inventory GL account(s) and the inventory adjustment expense? The Posting Engine will not necessarily post adjustments to the GL for every single transaction that occurs. If there is no net change in GL account balances or if two transactions offset for the same part number, it can end up being a wash.
If the values don’t match, I would check the Review Journal to see if there are any CosWIP transactions that were stopped for some reason. There may be a missing GL control.
Finally, I would first confirm that the Count Cycle is listed as “Complete” in Count Cycle Maintenance and then run the Inventory/WIP Reconciliation report for the date(s) counts were posted on and confirm the adjustment value there matches the inventory movement report and Count Variance Report from the Cycle and that there are no Unposted transactions.

2 Likes
8

Thanks for the info. Passed it along to accounting and have not heard back from them. I can tell you the Cycle Count is complete and Inv/WIP Rec was ran multiple times that day and again after your message. Just waiting to hear about the adjustment $.