Hi everyone,
In Epicor, when the Inter-Company checkbox is selected in the Billing section of Customer Maintenance, both Sales and COS transactions use the GL Control Code assigned to that customer. The COS accounts are also broken out correctly by elemental bucket.
When the checkbox is not selected, the posting hierarchy looks to the Product Group for the applicable accounts. That portion is working as expected.
The issue occurs with an MFG-VAR transaction from a make-direct job when WIP is phantom-purged to COS. In this scenario, Epicor is using the COS accounts assigned to the Product Group rather than the GL Control Code assigned to the intercompany customer.
Am I missing an available setup that would cause the MFG-VAR transaction to use the customer’s intercompany GL Control Code?
I have also been reviewing the Posting Engine and found the function where the account hierarchy is determined. The challenge is that the MFG-VAR originates from PartTran, which does not directly contain the customer information.
I created a lookup query that traces the transaction back to the customer and returns:
- Whether the customer is intercompany
- The GL Control Code assigned to that customer
The Posting Engine trace appears to reach the lookup successfully and confirms that the intercompany condition is true. However, it does not resolve the proper GL account from that GL Control Code for the given posting context. It continues to use the Product Group COS account instead. I want it to use the COS accounts on customer’s AR GL Control code.
Has anyone successfully modified a Posting Engine function so that a GL Control Code returned by a lookup can be evaluated using the current or “Given” context? I would also be interested to know whether there is a standard setup option I may have overlooked before continuing with a Posting Engine modification.