Update / Post documents

Parent Previous Next

This option is used to update (post) your documents created or generated in Action → Documents to the ledger. The debtor (customer / client) documents which can be updated (posted) to the ledger are Invoices and Credit notes. The creditor (supplier) documents are Purchase documents and Supplier return documents.

You may set the Auto-post documents on print option in Setup → Documents setup to update (post) documents automatically, once a document is generated and printed. If you use this feature, and do not print a document once it is generated, you need to update (post) the unprinted documents in Action → Update ledger .

Quotes for debtors (customers / clients) and Orders for creditors (suppliers) cannot be updated (posted) to the ledger.

Quotes - only when a Quote is confirmed and converted to an Invoice, can the Invoice be edited and updated (posted) to the ledger.

Orders - only when an Order is confirmed and converted to a Purchase document, can the Purchase document be edited and updated (posted) to the ledger.

When these documents are updated to the ledger they will automatically write up your journals and post the transactions to the applicable accounts in the ledger (the General ledger as well as the Debtor's ledger, Creditors ledger and Stock ledger).

If you have purchased stock items from a creditor (supplier), you need to update the Purchase documents before you update (post) your Invoices for sales of stock items to your debtors (customers / clients). This will ensure that your Stock item file will be updated with the purchases before you actually sell the stock items and that you will have sufficient stock items on hand when you update (post) the Invoices.

Update ledger - Documents

To Update the ledger:

1.On the Action ribbon, select Update ledger (F3).

If the Document Posting option is selected on the Documents tab - Setup → Access control, the Posting button will be added to the sidebar of the Document list screen. Clicking on this button will launch the Update ledger - Documents screen.

The Update Invoices screen is (Invoices - default document type) displayed:

If the row in which a document is listed is shaded (light cream colour) (in this example IN000012),  it indicates that the document is printed. The white, grey or peach shades in the rows, indicates that a document is not yet printed. You may wish to print these documents before updating them.

The document number, e.g. IN000009, as per this example, indicates the last document number which is updated or posted to the ledger (during the active (opened session of the Set of Books.

If the Set of Books is opened before accessing the Update ledger screen, no document number will be displayed in the status bar.

2.Document type - Select Invoices, Credit notes, Purchases or Supplier returns. If you select the All option, all these document types will be listed.

The same screen will change to reflect the selected document descriptions. If you have any documents for the selected Document type, they will be listed.

3.Select the following options:

a)Suppress open item  - By default the following Open item selection screens will be displayed on which you need to link the debit and credit transactions when updating (posting) documents:

Open item selection screen for Debtor (customer / client) accounts if the Use Open item field on the Accounting information tab is selected.

Open item selection screen for Creditor (supplier) accounts if the Use Open item field on the Accounting information tab is selected.

b)Select the Suppress Open item field, if you do not wish to use the Open item link selection feature to be launched when updating or posting documents. You may then later use the Open item link feature to link the transactions.

c)From ... To - This will display From ... To and the name of the Document type. This option allows you to select a starting document number on a drop-down list and a last document number which you need to update (post) to the ledger. All documents within the selected range of document numbers will be updated (posted) to the ledger.

If you need to update (post) only one document to the ledger, the document number in the From ... To fields must be the same.

d)Selected - If you select this option, the From ... To fields and the drop-down lists of document numbers will be de-activated. An arrow will indicate the selected document.

You may also use the Down arrow or Up arrow keys on your keyboard to select a document from the list.  

4.Click on the Update button. TurboCASH will automatically write up the transactions in the respective batches (journals), as selected in Setup → Documents setup.

Finding or locating specific documents

You may also use the following options to find or locate a specific document (documents):

1.Search by Invoice no. - (or document number for the selected document type) will reflect the Search by the selected Document type no.

2.Enter the Document number - The document number will automatically be selected. If not, click on the Search button.

Sort sequences

Double-click on the column headings to sort the list of documents ascending or descending:

1.Invoice no. - (or document number for the selected document type) - By default, all document numbers are displayed ascending (smallest document number to the latest document number). If you double-click on this heading, it will list the Invoice no. (or document number for the selected document type) descending (from the latest document number to the smallest or first document number).

2.Date - By default, the document dates are listed by document numbers. The dates may not necessarily be in the ascending sequence. To display the dates in the descending sequence (from the latest date to the newest date), double-click on this heading. To display the dates in the ascending sequence (oldest date to the latest date), double-click on this heading again.

3.Account - By default, the Debtor accounts (Invoices and Credit notes) and Creditor accounts (Purchases and Supplier return documents) are listed by document numbers. The Debtor / Creditor account codes may not be displayed in the ascending sequence. To display the Debtor / Creditor account codes in the descending sequence (9-0 / Z-A), double-click on this heading. To display the Debtor / Creditor account codes in the ascending sequence (0-9 / A-Z), double-click on this heading again.

4.Description - By default, the Debtor accounts (Invoices and Credit notes) and Creditor accounts (Purchases and Supplier return documents) are listed by document numbers. The Debtor / Creditor account descriptions or names may not be displayed in the ascending sequence. To display the Debtor / Creditor account descriptions or names in the descending sequence (9-0 / Z-A), double-click on this heading. To display the Debtor / Creditor account descriptions or names in the ascending sequence (0-9 / A-Z), double-click on this heading again.

Context menu options

If you select a document on the list, you may right-click to launch the following context menu:

The options are as follows:

1.Set as From Option - This will set and display the selected document number as the starting document number in the range options From ... field.

2.Set as To Option - This will set and display the selected document number as the end document number in the range options To... field.

3.Update - This will update (post) the document to the ledger.

Created with the Personal Edition of HelpNDoc: Easily create Qt Help files