SCENARIO:
User is tasked with running intercompany eliminations in their OneWorld instance. During the process, they encounter an error message stating, "The account (xx) is an inactive account. Please correct the import file and resubmit."
User wants to to identify and update the inactive accounts in their import file to ensure that only active accounts are used for eliminations.
SOLUTION
This issue arises because one or more of the accounts involved in the intercompany elimination process have been marked as inactive, preventing the completion of the elimination entries. The number in the error is usually the internal id, of the account. However, user may want to use a transaction dataset to review the transactions associated to the inactive elimination account.
CREATING A DATASET
Since it is not yet possible to show the Elimination checkbox in a Saved Search, users can create a Dataset Transaction
1.) Click Analytics
2.) Go to Datasets > New Dataset
3.) Select Transactions
4.) Add Criteria
Transaction Line (Record list) > Eliminate (Field list) = True
Transaction Line (Record list) > Transaction Accounting Line (SubRecord list) > Account (SubRecord list) > Inactive = True
5.) In the Data Grid (Results), add the fields:
Transaction Line (Record list) > Transaction Accounting Line (SubRecord list) > Account (SubRecord list) > Inactive
Transaction Line (Record list) > Transaction Accounting Line (SubRecord list) > Account (SubRecord list) > Eliminate
Transaction Line (Record list) > Transaction Accounting Line (SubRecord list) > Account (SubRecord list) > Display Name
6.) Rename and Save Dataset
User should be able to identify the transaction and the account
Making the Account Active Again
1.) Navigate to Lists > Accounting > Accounts
2.) Click Show Inactives
3.) Uncheck the Inactive Checkbox on the Account and Click Submit
This will make the elimination account active again.
After making such changes, user should be able to run the task without any error:
Have you encountered this error before? I hope this helps!