How to resolve cheque or remittance corruption

Summary

How to resolve cheque or remittance corruption in Sage 50 Accounts.

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

Cheques or remittances print with the wrong details. For example, the cheque prints for a different supplier to the one selected
Sage 50 Accounts hangs or crashes when posting a supplier payment (PP)
Saving a supplier payment (PP) doesn't post the transaction
Remittance isn't created when you post a supplier payment
Sage 50 Accounts hangs or crashes when you click the Remittance or Cheques option
Software freezes or closes when working with customers and suppliers

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

You're unable to follow these steps if you use Sage 50 Cloud. Follow the next steps section to use the rebuild option.

Select the area you need to fix:

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:

Take a backup of your data.
Go to Help then About, then note the Data Directory in the Program Details section.
Before renaming and creating any files, stop the Sage 50 Accounts Data Service or lock Remote Data Access.
Press the Windows key, then type hidden files, and press Enter on your keyboard.
Make sure the option to display hidden and system files is enabled:

Then continue to the next step.
Hold down the Windows key and press E.
Browse to the Accdata folder noted in step 2.
Right-click BNKREMDA.DTA, select Rename and rename it to BNKREMDA.OLD.
Press Enter.
Right-click BNKREMIX.DTA, select Rename and rename it to BNKREMIX.OLD.
Press Enter.
The program will automatically recreate these files.
Restart the Sage 50 Accounts Data Service or refresh Remote Data Access.
Go to File, then Maintenance, and click Reindex.
Select Reindex Remittance Records, click OK, and click Yes.
Select Compress Now, then untick Compress All Data Files.
Select only Bank Accounts.
Select Compress then press OK.
Press Close then Close again.

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

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:

Take a backup of your data.
Go to Help then About, then note the Data Directory in the Program Details section.
Before renaming and creating any files, stop the Sage 50 Accounts Data Service or lock Remote Data Access.
Hold down the Windows key and press E, then browse to the Accdata folder noted in step 2.
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.
Right-click REMIT.DTA, select Rename and rename it to REMIT.OLD.
Press Enter.
Right-click REMITIDX.DTA, select Rename and rename it to REMITIDX.OLD.
Press Enter.

The program will automatically recreate these files.
Restart the Sage 50 Accounts Data Service or refresh Remote Data Access.
Go to File, then Maintenance, and click Reindex.
Select Reindex Remittance Records, click OK, and click Yes.
Select Compress Now, then untick Compress All Data Files.
Select only Bank Accounts.
Select Compress then press OK.
Press Close then Close again.

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

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