Check if you’re using foreign currency

• To check for foreign currency, select Setup, Settings, Company, then Currencies.
• If you see more than the home currency, you’re using foreign currency.
• If you use foreign currency, don't use the steps below. 
• Contact Customer Support at 1-888-522-2722 for data repair. Extra charges may apply. 

If the file is in History mode

1. Make note of the difference between the account ledger and the sub-ledger.
2. Select the Chart of Accounts window, then open the account in question.
3. Select the Account tab, and locate the Opening Balance field.
4. Modify the Opening Balance to reflect the adjusted amount you noted in Step 1.
5. Select Save and Close.
6. Select Maintenance, then Check Data Integrity.
7. The amounts will now be equal.
8. Repeat if you have other lines for the affected account in question.
9. Make a backup of the data file.

If your file isn’t in History mode

 CAUTION: If you use foreign currency, don't follow the steps below. Contact Sage Customer Support for data repair at 1-888-522-2722.  

1. Go to Maintenance and Check Data Integrity.
   • Integrity issues often stem from users posting journal entries to linked accounts, not database corruption
2. Verify the linked accounts are accurate.
   • Go to Setup, Settings, Customers and Sales, Linked Accounts (for AR)
   • Go to Setup, Settings, Vendors and Purchases, Linked Accounts (for AP)
3. Select Reports, Journal Entries / Transaction Details, General.
   • If you find the linked account, reverse the journal entry causing the integrity issue
   • Post to the correct module instead of the General Journal
   • Reverse transactions only if found in the Current Fiscal Year or Previous Fiscal Year
4. Determine if the A/P / AR balance side (L) is more accurate than the Unpaid Invoices side (R).

• • Select the subledger report for AR in Customers & Sales, Customer Aged Report for a report of Unpaid Invoices
  • Select the subledger report for Vendors & Purchases, Vendors Aged Report, Summary for a report of the Unpaid Invoices
  • You can create a reversing journal entry to put the account balance identical to the subledger balance - or -
  • Create a new Customer or Vendor record and post a negative invoice for the original discrepancy difference
     CAUTION: Seek advice from an accounting professional before reversing or posting adjusting transactions