I have a problem with cheque or remittance corruption
Description

If you have cheque or remittance corruption, the following issues appear: 

NOTE: You can't reindex remittances when using Sage 50 Accounts Essentials. 

Cause
Resolution

Reindex remittance records

  1. Log into Sage 50 Accounts as MANAGER.
  2. Back up your data.
  3. Go to File, then Maintenance, and click Reindex
  4. Select Reindex Remittance Records, click OK, and click Yes.
  5. Select Compress Now, then untick Compress All Data Files.
  6. Select Bank Accounts only.
  7. Click Compress then click OK.
  8. Click Close then Close again.

If the problem persists

Click the area you need to fix:

▼ Remittance

 NOTE: This removes all information held in the remittances window. It doesn't affect the actual transactions posted. 

To correct the corruption, you must rename and recreate the following corrupt files:

  • BNKREMDA.DTA
  • BNKREMIX.DTA
  1. Take a backup of your data.
  2. Go to Help then About, then note the Data Directory in the Program Details section.
  3. Before renaming and creating any files, stop the Sage 50 Accounts Data Service or lock Remote Data Access.
  4. Press the Windows key, then type hidden files, and press Enter on your keyboard.
  5. Make sure the option to display hidden and system files is enabled:
    Show hidden and system files with slider on.
    Then continue to the next step. 
  6. Hold down the Windows key and press E.
  7. Browse to the Accdata folder noted in step 2.
  8. Right-click BNKREMDA.DTA, select Rename and rename it to BNKREMDA.OLD.
  9. Press Enter.
  10. Right-click BNKREMIX.DTA, select Rename and rename it to BNKREMIX.OLD.
  11. Press Enter.
    The program will automatically recreate these files.
  12. Restart the Sage 50 Accounts Data Service or refresh Remote Data Access.
  13. Go to File, then Maintenance, and click Reindex.
  14. Select Reindex Remittance Records, click OK, and click Yes.
  15. Select Compress Now, then untick Compress All Data Files.
  16. Select only Bank Accounts.
  17. Click Compress then click OK.
  18. Click Close then Close again.

You can now delete and recreate the bank transaction to recreate the remittance for any removed items.


▼ Cheque

NOTE: This removes all information held in the cheques window. It doesn't affect the actual transactions posted.

To correct the corruption, you must rename and recreate the following corrupt files:

  • REMIT.DTA
  • REMITIDX.DTA
  1. Take a backup of your data.
  2. Go to Help then About, then note the Data Directory in the Program Details section.
  3. Before renaming and creating any files, stop the Sage 50 Accounts Data Service or lock Remote Data Access.
  4. Hold down the Windows key and press E, then browse to the Accdata folder noted in step 2.
  5. Go to Tools then select Folder Options.
    If you can't see the Tools menu - Press the Alt key then press T and press O.
  6. Right-click REMIT.DTA, select Rename and rename it to REMIT.OLD.
  7. Press Enter.
  8. Right-click REMITIDX.DTA, select Rename and rename it to REMITIDX.OLD.
  9. Press Enter.

    The program will automatically recreate these files.

  10. Restart the Sage 50 Accounts Data Service or refresh Remote Data Access.
  11. Go to File, then Maintenance, and click Reindex.
  12. Select Reindex Remittance Records, click OK, and click Yes.
  13. Select Compress Now, then untick Compress All Data Files.
  14. Select only Bank Accounts.
  15. Click Compress then click OK.
  16. Click Close then Close again.

You can now delete and recreate the bank transaction to recreate the remittance for any removed items.


Next steps

Upgrade to Sage 50 Accounts v31 or above to use our new rebuild option, if you haven't already. Download the latest version.


Steps to duplicate
Related Solutions