Update Ledger – All Document types – Incorrect transactions 

You may delete selected transactions from a project. 

Deleting a transactions will change the data included in reports for projects.

You need to make absolutely sure that the correct transactions is selected, before you proceed. 

This will not delete (remove) any transactions from the Set of Books.  


To delete (remove) transactions from a project:

1.Click on Projects (Action ribbon). The “Projects” screen (list view) is displayed:

2.The “Projects” screen (list view) will be displayed.

3.Select a project from the list.

projects-delete-transactions

4.Select a transaction on the list, and right-click. On the context menu, select the “Delete from project” option.

5.A confirmation message “Do you wish to continue?” will be displayed. 

Deleting a transactions will change the data included in reports for projects.

Before you click on the Yes button, you need to make absolutely sure that the correct transactions is selected.  

Delete / Remove transactions incorrectly updated in Project Quotes

Identify the posted transactions incorrectly affecting the Set of Books

The “Project Quote - D000001” on the Project Quote tab is included in the “All” option, when documents were posted (updated) to the ledger.    

projects-update-all-include-project-quote

The “Project Quote - D000001” on the Project Quote tab is not included in the “Invoice,” (or other document types, i.e. “Credit note”, “Purchase” or “Supplier return”) option, when documents were posted (updated) to the ledger.    

projects-update-invoices

The “Project Quote - D000001” on the Project Quote tab is posted as an invoice when selecting the “All” option on the Update ledger (Action ribbon). 

the transactions can be viewed and printed in the “Sales jnl.” batch on the “Batch entry” screen – Posted batches tab. The “Sales jnl.” is linked to the Invoice document type (Documents setup (Setup ribbon).

To view and print the transactions for the project quote in the sales journal (batch):

1.Click on Batch entry (Action ribbon).

2.Select the specific “Sales jnl.

3.Click on the Posted batches tab. All the posted batches will be listed.

projects-project-quote-transactions-x

The “Project Quote - D000001” on the Project Quote tab is posted as an invoice when selecting the “All” option on the Update ledger (Action ribbon). 

It is not listed in the Documents Invoicing (or any other document types, i.e. Quote, Credit note, Purchase or Supplier return): 

projects-project-quote-documents-selection

4.Identify and select the batch (e.g. “10053” - “Alias batch name” (Document number “D000001”). 

5.Double-click on the selected batch. The Details tab will list all the transactions posted (updated) to the ledger.

projects-project-quote-transactions-x-view

6.Click on the Print button. 

projects-project-quote-transactions-x-print


The incorrect posted Project Quote on the Trial balance

The “Project Quote - D000001” on the Project Quote tab which is posted (updated) to the ledger; overstates the figures on the Trial balance, as follows:    

projects-project-quote-transactions-x-trial-balance

The “Project Quote - D000001” on the Project Quote tab; if not posted (updated) to the ledger; should be excluded from the trial balance; as follows:    

projects-project-quote-transactions-ok


Fix the incorrect posted transactions for the Set of Books 

The transactions for the Project Quote, affect the global balances in the Set of Books. These transactions need to be cancelled.  

projects-project-quote-transactions-x-printed

To cancel / reverse the incorrect posted transactions: 

1.On the Setup ribbon, select Tools → Global processes → Reverse posted batch/document

projects-project-quote-reverse-document-menu

2.On the  “Reverse posted batch/document” screen, click on the Documents tab.

projects-project-quote-reverse-document

3.Select the incorrect transaction, i.e. “Project Quote – D000001”; and double-click on the selected document. The “Details” tab will list all the posted transactions.

projects-project-quote-reverse-document-view

4.Click on the Print button. 

projects-project-quote-reverse-document-print

5.Click on the Reverse posted document button.

A Warning message will be displayed:

 “This will radically alter your data! We recommend that you stop and make a backup!” 

Before you click on the Yes button, you need to make absolutely sure that the correct transactions is selected.  

6.Once ready, click Yes. The document will be removed, but not deleted. 

The document is not in the available to edit and repost, as is the case with all other documents. 

It is available for reposting. 

projects-project-quote-reverse-document-all


Delete the Project Quote document 

To totally remove the “Project Quote” document, you need to delete the document. 

To totally delete the “Project Quote” document:

1.On the Action ribbon, select Edit → Delete

2.Select Documents.

projects-delete-project-quote-menu

3.Select the document type “All”. 

projects-project-quote-delete-document

4.Select the Project Quote(s). 

The document number for Project Quotes is automatically generated and consists of 7-digits (D followed by 6 numeric digits). 

All other document numbers, should by default, consist of 8-digits.

5.Click the Delete button. A confirmation message will be displayed.

“Do you want to delete?”

6.Click on the Yes button.