I usually do not deal with the financial side of Epicor but giving this my best shot.
Our “Accrued Manufacturing Expense” GL account keeps growing since our go live date. It is not consistent, some months it decreases and some months it will increase. We have ended up with a credit value of over $200k until someone noticed. I have combed through the account and the only thing that goes in there are actual accrued expenses. At receipt of goods we get a debit value, when entering the invoice we get a credit. We have no unpaid invoices, and everything received has been paid. So somehow we have overstated our Accrued mfg expense?
Does anyone have any experience with this and how to figure out what exactly has happened?
It looks like you are referring to Good Received Not Invoiced/AP Clearing account. This account get credited during PO receipt and debited on invoice. Run Received Not Invoiced report under Accounts Payable -> Reports and check the value. Ideally report value should match with the GL account.
I’d set the date range to the beginning of time (when you went live).
At the end of the report you’ll see all the transactions that went to this GL acct, including the offsetting trans.
In my example (which is of a Test Company, and not since the beginning of time) , there are about $33K more credits than debits to our Accrued Receivings acct (which is poorly named)
edit
Then run the GL Acct report for that acct. You shouldn’t see anything other than “Periodic Posting Process” entries. (might have to do this several times to span multiple Fiscal Years
edit #2
I incorrectly stated that you won’t see anything other than “Periodic Posting Process” entries. That was incorrect. You should see all the AP Inv entries too.
In the GL report search for “GJ” (for General Journal) to find any manually entered entries (JE’s)