Scenario:
During the month-end close process, the user attempted to generate Revenue Recognition Journal Entries for existing revenue arrangements. However, the process fails, and an error message is returned that prevents further progress. The specific error message encountered is:
You cannot set Eliminate to True for journal line with account ID 301
This issue typically arises when the system attempts to post journal lines to an account that is not properly configured to support intercompany eliminations. If the journal entry requires elimination settings due to intercompany transactions, but the account does not allow such settings, the process will halt.
Solution:
To resolve this issue and allow the Revenue Recognition process to generate journal entries successfully, the user should follow the steps outlined below:
Enable Internal IDs Display | Before the user can locate the specific account ID mentioned in the error message, they must first enable the option to display internal IDs in the NetSuite interface. This action allows the user to see internal identifiers throughout the system, making it easier to match the account ID mentioned in the error message to the appropriate account record.
- Navigate to Home > Set Preferences
- On the General tab, scroll to the Default section.
- Set the Show Internal IDs preference to True.
- Click Save to apply the change.
Update the Affected Account Configuration | Once internal IDs are visible, the user can locate and configure the account associated with the error. This setting allows journal entries involving this account to participate in intercompany elimination processes. Without this setting enabled, the system cannot create journal entries where Eliminate is set to True.
- Navigate to Lists > Accounting > Accounts
- Locate the account record whose internal ID matches the account ID specified in the error message (e.g., "XXX").
- Click Edit on that account record.
- In the account settings, locate the checkbox labeled Eliminate Intercompany Transactions.
- Set Eliminate Intercompany Transactions = True.
- Click Save to confirm the update.
Hope this helped!
