This will list all sales documents (i.e. Invoices, Point-of-Sale Invoices, Credit notes and Quotes) as well as any purchase documents (Purchases, Supplier returns and Orders) on which the stock item was selected.

These will only include documents, which have been updated (posted) to the ledger. Only Quotes which have been converted to Invoices and Orders which have been converted to Purchase documents, will be listed.

To change the sequence of the lists, click on a heading.

You may double-click on a selected document to print it.

The columns are as follows:

  1. Date – The date on which the documents are generated and updated (posted) to the ledger.
  2. Items – This displays the number of items quantities as specified in the Quantity Ship field of document lines.
  3. Document no. - The document number as automatically generated.

If document numbers were not prefixed for each document type, with IN, CR, PU and SR it would virtually be impossible to identify the correct document type. 
  1. Description – The description (name) of the Stock item.
  2. Price – The price is as follows:
    1. Cost price of each item (Exclusive of Input Tax) for purchase documents (i.e. Purchases, Supplier returns and Orders).
    2. Selling price of each item (Exclusive of Output Tax) for sales documents (i.e. Invoices, Point-of-Sale Invoices and Credit notes).
  3. Discount – The discount percentage as entered in the discount column for the stock item.
  4. Unit Price – The price is as follows:
    1. Cost price of each item (Exclusive of Input Tax) for purchase documents (i.e. Purchases, Supplier returns and Orders).
    2. Selling price of each item (Exclusive of Output Tax) for sales documents (i.e. Invoices, Point-of-Sale Invoices and Credit notes).The cost price of each item (Exclusive of Input Tax).
  5. Exclusive – The selling price (for sales documents) exclusive of Output Tax or the purchase price (for purchase  documents) exclusive of Input Tax for the number of items (unit price x quantity) minus the discount amount.
  6. Inclusive - The selling price (for sales documents) inclusive of Output Tax or the purchase price (for purchase  documents) inclusive of Input Tax for the number of items (unit price x quantity) minus the discount amount.
  7. Posted - 1 = Posted and Unposted = 0.

You may use the context menu (right-click) to open selected document(s).

If document numbers were not prefixed for each document type, with IN, CR, PU and SR it would virtually be impossible to identify the correct document type. 

Selling prices 1 / 2 / 3 as selected on sales documents. If not selected on sales documents, these will automatically be used from the following settings:

  • Global Setting – The Default selling price as selected in Setup → Stock information.
  • The Selling price as selected on the Accounting information tab of a selected Debtor account.