Why can't I delete or amend a transaction?
Description

When you correct a transaction, there are certain restrictions that apply to the corrections you can make. You can't delete or amend the following types of transactions.

If a transaction cannot be edited or deleted, you'll see an error message like: "You can't edit this transaction as it has an associated payment or refund".

TIP: Any transaction you can't delete or amend you must reverse and repost them correctly instead.

Cause
Resolution
Automatic transactionsFor example, transactions created via the Write Off, Refunds and Returns Wizard. This is because the reference on this type of transaction indicates that it was generated automatically.

If you edit the transaction, delete the reference and save the changes, you can then delete the transaction. When editing or deleting transactions the Customer Record Month To date (MTD) and Year To Date (YTD) may be affected.
Journal entriesYou can edit and delete journals. You were unable to delete or amend journals posted in v21 or below.


CIS v1 only

Transactions that were reconciled in the CIS module. To check if a transaction has been CIS reconciled, click Transactions and select the relevant transaction then check the CIS column. If there's a Y in this column the transaction has been CIS reconciled.

If the CIS column doesn't appear, right-click another column heading then choose CIS.


If you're using the new CIS v2 module, for help with correcting CIS transactions please refer to Sage 50 CIS v2 - Correcting CIS transactions.

VAT reconciled transactionsAlthough you can't delete VAT reconciled transactions, you can reverse them which cancels the effects of the original transaction. VAT Cash Accounting - allocated VAT reconciled transactions must be reversed manually by posting the opposite transaction to the original. e.g. if the transaction is a Bank Payment, post a Bank Receipt with the same details as the original Bank Payment. 
Foreign transactionsYou can only edit the Reference, Description, Bank reconciles and Exchange rate fields. If you need to edit any other fields, you should delete and re-enter the transaction.
Journals involving foreign currency bank accountsYou can't edit or amend any fields for journals affecting foreign currency bank accounts. You should reverse the journal and repost the correct details.
Postponed accounting transactionsWhen you post a supplier invoice with a postponed accounting tax code, a purchase credit for the postponed VAT amount is automatically posted and allocated to the invoice. Once these transactions are created, you can't edit or delete them. You should manually reverse the transactions instead.
Payment request made from GoCardlessAs you can't delete the invoice, you'll need reverse the transaction by posting a batch credit, then allocate this to the customer invoice.  


[BCB:19:UK - Sales message :ECB]















Steps to duplicate
Related Solutions