Skip to Content
0
Jul 11, 2016 at 10:33 PM

Document Splitting for Intercompany Clearing Accounts

1099 Views

We are on New GL, document splitting active (profit center and segment zero balancing). When entering cross company code vendor invoices, we are losing traceability of the intercompany receivable because the intercompany clearing account is being posted to the same profit center with both a debit and a credit. This is effectively netting out the receivable. The scenario works correctly when doing a basic cross company code journal entry so my assumption is that the incorrect splitting is caused by the A/P being split to multiple profit centers. Example given below:

Entry View:

DB Acct 5xxxxx, Cost Center A (Profit Center A), Company Code A - $500

DB Acct 5xxxxx, Cost Center B (Profit Center B), Company Code B - $500

CR Vendor - $1000

GL View:

Company Code A:

CR Vendor, Profit Center A - $500

CR Vendor, Profit Center B - $500

DB Acct 5xxxxx, Profit Center A - $500

DB Interco Clearing, Profit Center B - $500 <-----This is the entry in question. The debit to profit center B will net out with the entry on the other company code A.

Company Code B:

DB Acct 5xxxxx, Profit Center B - $500

CR Interco Clearing, Profit Center B - $500.<------interco clearing account is hit twice with the same profit center.

My thought was that if I could prevent the splitting of the A/P, this would resolve the issue but I have yet to get that to work and also am not sure that it's the correct solution.Has anyone faced a similar issue, and if so, what did you do to resolve?