Hello everyone - we have an out of balance review journal that happened over a week ago. I was able to find the guilty transaction which was a STK-CUS for one sales order which had 3 parts on it. All parts have the GL Control set up correctly. The inventory accounts (credit to inventory) were on the journal but the offsetting cost of sales debits were no where to be found which was causing the out of balance condition. Nothing has gone awry since that day. Everything else is posting fine and there is nothing weird about the parts that were shipped.
I’m pretty sure I know how to fix it by adding the missing GL accounts and amounts to the journal but I’m curious if anyone has an idea of how this happened in the first place. Could it be caused by a disruption of connectivity some how? BTW - we are on Public Cloud. Thanks everyone!
Hi Nancy,
A possibility is that the sales order line did not have a Product Group assigned and the default InvCOS GL control doesn’t have any accounts for COS.
To find where the error is occurring
Open GL Transaction Type COSandWIP
Turn on Logging (don’t leave this on)
Run inventory WIP recon report filtered to the transaction type and date
Go back to GL transaction type and right click on the COSandWIP to open PE Log viewer to review where the error occurred.
Hey all - In case someone is struggling with the same problem, we found the root cause. Simply - the Customer record was set as Inter-company (under the Billing tab). When this is set the transaction type logic wants to find a GL Control for the customer in question. We do not set GL Controls at the customer level and we do not have Inter-company needs. Once this was checkbox was cleared and the Review Journal was canceled, everything went through balanced. Thank you @LarsonSolutions for your help.
