Summary
Description
The data integrity check will warn of possible serious errors in your data.
- Select Maintenance, Check Data Integrity to ensure your accounts and sub-ledgers balance.
- The left side (L) of the Integrity Summary window is the General Ledger balance as of the latest transaction date.
- The right side (R) of the Integrity Summary window is the balances associated with your customers, vendors, or employee.
- The A/P balance (L) must always match the Unpaid Invoices (R) like the example below.
Resolution
Table of Contents
- Check if you use foreign currency to eliminate data issues
- You sent the file to your accountant using the Accountant Edition
- You didn't send the file to an accountant using Accountant Edition
- Total Debit and Total Credit not matching / Retained Earnings opening balance isn’t correct
- Accounts Payable or Accounts Receivable balances don’t match my Unpaid Invoices
- Deposit Account Balance isn’t equal to my Pre. Order. / Deposit
- Advances & Loans Receivable Balance doesn’t match my Advances and Loans Paid
- Vacation Payable Balance doesn’t match my Vacation Pay Owed
- Goods Received Balance doesn’t match Uninvoiced Goods Received
- Delivery Orders Balance doesn't match Uninvoiced Delivery Orders
- Prepayment Account Balance isn’t equal to my Prepaid Orders subledger
First check if you use foreign currency or if you sent the file to your accountant. If not, select the inconsistency you’re receiving to resolve it.
Check if you use foreign currency to eliminate data issues
NOTE: If your data file uses foreign currency, you must contact Customer Support. Unlinking A/R and A/P will ruin the foreign balances of these accounts.
- Select Setup, Settings, Company, then Currencies to check if you’re using foreign currencies.
- If there’s more than the home currency, then you're using foreign currencies.
- Contact Customer Support for data repair at 1-888-522-2722.
You sent the file to your accountant using the Accountant Edition
- The accountant made a general journal entry directly to the control account. Return the backup file to the accountant to void these entries.
- If the accountant will make these entries.
- Make entries in the correct module, or disregard the data integrity issue if using the General Journal for adjustments (Not recommended)
- The company file can’t have a data inconsistency while in History mode. Sage 50 won’t allow you to advance into the new year
- To post Accounts Receivable adjustments, use the Sales Invoice module and not in the General Journal.
- Use a negative value to decrease the Accounts Receivable balance
- Use positive value to increase the balance
- To post Accounts Payable adjustments, use the Purchase Invoice module and not in the General Journal.
- Use a negative value to decrease the Accounts Receivable balance
- Use positive value to increase the balance
You didn't send the file to an accountant using Accountant Edition
Select your inconsistency below for steps to resolve.
Total Debit and Total Credit not matching / Retained Earnings opening balance isn’t correct
- Ensure all computers are on the latest version.
- Make a backup of your data.
- Follow the steps to resolve the Data inconsistency between total Debits and total Credits.
Accounts Payable or Accounts Receivable balances don’t match my Unpaid Invoices
NOTE: If you use foreign currency, don't follow these steps to resolve. You must contact Sage Customer Support to schedule data repair..
- Make a backup of your data.
- If you don't use foreign currency, follow these instructions to resolve the inconsistency with the balance and the unpaid invoices.
Deposit Account Balance isn’t equal to my Pre. Order. / Deposit
The steps to resolve this issue depend on the following criteria.
- If linked accounts are accurate
- If your Prepd Ord./ Deposit sub-ledger is zero while the Deposit Acct. Balance isn’t
- If you made a general journal entry instead of entering the opening balance, then void the general journal entry
To resolve.
- Make a backup of your data.
- Review the instructions on how to resolve the inconsistency.
Advances & Loans Receivable Balance doesn’t match my Advances and Loans Paid
The steps to resolve this issue depend on the following criteria.
- If linked accounts are accurate
- If the file is in history mode
- If the inconsistency is recent
To resolve.
- Make a backup of your data.
- Review the instructions for steps to resolve the inconsistency.
Vacation Payable Balance doesn’t match my Vacation Pay Owed
The steps to resolve this issue depend on the following criteria.
- If linked accounts are accurate
- If the file is in history mode
- If the inconsistency is recent
To resolve
- Make a backup of your data.
- Review the instructions on how to resolve the inconsistency.
Goods Received Balance doesn’t match Uninvoiced Goods Received
The steps to resolve this issue depend on the following criteria.
- If linked accounts are accurate
- If the file is in history mode
To resolve.
- Make a backup of your data.
- Review the instructions for the steps to resolve the inconsistency.
Delivery Orders Balance doesn't match Uninvoiced Delivery Orders
The steps to resolve this issue depend on the following criteria.
- If linked accounts are accurate
- If the file is in history mode
To resolve.
- Make a backup of your data.
- Review the instructions for the steps to resolve the inconsistency.
Prepayment Account Balance isn’t equal to my Prepaid Orders subledger
The steps to resolve this issue depend on the following criteria.
- If linked accounts are accurate
- If the file is in history mode
To resolve.
- Make a backup of your data.
- Review the instructions for the steps to resolve the inconsistency.