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

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

stock-edit-transactions-tab

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

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.

a)Positive Quantities - Purchases and Credit notes – (Stock In).

b)Negative Quantities – Invoices and Supplier returns (Stock Out).

3.Cost price – The cost price of each item (Exclusive of Input Tax).

In the case of Purchases and Supplier returns, the cost price and selling price will be the same.

4.Selling price – The selling price of each item (Exclusive of Output Tax).

In the case of Purchases and Supplier returns, the cost price and selling price will be the same.

5.Document row - The row or line number of the stock item on the document. Row 0 = Line 1, Row 1 = Line 2, Row 2 = Line 3, etc.  

6.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 on some screens and reports. 

Document numbers prefixed with "ST" e.g. "ST00001" (a 7-digit document number (not 8-digits) - 4 zeroes not 5 zeroes) are generated when stock quantities are changed in the Input → Adjust stock menu on the Action ribbon - See Change Stock quantities)

Document numbers prefixed with "SA" e.g. "SA00001" (a 7-digit document number (not 8-digits) - 4 zeroes not 5 zeroes) are generated when the BOM (Production) stock item type is Assembled or Disassembled.  

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 Stock information on the Setup ribbon..

The Selling price as selected on the Accounting information tab of a selected debtor (customer / client) account (Debtors on the Action ribbon).

7.Reference - The reference as entered in the "Your reference" field on the document header.

8.User - The user who process the document; if users were set in Access control (Setup ribbon).

9.Cum

10.id

11.Posted -

o0 – Invoices, Credit notes, Purchases and Supplier returns are not yet posted (updated) to the ledger. 

o1 – Invoices, Credit notes, Purchases and Supplier returns are posted (updated) to the ledger. 

12.Document type - Invoices, Point-of-Sale Invoices, Credit notes and Quotes, Purchases, Supplier returns and Orders on which the stock item was selected. In the case of stock adjustments, the document type will indicated as "Stock -".