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?