Skip to content
logo Knowledgebase

Balances errors in Year End close log

Created on  | Last modified on 

Summary

Trying to close or reopen periods, year end close and I get balance errors in the log: Error USD xxxx 12345 Period xx/xx/xx Balance xxx General Ledger Balance Incorrect General Ledger Incorrect This error can reflect any currency and USD is only used here as an example. Also, at each line a numerical value is represented.

Description

Cause

This error indicates a balancing issue for the applicable gl accounts and period noted in the error.

Resolution

CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.
  1. Verify everyone is logged out of X3 and Accounting Tasks is shut down
  2. Reopen all the periods for the year
  3. Go to Financials, Utilities, Resynchronizations, Entries
    • Select the correct fiscal year.
    • In the Dates field put in each month one at a time.
    • Check the Resynchronization Box.
    • Click Ok
    • Do each month consecutively and one at a time to make sure each month shows no errors.
  4. Resynch the balances in recovery mode
    • Open Financials, Utilities, Resynchronizations, Account Balance
    • Enter company (or it will default)
    • Select All sites
    • Enter applicable fiscal year
    • Tab through the Currency and the Account fields (ie leave them blank)
    • Select the Recovery option. Note: If you do not run in recovery, you will get a log file but the correction will not have taken place.
    • You will receive a log file when complete.
  5. Close Periods
  6. Close Year