The reason for the missing debit leg is that cost adjustment was not done to reflect the unit cost. Note: All the part class and product group GL control code is in place. In fact, other transactions pertaining to this part for other plants did not pose any GL related issues.

Question: How do I proceed to posting the transactions although it is unbalanced? I would like to do so since WIP posting is a batch posting and because of this error, other transactions could not be posted. Once the posting is done, I will create a one legged GL transaction for the debit amount.

Popular White Paper On This Topic

Future plant transfer are ok now.. i.e it resulted in a balanced transaction. Now, the issue is how to proceed with the past transaction which is unbalanced. I have tried running COS acitvity and generate the report but the GL does not get updated. Help please?

Since you know what is wrong and how to fix this transaction, I'd
a) Post it unbalanced, and fix it in the GL by allowing temporarily one-sided JE's
b) Fix the underlying structure so it doesn't happen again.

I believe if you just post these WIP/INV transactions, the unbalanced one will post. You may have to turn off the block unbalanced JE's in the company/finance/General Ledger setting to permit this unbalanced entry to post..

Then with the block unbalanced JE's unchecked, you can enter an imbalanced JE manually entering the missing value/account..

Usually not having done the cost adjustment would not cause this issue. You are missing a GL account in one of your GL Control codes. You cannot do a one side journal exception for posting COGS/WIP so either find the missing GL account or call Epicor support, They will ask you to send a copy of the WIP Reconciliation report to see where the missing debit is coming from

Carl, I have tried your suggestion (i.e change the company config to allow unbalanced transaction). However, as what I had thought, the posting still does not get through as the setting is for manual journal.

mjfw2003 (sorry to address you by this manner as I am unsure of your name), strangely, after i perform cost adjustment, my future transfer orders balances. This is without alteration to the plant settings for the transfer orders (which I have checked is correct)

In terms of GL control code, system gets the code from Product Class and Product group. This was not altered (i.e setup is correct as the past part transactions involving inventory accounts went through).

I am at dead end as to how to proceed with this. Hope you can shed further light on this.

You should never try to buck the system and post one sided transactions - it will bite you back later on - when trying to post you will have found the entire journal going to the review section - detailing out where and why. if you cannot work this out then clear from review and try posting again whilst running the trace this should enable you to find which of the posting rules is being called with the error.

The GL Transaction type CosANDwip calls alot of different booking rules and functions regarding to plant and the trace will guide you to the right one to investigate

Your are performing a plant transfer to stock so naturally there are stock transactions and you rightly have looked at the Inventory Cos and Wip, Part Class and Product Group GL Controls -

but have you checked the GL Controls for Plant Transfer you have the options to set account combination strings for each of the following contexts -
AP (To Plant)
AR (From Plant)
Consolidated Division
Contra AP
Contra AR
Contra Asset
Contra COS
Contra Revenue
In Transit (From Plant)
Transfer Variance (To Plant)

Hi Chris, appreciate your detailed explaination. Yes, the GL control for the plant transfer has been properly setup. In fact, other parts which has been transferred to this plant did not result in unbalanced transaction. Only for one particular part.

As mentioned, after I had done the cost adjustment, subsequent plant transfer (using the same part) to the mentioned plant did go through with a balanced posting.

What I cannot deduce is that this seems to be an isolated issue..affecting one part only.

Run your WIP Reconcilliation report and export it to excel. Sort it by transaction type and look for that part number and find its offsetting transaction and see if there whether there are $ reported against one transaction (debit or credit) and not the other

There have been times where I have had this issue and it usually has something to do with different periods posting against the offsetting transactions. I called Epicor support, sent them the WIP report, and they were able to send a fix for it

I had ran the report and it was clear that the unbalanced transaction is due to PLT-STK (i.e there is CR to Inventory-In-Transit account but not debiting the Inventory account). It should not be due to offsetting transaction because if it is, in this case, my Inventory-In-Transit account should be the affected one.

If you have done these transactions before without any issue, I could see where perhaps a new part class did not have the GL Account , but even if the new part was missing a part class, it would still get the inventory account from your default COS/WIP Control Code on your company config

I wouldn't know unless I was able to look at your setups, but I think calling support and sending them the WIP Recon report is the only thing you can do at this point