The Stock Activity Report will only include the sales documents (Invoices and Credit Notes) and the purchase documents (Purchase or Goods Received Notes and Stock or Goods Returned documents entered in the Input - Documents menu option and which posted or updated to the ledger. If you are using the Point-of Sales facility, only the Point-of Sales Invoices for Shifts, which have been closed, will be included in this report.

This report is generated on the Stock Activity Options screen on which the following options criteria for the details to be included in this report is selected:

1. Sequence - To list the details for the selected stock items included in this report according to the Stock Item Code, Description or Stock Groups 1 or 2 if you have created Stock Groups.
   
   
2. Stock Code - select a specific stock item code or a range of codes on the Stock Item search or lookup facility.
   
   
3. Select whether to print each stock item on a new page.

This report summarises or lists quantities and Sales amount and the Cost Price (average or latest cost), the Gross Profit Percentage for This Year for each accounting period or month in the financial year. The number of Accounting Periods in a Financial Year is usually 12, unless you have selected the number of Accounting Periods to be 12 or any number less than 12 in the Setup - System Parameters - Reporting Dates menu option. If you have processed documents in the previous financial year, the Stock movements will also be displayed for Last Year. An example of the Stock Activity report reflecting the details, is as follows:



The detail for this report is displayed in 9 columns. The first column is the Accounting Periods and the next 4 columns display the Quantity, Amount, Cost Price and Gross Profit for the Items sold This Year. The last 4 columns displays the quantity, amount, cost price and gross Profit for the Items sold Last Year. The details in the columns is as follows:

1. Stock Item and Periods - The Stock Item code and description will be displayed as headings. The periods as set up or entered in the Setup - System Parameters - Reporting Dates menu option will be listed.
   
   Sold this year
   
   
2. Quantity - This is the total net quantity of the Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the current financial year (This Year).
   
   
3. Amount - This is the total amount or value of the selling prices (exclusive of VAT) for Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the current financial year (This Year).
   
   
4. Cost - This is the total amount or value of the cost prices (exclusive of VAT) for Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the current financial year (This Year). These cost prices may be based on the Average or Latest Cost depending on the parameters and settings for Cost of Sales.
   
   
5. GP% - Gross Profit Percentage - This is the Amount (selling prices) less the Cost amount displayed as a percentage.
   
   Sold last year.
   
   
6. Quantity - This is the total net quantity of the Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the previous financial year (Last Year).
   
   
7. Amount - This is the total amount or value of the selling prices (exclusive of VAT) for Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the previous financial year (Last Year).
   
   
8. Cost - This is the total amount or value of the cost prices (exclusive of VAT) for Invoices, Point-of-Sale Invoices and Credit Notes created and updated to the ledger in the displayed period of the previous financial year (Last Year). These cost prices may be based on the Average or Latest Cost depending on the parameters and settings for Cost of Sales.
   
   
9. GP% - Gross Profit Percentage - This is the Amount (selling prices) less the Cost amount displayed as a percentage.

These amounts or totals are exclusive of VAT.

---

The last 4 columns - Sold last year will only display quantities, amounts and gross profit percentages, if you have closed a financial year in the Tools - Global Processes - Do Year-end menu option.