Reverse / Cancel posted documents

Parent Previous Next

This facility allows you to cancel or reverse all the transactions and balances of a selected document which have been updated (posted) to the ledger. This process will automatically:

Export (remove) the transactions from the transaction file (TransAct.DB) file, reset the totals and account balances of all the accounts (which is linked to the selected inventory items on Action → Inventory items), customer or vendor accounts, inventory quantities, etc.

The reversed document may then be selected for the customer or vendor, edited and posted to the ledger. If you do not need to update (post) the document to the ledger, you may delete the document in Action → Edit → Delete → Documents.

The balances of the accounts and inventory item records will be corrected automatically for the following documents:

Documents for Customers (Invoices or Credit notes) - customer account, sales account, cost of sales and inventory control account as well as any Output VAT/GST/Sales Tax accounts and the quantities and cost prices of any inventory items.

Documents for Vendors (Purchase or Supplier return documents) - vendor account, cost of sales and inventory control account, as well as any Input VAT/GST/Sales Tax accounts, and the quantities and cost prices of any inventory items returned to vendors.

If a document for a customer (Invoice is generated or a Estimate which is confirmed and converted to an Invoice), or if a document for a vendor (purchase document is generated an order is confirmed and converted to a purchase document ), and these documents are not yet updated (posted) to the ledger, the following options are available to edit the transactions and / or comments:

Delete Document - delete the entire document, including all transactions and comments in the document.

Delete transactions and / or comments in a document - only the selected transaction(s), or comment(s), will be deleted from the document.

It is recommended that you make a backup of the Set of Books, before you start to use this facility to cancel or reverse a posted journal. In the event of making a mistake or if some problems are experienced, you may then easily restore the Set of Books from the backup file.

It is strongly recommended that you take the utmost precautions, before you use this facility. The following is a few guidelines to be taken into account, before using this facility:

Invoices - Once an invoice is already handed to, or sent to a customer, you need to generate a credit note to reverse or cancel the invoice.

Purchase documents - Once a purchase document is already handed to or sent to a vendor, you need to generate a supplier return document to reverse or cancel the purchase document.

This is of importance as the customer or vendor will receive the documents (invoice or purchase document), and record it in their books. They will then receive no source document to cancel or correct the source document received earlier in their records. If you and your customers or vendors are registered as VAT/GST/Sales Tax-vendors, it may have implications for VAT/GST/Sales Tax.


To reverse or cancel all the transactions in a posted document:

1.On the Setup ribbon, select Tools → Global processes → Reverse posted journal/document. The Reverse posted journal/document screen is displayed:

2.Click on the Documents tab. The Reverse posted journal/document screen will change to list all the documents which are already updated (posted) to the ledger.

3.Select the posted document you need to reverse or cancel from the list.

If you have more than one updated (posted) document to cancel (reverse), you may click on the Select from Delimited List button.

For example, if you wish to cancel (reverse) Invoices IN000003 and IN000004 as well as Credit note CR000001 simultaneously, enter each of the document numbers separated by a comma (without a space) e.g. IN000003, IN000004, CR000001. If you click on the Reverse posted document button, all the selected documents will be canceled (reversed) during the same process.

4.View the details of the document(s) to make absolutely sure that it is the correct document(s).

To view the details of the transactions in the selected document(s), you may:-

Double-click on the selected document(s).

On the Details tab, the transactions for the selected document(s) will be listed. (If you wish to print a list of the transactions in the posted journal, you may click on the Print button to print a Journal type - Posted journal report).

5.Click on the Reverse posted document button to start the process. The following screen is displayed:

6.Click on the Yes button, only if you are absolutely sure that the selected document is correct, and that you need to continue with this process.

If you have not made a backup of the Set of Books before starting this process it is recommended that you click on the No button and first make a backup of the Set of Books.

7.If you click on the Yes button, the process will be started.

8.Wait until the process is finalized.

It is advisable not to use your system for other tasks while this process is running.

Once this process is finalized, the selected document will not be listed on the Reverse posted document screen.

9.Click on the Close button in the title bar of the Reverse posted journal/document screen to exit (close) this facility.

10.Click on the Invoice icon, and select the document type. If you select the customer or vendor for which the document was reversed, or canceled, you may select the reversed document number. You may then edit these documents, delete the transactions, etc. Once the document is corrected, you need to update (post) the document to the ledger.

11.Once this process is completed, you need to do a Data integrity check on the data of your Set of Books.

Created with the Personal Edition of HelpNDoc: Write EPub books for the iPad