When importing advanced Intercompany Journal Entries, the user may get this error message.
While importing Advanced Intercompany Journals, include a column “Eliminate” in the Import file. This Eliminate column should be populated as either “YES” or “NO”.
For the Intercompany accounts at the line level, we should select the “Eliminate” checkbox as “Yes”. Then in the Due To/From Subsidiary column, should select a subsidiary that is not the “From Subsidiary” (originating subsidiary).
Normally the “Due To/From Subsidiary” field defaults to the subsidiary that the intercompany entity in the Name field represents.
And if the Subsidiary selected at the line level, is the “From subsidiary”, then the Subsidiary selected in the “Due To/From Subsidiary” field must be added as one of the “To Subsidiaries” in the transaction
For example, please consider the following scenario
From subsidiary – RealToken Inc
To Subsidiary – RealToken Inc
Due To/From Subsidiary – Michigan Real Token 3 LLC
Then the subsidiary “Michigan Real Token 3 LLC” should be added as a “To Subsidiary” in the transaction.
Also, there should be a balancing line for that. That is, if the Subsidiary selected at the line level, is not the “From subsidiary”, then the Subsidiary selected in the “Due To/From Subsidiary” field value must be “From Subsidiary”.
For example,
From Subsidiary – RealToken Inc
To Subsidiary – RealToken LLC Series 1 – 9943 Marlowe
Then the Due To/From Subsidiary must be RealToken Inc. this is required for the lines with the “Eliminate” box checked.