How Do I Amend, Cancel or Delete Transactions?

Making corrections to Transactions before and after processing.

Written By Niall Conlon (Draft Writer)

Updated at September 16th, 2022

Introduction

The amendments you can make to transactions depend on transaction status and type. 

Transaction Status

  • Posted Transactions: You can make limited edits to complex transactions containing single or multiple Product Lines, or inventory changes. Examples include amendments to Departmental and General Ledger Account postings. If these transactions require significant edits, then use the Auto-Credit and Auto-Debit facilities on these Invoice Types (or Reversal facilities if available) and re-enter them.
  • Unposted Transactions: You can make as many amendments as needed.
  • Allocated Transactions: For most edits, unallocate them first, then amend and reallocate them as required.

Transaction Type

You can significantly amend most transactions, including:

  • Batch Transactions
  • Quick Entry Transactions
  • Payments Journals
  • Debit/Credit Journals

You cannot significantly amend:

  • Transactions that appeared in a VAT (Tax) Return.
  • Transactions used in a Bank Reconciliation.
  • Transactions from a Closed Period. You need to reopen the period.

The System documents all amendments and corrections for review. You cannot delete transactions from the system. However, it is possible to cancel Invoices and Orders in some circumstances. 

Delete

Editing, Reversing, and Cancelling RulesEditing Transactions

Security rules that control edits 

  • You need the correct profile settings to amend transactions. 
  • You can only amend transactions from an Open Period. The exceptions are the Description and Ext Ref fields, which you can amend at any time from the Transaction Browser.
  • You can only amend transactions that are Unallocated, Unreconciled (on a Bank Statement), or Unreturned (from a Tax perspective). To edit Allocated Transactions, you must change their status to Unallocated. 
  • You can only amend transactions not used for a VAT (Tax) Return. If the transaction is on a saved VAT (Tax) Return, you can uncheck the transaction to edit it. 
  • If the transaction is on a saved Bank Reconciliation, you can uncheck it to edit it. If a transaction is on a Reconciled Bank Reconciliation, only Admin users can unreconcile the bank, uncheck the transaction, and edits it. 

Fields that can be edited

  • Transaction Date:  This will automatically update the Period Date of the transaction. When you amend a transaction date, you must amend it on the Control Account line to propagate the change down to the other transaction lines.
  • Supplier (Vendor)/Customer/Bank Account Code: When changing the Supplier or Customer account for a transaction, if the currencies differ, the system takes the current exchange rate from the currency table and recalculates the base currency amount accordingly. Check that the exchange rate and base currency amount are correct.
  • General Ledger Code 
  • Description: You can amend this at any time from the transaction browser.
  • Transaction amount: You can change this on all transactions except Product related Invoices/Credit Notes. To edit these documents, reverse them by creating a Credit Note followed by a new document.
  • Tax Code: On Batch Invoices/Credit Notes (Sales and Purchases), you can change the Tax Code, but you need to manually change the corresponding line code and amount. If you change the Tax Code on the net line of an Invoice, and not the Tax Code on the corresponding Tax line, the Tax reporting and returning may be incorrect.
  • BI Code

Reversing Transactions

You can Reverse some transactions:

  • Sales and Purchase Invoices (Batch)
  • Sales and Purchase Credit / Debit Notes (Batch)
  • Sales and Purchase Invoices (Item) (Use the Sales Item Credit Note or Purchase Item Debit Note)
  • Sales Receipts
  • Purchase Payments
  • Bank Receipts
  • Bank Payments
  • Sales and Purchases Credit / Debit Journals 
  • Bank Credit / Debit Journals
  • General Ledger Credit Journals
  • General Ledger Debit Journals 

Cancelling Invoices and Credit Notes

You can cancel Invoices and Credit Notes if:

  • You have not posted the Invoice or Credit Note. If you have posted them, then raise a Credit Note or Journal.
  • The Invoice did not come from an Order. It is not possible to cancel an Invoice and revert the related Order back to an un-invoiced state.
  • The Invoice does not contain any Stock (Inventory) Item Codes. Cancelling would have Inventory implications.
  • Your Supplier Invoices are subject to Approval. The Invoice must be in a Rejected state (not Pending or Approved) before cancellation. 
Delete

Simple Edits

  1. Go to General > Transaction Browser
  2. You can edit Description and Ext. Ref. To accept changes, click the tick icon or cancel by ticking the x icon.

See:

How do I Use & Customise the Transaction Browser?‍ 

Delete

Amending Batch Type Transactions

  1. Go to General > Transaction Browser. Find your transaction and click Edit.
  2. Click the pencil icon in the line you want to edit. Only the fields you can edit become available for editing.

In this example, a Batch Purchase Invoice has a status of Posted. This means you can amend the Transaction extensively, including:

  • Account
  • Date
  • Rate of Exchange
  • Net Amounts. This also amends the associated GL Postings and Base Currency Amount.
  • Tax Amounts and Tax Rate. If you change the Tax Rate, you must manually calculate the Tax Amount, but the remaining amounts automatically calculate.
  • General Ledger Posting Account
  • BI Code
  • Transaction Status. You can change this to Dispute or Reverse 

If you wish to cancel the Amendments, click on the Blue Reversal Icon.

  1. Click Process Edits

  1. Click the Blue Flag icon to open Change Log. This displays details of the changes, including date and user.

Delete

Deleting Transactions

For complete Data Integrity and Traceability, it is not possible to Delete a transaction from the system once you enter it, although you can cancel some Invoices.

 

However, you can Reverse or Auto Credit/Auto-Debit a transaction. It will still be visible within the system but have the same effect as a deletion.

 

When you Reverse or Auto-Credit /Auto-Debit a Transaction, all related Postings are also reversed. If you reverse an Invoice, then the following postings will also be reversed:

  • GL Control Account
  • GL Tax Account
  • GL Income or Costs Account
  • Sales or Purchase Analysis data
Delete

Allocated Transactions

If you have already allocated transactions, you can:

  • Follow the section Simple Edits, above
  • If they are Batch Type, unallocate these transactions as follows:
  1. Go to General > Transaction Browser. Find your transaction and click Edit.
  2. Click the pencil icon in the line you want to edit. Only the fields you can edit will become available for editing.

 

 

  1. For Sales Transactions:

In the View Allocations tab click Unallocate. The pencil icons will now work for editing.
 

For Invoice Transactions:

Click the Invoice Number. In the Edit Invoice tab, you can edit the Date, GL Account Number, and BI Code.

To see the original document, click the Invoice Number.

  1. Go to Change Log where you can view details of the edits.

 

 


For Auditing purposes, a spreadsheet record is attached to the Invoice via the Document Manager.

 

Delete

Note

In the Transaction Details, Invoice Lines which have common GL and BI Codes merge into one Line. However, once you click Edit Invoice these summarized lines expand back into the individual lines. You can now amend the individual lines by using different GL and/or BI Codes. Likewise, if you amend Invoice Line’s GL and/or BI Codes to correspond with each other, the Lines will merge in Transaction Details.

Delete

Amending Unposted Transactions

You can completely amend Transactions which are in an Unposted state:

  1. Go to Sales or Purchases and find your relevant transaction.
     
     
  2. You can now change, for example, the Customer Account Code or any of the Customer details. You can Delete Lines (F8), amend Lines (Product Code, BI Code, Quantity, Price, VAT (Tax)) and add new Lines. You cannot fully delete the entire transaction, but you can reuse it as if it were a completely new transaction.

Delete

Cancelling Unposted Transactions

If a transaction is in an open state:

  1. Go to Sales or Purchases and find your relevant transaction.
  2. Go to Actions > Cancel Order or Cancel Invoice. Alternatively, click the transaction number to open it, followed by Cancel Order or Cancel Invoice.


 

 

Delete

Reversing Posted Transactions

It is only possible to reverse these transactions if they are in an Unallocated state. Therefore, if the transaction is allocated, then you must first Unallocate it as described above.

Batch Type Transactions

  1. In Sales or Purchases, find your relevant Batch Transaction.
  2. Go to Actions > Reverse. Alternatively click on the Batch Reference to open Transaction Details and click Reverse.
     
     

  1. When you Reverse a Batch Type transaction then you need to give a reason.
  2. Click OK to create a Reversal Transaction.

Product Type Transactions

To reverse Product Type Transactions (PI/PN or SI/SN Invoices and Credit Notes) you must Auto Debit or Auto Credit these transactions. You cannot reverse an Invoice or Credit Note in a Closed Period. 

  1. In Sales or Purchases, find your relevant Transaction.
  2. Go to Actions > Auto Debit or Auto Credit. Alternatively click on the Reference to open the transaction and click Auto Credit or Auto Debit.
     

  1. Click OK to accept. This creates a Reversal Transaction in the form of a Credit Note or Debit Note that matches the Item/Price Invoice and all its line Items. The Debit/Credit Note is automatically Allocated to the original Invoice. In the Item Invoices grid the Purchase Debit will appear with the same reference as the invoice you auto debited but prefixed with ‘Debit’ in front of the number. The auto debit will have a PN transaction type.

Delete

Duplicate a Transaction before Reversing & Subsequent Amendment 

If you have a complex Product/Item Type Invoice which you want to amend beyond what’s available for a Posted Transaction, you can duplicate it and then Reverse the original. This process produces an Unposted Transaction (Processed) which you can fully amend. 

  1. Find the Transaction in question and click on its reference number to open it.
     
      
  2. Click Duplicate
  3. Enter a new External Ref. 
  4. Click Save. Do not click Post during the process. This will then create your Unposted duplicate transaction which you can now amend.
     
     
  5. You can then proceed to Auto-Debit or Auto-Credit the original transaction and then proceed to post and/or print the duplicated transaction.
Delete

Examples

Sales Batch Invoice:

  1. Go to General > Transaction Browser.
  2. Find your transaction and click Edit.
  3. Select a particular line to edit by clicking on the pencil icon.

Edit the available fields as required. As this is a batch invoice and unallocated it is possible to edit the: 

  • Amounts
  • VAT (Tax) codes
  • Customer account
  • BI Code
  • Non-control GL accounts
  • Date

To cancel any edit made whilst in edit mode, click the undo icon. 

  1. Click Process edits.
      

Sales Item Invoice

  1. Go to General > Transaction Browser.
  2. Find your transaction and click Edit.
  3. Select a particular line to edit by clicking the pencil icon.

Edit the available fields as required. It is possible to edit the: 

  • Invoice date
  • Non-Control GL accounts
  • BI Code 

Alternatively, you can edit the items above and more in the Sales Item Invoice:

  1. Go to Sales > Item Invoice.
  2. Find your Invoice and click on its Number.
  3. In Invoice Details, for posted Item Invoices, you can also edit the:
  • Product Description
  • Customer Address
  • Delivery Address 

 

  1. Click Edit Details and the editable fields become highlighted.

  1. Click Save.
Delete

Note

These edit options are only available for Sales Item Invoices. They are not available for Purchase item Invoices.

Delete