Reports

The commands on the Reports submenu provide listings of records maintained in the Stock application. These include lists of records maintained through the various forms and transactions generated as a result of movement postings and other transaction processes. Reports can be used to view information on your computer screen as well as printing. Most reports provide a number of options to determine the criteria, sequence and range of records reported.

Report	Use
Audit Trail	Lists transactions. You can produce the report in product, entry order, category or warehouse sequence and for the range of transaction dates you specify. It includes information about location, description, type, date, reference, quantity and unit. The data used for this report is cleared when you use the Period End command on the Utilities menu.
Stock Movements	Produces summary of stock movements. You can produce the report in product, category or warehouse sequence and for the range of transaction dates you specify.
Issues Report	Produces a summary or detailed report on issues of stock. The report includes the stock reference, quantity, cost price, selling price, and margin. You can produce the report in product, category or warehouse sequence and for the range of transaction dates you specify. You can choose whether to include transactions, stock returns and landed costs if relevant.
Outstanding P/Orders	List of outstanding purchase orders. You can produce the report in product, category, supplier, warehouse or order number sequence and for the range of order due dates you specify. The report includes information about reference, warehouse, order due date, status, quantity ordered, quantity received and quantity outstanding.
Re-order Report	Produces a list of stock items that have fallen below their reorder level. You can produce the report in product, category, supplier or warehouse sequence. The report includes information about quantity balances for in stock, allocation, on order, reorder quantity, situation (for example, 'Zero' for zero stock levels) and supplier details.
Theoretical Stock	Produces a list of the in-stock quantities maintained by the application. You can produce the report in product, bin location, warehouse or category sequence and you can choose whether to include warehouse stocks, if appropriate. The report includes information about the in-stock quantity and packed units.
Stock Valuation	Displays the value of stock items. You can produce the report in product, warehouse and category sequence and choose whether you want the costing based on the stock cost, stock last cost, warehouse cost or warehouse last cost. The report includes information about the in-stock quantity, cost price selling price and value. Options for the report determine the following: whether negative stock items are included whether zero quantity stock items are included whether the FIFO stock is valued by transaction cost whether traceable items are valued at actual cost whether work in progress values are included (for components that have been issued to Bill of Materials) whether Landed Costs are included.
Historical Stock Valuation	Displays the value of stock items as at a date in the past. This report is available after the Stock Control - Utilities - Initialise Historical Stock Valuation command has been used, which sets up the necessary database that this report uses. You can produce the report in product, warehouse and category sequence. The report includes information about the in-stock quantity, cost price selling price and value. Options for the report determine whether negative or zero quantity stocks are included. Stock items that have been issued for a works order in the Bill of Materials application, and landed costs can also be included on the report. Options for the report determine the following: whether negative stock items are included whether zero quantity stock items are included whether work in progress values are included (for components that have been issued to Bill of Materials) whether Landed Costs are included.
Net Issues History	Displays stock issues, in summary for the current period and the past 12 periods. You can produce the report in product, category or warehouse* sequence. The report includes information about the period issues (per warehouse, if appropriate).
Stocktake Forms	Produces forms for stocktaking purposes. You can produce the report in product, bin location, warehouse or category sequence. The report includes information about reference, description, warehouse and bin location, and includes spaces for manually recording the physical quantity. If you are using traceability, you can choose to include traceable items.
Price List	Produces a list of prices for stock items. You can produce the report in product or category sequence. The report includes information about reference, description, standard price, discount allowed options and price changes.
Stock label	Print labels for stock items. You can produce the report in product, bin location, warehouse or category sequence. Labels include the reference, description, bin location, category and warehouse. You can determine the number of label copies per item and print an alignment check before printing the labels on appropriate stationery.
G.R.N Report	List the GRNs. The report includes information about the items received on GRNs and whether they have been released from quarantine. Options determine whether detail lines are included. You can also specify a range of receipt dates. You can produce the report in the following sequences: GRN number, Matched GRN (applies if the GRN is matched with a purchase order), Product, Warehouse, Supplier (applies if the GRN is matched with a purchase order) and Delivery note (applies if the GRN is matched with a purchase order).
R.T.V Report	Produce a list of RTVs. You can produce the report in RTV number, product, warehouse, supplier or return note sequence and for the range of return dates you specify. Options determine whether detail lines or extra detail lines are included. The report includes information about what items were returned on RTVs, together with quantity.
Record Sheet	Produce stock record sheets that provide full details including 'fixed' and 'variable' information relating to each stock item on a single page. You can produce the report in product or category sequence. You can choose whether to include warehouse stocks and transactions. If you use the Bill of Materials application, the report includes the labour and material costs along with the cost and selling prices for assembly stock items. Additional information is also included for work in progress, allocated to BOM, and works order quantities. The free stock takes into account the BOM allocated value.
Stock Notes	Prints the notes created for stock records. You can use selection criteria to determine which note records are listed. For example, you can restrict the list to a range of master records, persons identified in the Action For box, user records (those responsible for creating the notes) and action dates. You can also select by priority level and optionally include notes not intended for action, or that have already been marked as complete.
Tracking Report and Traceable Stock	These report commands are designed for traceable stock records and only apply if you have the traceability feature activated. For information about these enquiries, refer to the Traceability Help topics for information.
Landed Costs	The Landed Costs report displays the landed costs recorded when stock receipts were posted. You can sequence the report in different ways including by Landed Cost Type and Landed Cost Group. This report can be used to help with the reconciliation of expected landed costs with actual landed costs charged. After establishing the variances between expected and actual costs you can then work out any loss or gain and post a journal to the Nominal Ledger as necessary. You can also use this report to monitor the recorded landed cost values or percentages on the Landed Cost Types you have set up and make amendments if necessary.
Landed Costs Settings	The Landed Costs Settings report displays information about stock items that have Landed Cost Types assigned to them. The report displays the Landed Costs Types for each stock item, their default value, calculation method and also whether it is included in the aggregated cost calculation. The Landed Costs Types are grouped by Landed Costs Group if they are used. You can filter the information on the report by entering a stock item range in the Product Range box by selecting either 'Landed Cost Group' or 'Landed Cost Type' from the Filter By box and choosing the required range.

Report

Use

Audit Trail

Lists transactions. You can produce the report in product, entry order, category or warehouse sequence and for the range of transaction dates you specify. It includes information about location, description, type, date, reference, quantity and unit. The data used for this report is cleared when you use the Period End command on the Utilities menu.

Stock Movements

Produces summary of stock movements. You can produce the report in product, category or warehouse sequence and for the range of transaction dates you specify.

Issues Report

Produces a summary or detailed report on issues of stock. The report includes the stock reference, quantity, cost price, selling price, and margin. You can produce the report in product, category or warehouse sequence and for the range of transaction dates you specify. You can choose whether to include transactions, stock returns and landed costs if relevant.

Outstanding P/Orders

List of outstanding purchase orders. You can produce the report in product, category, supplier, warehouse or order number sequence and for the range of order due dates you specify. The report includes information about reference, warehouse, order due date, status, quantity ordered, quantity received and quantity outstanding.

Re-order Report

Produces a list of stock items that have fallen below their reorder level. You can produce the report in product, category, supplier or warehouse sequence. The report includes information about quantity balances for in stock, allocation, on order, reorder quantity, situation (for example, 'Zero' for zero stock levels) and supplier details.

Theoretical Stock

Produces a list of the in-stock quantities maintained by the application. You can produce the report in product, bin location, warehouse or category sequence and you can choose whether to include warehouse stocks, if appropriate. The report includes information about the in-stock quantity and packed units.

Stock Valuation

Displays the value of stock items. You can produce the report in product, warehouse and category sequence and choose whether you want the costing based on the stock cost, stock last cost, warehouse cost or warehouse last cost. The report includes information about the in-stock quantity, cost price selling price and value.

Options for the report determine the following:

whether negative stock items are included
whether zero quantity stock items are included
whether the FIFO stock is valued by transaction cost
whether traceable items are valued at actual cost
whether work in progress values are included (for components that have been issued to Bill of Materials)
whether Landed Costs are included.

Historical Stock Valuation

Displays the value of stock items as at a date in the past. This report is available after the Stock Control - Utilities - Initialise Historical Stock Valuation command has been used, which sets up the necessary database that this report uses.

You can produce the report in product, warehouse and category sequence. The report includes information about the in-stock quantity, cost price selling price and value. Options for the report determine whether negative or zero quantity stocks are included. Stock items that have been issued for a works order in the Bill of Materials application, and landed costs can also be included on the report.

Options for the report determine the following:

whether negative stock items are included
whether zero quantity stock items are included
whether work in progress values are included (for components that have been issued to Bill of Materials)
whether Landed Costs are included.

Net Issues History

Displays stock issues, in summary for the current period and the past 12 periods. You can produce the report in product, category or warehouse* sequence. The report includes information about the period issues (per warehouse, if appropriate).

Stocktake Forms

Produces forms for stocktaking purposes. You can produce the report in product, bin location, warehouse or category sequence. The report includes information about reference, description, warehouse and bin location, and includes spaces for manually recording the physical quantity. If you are using traceability, you can choose to include traceable items.

Price List

Produces a list of prices for stock items. You can produce the report in product or category sequence. The report includes information about reference, description, standard price, discount allowed options and price changes.

Stock label

Print labels for stock items. You can produce the report in product, bin location, warehouse or category sequence. Labels include the reference, description, bin location, category and warehouse. You can determine the number of label copies per item and print an alignment check before printing the labels on appropriate stationery.

G.R.N Report

List the GRNs. The report includes information about the items received on GRNs and whether they have been released from quarantine. Options determine whether detail lines are included. You can also specify a range of receipt dates. You can produce the report in the following sequences: GRN number, Matched GRN (applies if the GRN is matched with a purchase order), Product, Warehouse, Supplier (applies if the GRN is matched with a purchase order) and Delivery note (applies if the GRN is matched with a purchase order).

R.T.V Report

Produce a list of RTVs. You can produce the report in RTV number, product, warehouse, supplier or return note sequence and for the range of return dates you specify. Options determine whether detail lines or extra detail lines are included. The report includes information about what items were returned on RTVs, together with quantity.

Record Sheet

Produce stock record sheets that provide full details including 'fixed' and 'variable' information relating to each stock item on a single page. You can produce the report in product or category sequence. You can choose whether to include warehouse stocks and transactions. If you use the Bill of Materials application, the report includes the labour and material costs along with the cost and selling prices for assembly stock items. Additional information is also included for work in progress, allocated to BOM, and works order quantities. The free stock takes into account the BOM allocated value.

Stock Notes

Prints the notes created for stock records. You can use selection criteria to determine which note records are listed. For example, you can restrict the list to a range of master records, persons identified in the Action For box, user records (those responsible for creating the notes) and action dates. You can also select by priority level and optionally include notes not intended for action, or that have already been marked as complete.

Tracking Report and Traceable Stock

These report commands are designed for traceable stock records and only apply if you have the traceability feature activated. For information about these enquiries, refer to the Traceability Help topics for information.

Landed Costs

The Landed Costs report displays the landed costs recorded when stock receipts were posted. You can sequence the report in different ways including by Landed Cost Type and Landed Cost Group.

This report can be used to help with the reconciliation of expected landed costs with actual landed costs charged. After establishing the variances between expected and actual costs you can then work out any loss or gain and post a journal to the Nominal Ledger as necessary. You can also use this report to monitor the recorded landed cost values or percentages on the Landed Cost Types you have set up and make amendments if necessary.

Landed Costs Settings

The Landed Costs Settings report displays information about stock items that have Landed Cost Types assigned to them. The report displays the Landed Costs Types for each stock item, their default value, calculation method and also whether it is included in the aggregated cost calculation. The Landed Costs Types are grouped by Landed Costs Group if they are used.

You can filter the information on the report by entering a stock item range in the Product Range box by selecting either 'Landed Cost Group' or 'Landed Cost Type' from the Filter By box and choosing the required range.