How to Find and Fix Inactive Posting Account Error in SJI Creation

How to Find and Fix Inactive Posting Account Error in SJI Creation (or invalid ledger entry when transferring system entries into Ledger)

This error can present in SJI creation as Transaction Codes do not have Account Numbers Assigned, or in LDG > Journal Entries > System Journal Entries as an invalid entry when trying to transfer system journal entries into the ledger.

At the time of SJI creation, an error will appear that transaction codes do not have account numbers assigned. Do you want to create system journal entries? Select Yes. It will then ask are you sure you want to create these entries? Select Yes. Spool all SJI creation reports. If this error was caught in LDG > Journal Entries > System Journal Entries, the SJI reports should already be in the spool with entries created. Continue to the next step.

From Reports > Spooled Reports, select the subsidiary with the invalid entry or transaction codes not assigned error’s Journal Entries Report and print to screen (4. Preview).

Find “Inactive Posting Account” in the account description column. This is what caused the error message during SJI creation. Note the journal entry number in the far-left column.

a. The journal entry number is 0002 with account and detail code 1020 06 being the inactive posting account.

If this should be an active posting ledger account, go to LDG > Maintenance Options > Chart of Accounts > 2. View / Edit Accounts. Pull up the inactive account, then hit Next to go to screen 2. Say Yes to Active posting account? If this account should not be active, skip to the next step. If completing this step, the account will be active again and the system entries can be posted to the ledger. This corrects the inactive posting account error.
Go to SJI > Maintain System Entries > Edit Journal Entries. In the Journal Entry # box, key in the journal entry number found in step 3 from the spooled SJI creation report.
Select the line of the inactive posting account by double clicking it, then type in the account code, detail code, and profit center this amount should be posting to instead of the inactive account. Select OK. Two lines will populate, one removing the dollar amount from the inactive posting account, and one moving it to the correct account. Then select Continue to save.
This corrects the inactive posting account error. Continue on to next step of month end processing or repost SJI entries to the ledger in LDG > Journal Entries > System Journal Entries. Entries will not duplicate here if already posted, only the invalid will post.