• Deleted accounts do not appear on financial statements, ledgers or trial balances. When you print one of these reports for a prior period in which the deleted account had a balance, that account does not appear on the report and the report is out of balance.

To identify deleted GL accounts:

Use the GLDeletedAccount.rpt to identify accounts that were deleted. Refer to How do I save, add, and print a report design? for instructions to download and print the attached report design.

Attachment: GLDeletedAccount.rpt

Warning: The attached report is provided as a possible solution to your issue. It was not reviewed by Quality Assurance. You may need to modify it to meet your reporting needs or adapt it for use with future releases of the software. Contact your Sage 300 Construction and Real Estate certified consultant for assistance with modifying this report.

To recreate a GL account:

1. From the General Ledger Setup menu, select Accounts.
2. Enter the account number of the deleted account.
3. Enter the account title and select the same settings the account had before.
4. Click Save and then click Close to recreate the account.
5. Turn on Audit setup activity. Refer to How do I use Audit setup activity?
6. From the Setup menu, select Accounts.
7. Select Start if promoted to print the audit report to a file or printer.
8. Select List and select the deleted account.
9. Select the Balances tab.
10. Enter the correct balances on this tab. Contact your accountant if you do not know the correct balances.
    Note: Repeat this step for both balance tabs if you use both cash and accrual accounting.
11. Select the Activity tab.
12. Enter the correct net activity for each period. Contact your accountant if you do not know the correct activity for each period.
    Note: Repeat this step for both Activity tabs if you use both cash and accrual accounting.
    Tip: Use the Year-to-date Ledger report as a reference (Reports, Year-to-date Ledger) for this account's transactions. Specify One column for activity in General Ledger settings (File, Company Settings, Ledger Settings, Activity). Finish steps 1-4 (above) before you print the report.
13. Select Save
14. Select Close.
15. Turn off Audit setup activity. Refer to How do I use Audit setup activity?

When is it ok to delete a General Ledger account?