Previous Topic

Next Topic

Book Contents

Book Index

GL Validate Ledger

Navigator > Tasks > General Ledger > Validate Ledger

Validation checks all accounts in Accredo and recalculates totals for Total accounts. Use validation to enquire on a Total account (or make a budget enquiry), if accounts have been maintained, or transactions have been posted since the last time totals were calculated. Validation also checks that the Chart Of Accounts is valid, for example, you are not attempting to add into accounts other than Total accounts, and that add to accounts exist. If errors in the Chart Of Accounts are detected, print an error report to the screen, you can regenerate it to the printer later. Correct errors from Navigator > Maintain > General Ledger > Accounts. After correcting errors, re-select Validate Ledger to verify the Chart Of Accounts.

WARNING: After ledger issues have been corrected and the ledger is valid, you MUST run a File Recovery to reflow the balances.

Warnings

All warning messages show, "Ledger is out of balance by $..." Warnings indicate that batches have been posted to an invalid ledger or that the Chart Of Accounts has been changed in a way that affects opening balances of some accounts (for example, an account changed from Expense to Asset could cause this because expense accounts zero at End Of Period, whereas asset accounts retain the balance). Warnings can be corrected by running File Recovery on the GL as this recalculates all balances based on the current Chart Of Accounts.

Errors

An account number and name are specified for each error.

Add To Account Errors

  • Add To account does not exist.
  • Add To account must be a Total account.

Add To accounts can be specified on the Account tab. Add To accounts must exist in the ledger, and must be Total accounts.

Post To Account Errors

  • Post To account does not exist.
  • Post To account must be a Standard account.
  • Post To can only be specified for Standard accounts.
  • Post To can only be specified for income and expense accounts.
  • Post To must be specified for income and expense accounts.

Post To accounts can be specified on the Account tab. Post To accounts must exist in the ledger, and be Standard accounts. Post To accounts must be specified for all (and only for) zeroing accounts, that is, Income and Expense accounts.

Standard Account Errors

  • Standard Account does not add or consolidate to any total.

If Validate Chart Based Totalling is Selected in GL Settings, Standard Accounts must have an Add To Account or Consolidate To Account specified on the Account tab.

Opening Account Errors

  • Opening account does not exist.
  • Opening account must be a Standard account.
  • Opening account can only be specified for Standard accounts.
  • Opening account can only be specified for income and expense accounts.

Opening accounts can be specified on the Account tab. Opening accounts must exist in the ledger, and be Standard accounts. Opening accounts can only be specified for zeroing accounts, that is, Income and Expense accounts.

Consolidate Account Errors

  • Consolidate account does not exist.
  • Consolidate account must be higher numbered.
  • Consolidate account must be a Total account.

Consolidate accounts can be specified on the Account tab. Consolidate accounts must exist in the ledger, and must be higher numbered than the account you are consolidating to, as the ledger adds downwards. Consolidate accounts must be Total accounts.

Percentage Account Errors

  • Percentage account does not exist.
  • Percentage account must be a Standard or Total account.
  • Percentage can only be specified for Standard or Total accounts.

Percentage accounts can be specified on the Reporting tab. Percentage accounts must exist in the ledger, and be Standard or Total accounts. Percentages can only be specified for Standard or Total accounts.

Alternate Account Errors

  • Alternate account does not exist.
  • Alternate account cannot be specified for heading accounts.
  • Alternate account is wrong type.
  • Alternate account must be opposite sign (Debit or Credit).

Alternate accounts can be specified on the Reporting tab. Alternate accounts must exist in the ledger, and can only be specified for Standard, Non-Posting or Total accounts. The Alternate account specified must also be a Standard, Non-Posting or Total account (that is, not a Heading account), and must have the opposing account number specified in the Alternate Account field (so the two accounts act as Alternate accounts for each other). In a pair of Alternate accounts, one must be a Debit account (for example, Expense or Liability) and the other must be a Credit account (for example, Income or Asset).

Corrupt Data Errors

  • Bad Account Type.
  • Bad Account Class.

These errors indicate that data has been corrupted on the hard drive. It is likely you will need to restore to a backup to correct these errors, although you can try editing the accounts. Contact Accredo support.

Style Errors

  • Line Spacing must between 0 and 2.
  • Invalid or missing Heading Style.
  • Invalid or missing Total Style.

On the Reporting tab, Line Spacing must be specified for all accounts. The Heading or Total Style must be specified for all Heading or Total accounts. If one of these is blank or invalid, select a style from the drop-down.

Unknown Code Errors

  • Unknown Branch code %s in balances - run file recovery to correct. (Accredo Saturn Only)
  • Unknown Department code %s in balances - run file recovery to correct. (Accredo Saturn Only)
  • Unknown account code %s in balances - run file recovery to correct.