Old Reports - Purchases by Product

Parent Previous Next

Bug

The Purchases by Product report (Tools → Old Reports → Purchase Analysis → Purchases by Product menu) only includes the default stock item type. It does not include any other stock item types (e.g. ten (10) stock item types i.e. Sales, Sales (No Stock), Purchases, Purchases (No Stock), Financial Entry, Option Item, Option Item (No Stock), BOM (Bills of Materials), BOM (Production), Linked Sale).

This option allows you to view and analyse your Purchases by Product. This report may be retrieved on a summarised level to see the totals of your Purchases for each of your Products, or you may view the detail of your Purchases for each of your Products.

This report summarises or lists all the Purchase and Supplier Returns documents, for each Stock Item within a selected period or range of dates. You will be able to analyse the purchase and returns totals for each selected stock item.

Print Purchases by Product Reports

To Generate a Purchases by Product Report:

1.Click on the Tools  → Old Reports → Purchase Analysis → Purchases by Product menu.

The Purchases by Product Options screen is displayed:

2.Send Report To - Select the output method (screen, printer, file, e-mail or fax).

3.Select the following options:

a)Sequence - Select to list the Products according to the Stock Code, Stock Description and Stock Groups 1 or 2 (Reporting Groups 1 and 2).

The description of Stock Group 1 or 2 you have entered on the Reporting Group Name field on the Stock Groups tab on the Setup → System parameters → Groups menu, may be reflected in this drop-down list.

b)Show Details - If this field is left blank, you will view the totals of the Purchases for each of your Products.

If this field is selected, the detail of the Purchase and Supplier Returns documents (the date and number) will be displayed for each individual Purchase documents. The total for each product, as well as a grand total of your total purchases will be displayed.

c)From Product ... To - Select the stock code, or a range of stock codes, to include in the report.

d)From ... To - Select the start and end date to include in this report.

4.Click on the OK button to send the report to the medium selected in the Send Report to field.


View Purchases by Product Reports

An example of the Purchases by Product report, reflecting the details, is:

This report consists of eight (8) columns, reflecting the following information:

1.Stock Item Code - The selected stock item code or numbers will be displayed. This report will be listed according to the selected Stock Item Codes.

2.Purchase Number - The Purchase and Supplier Returns document number as generated by TurboCASH. The Description or name of the Stock Items will be displayed as headings.

3.Purchase Date - The date when the Purchase and Supplier Returns documents were generated.

4.Quantity - The quantity of Stock Items, as entered on the Purchase and Supplier Returns documents.

5.Purchase Amount - This is the total amount of the Cost or Purchase price for all the selected stock items on the Purchase and Supplier Returns documents.

6.Net Cost Amount - This is the total amount of the Cost or Purchase price for all the selected stock items on the Purchase and Supplier Returns documents.

7.Gross Profit - Not applicable to the Purchase and Supplier Returns documents.

8.Gross Profit % - Not applicable to the Purchase and Supplier Returns documents.

These amounts or totals are exclusive of VAT/GST/Sales Tax.

Totals will be displayed for each of the selected stock items, and a grand total for all the stock items included in this report.


Created with the Personal Edition of HelpNDoc: Easy CHM and documentation editor