Hi All,
I receive a posting error when trying to capture COS/WIP activity because my inventory WIP reconciliation is not balanced. I found the source of the error in the review journal but I’m not sure how to fix it.
An employee used the “Receipt Entry” to clear old pack slips that did not show received by marking them as “received complete”. In one case, some of the lines result in a credit to AP-Clearing with no corresponding debit transaction, causing the imbalance. This item is so old (2013) that the indicated PO no longer exists in our system, so I get a “Purchase Order not on file for this Supplier” error when trying to make changes in Receipt Entry, and I haven’t figured out how to make changes in the Review Journal or elsewhere to fix the imbalance. Any suggestions on how to clean this up so that I can post the Inventory-WIP would be appreciated.
Welcome @nkleinsc !!
In the Product Group or Inventory COS/WIP GL Control Codes, do you have any accounts entered for the variance contexts?
Hi John,
We do have a variance account defined under the Inventory COS/WIP GL Control Code for the variance context. We don’t have any GL controls set up for the “Product Group” type.
That’s fine, the Inventory COS/WIP is the failsafe.
Can you create the PO Number? It is not ideal, but may be a work around.
If you don’t want to do that, you might have to create a ticket for a data fix.
Would I just replicate that PO number for that supplier, with the line items that were received, then change the value / GL control in the PO? Or how would I use that workaround? Thanks for your help
Yes, you could try recreating the PO with the same number if it is not already used. Use the same Supplier and make sure to use the same line (and release if there was one). Try it out in your test environment first.
The part in question - check it Part Class - GL Control entry and define the Expense context in it and try re-running the Recon WIP report (don’t forget to cancel the review JV).
KR
It doesn’t let me define my own PO number in that number range - the system wants to assign the PO number (unless I use a completely different range). Think I’m going to submit a ticket and see what they can do.
Thanks for the reply; I should have been more specific - the items on this purchase order were for an equipment purchase and these line items are for freight and other associated costs, so those parts don’t show as parts in the system.
Are the added as Misc charges? if yes, then check the GL Control definition for them.
Thanks for the suggestions everyone; Epicor did create a fix to delete those transaction lines. I ran the fix and the INV-WIP now balances, so the lines have been deleted. How do I now capture the COS/WIP activity?