Record Sheet

Use this report command to 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.

Landed Costs

Landed costs can be included if the Landed Costs option on the System - Maintenance - Company Profiles form is selected.

See the To Set Up Stock Control for Landed Costs Help topic for details on the steps that need to be followed to set up landed costs.

To Print the Record Sheets

  1. Open the Stock folder and then click Reports or click the Supply Chain Management tab on the Ribbon Bar and then click Stock - Reports.

  2. Click Stock Record Sheets.

  3. In the Sequence list, select the sequence option you want. You can produce the report in product or category sequence, then depending on the sequence you have selected, use the From and To lists to define the range of records you want included in the print run.

  4. To include details of warehouse stocks, select the Show Warehouse Stocks option.

  5. To include transaction details for the stock items included in the report, select the Show Transactions option.

  6. Select the Include Landed Costs option to include any landed costs in the cost price for each transaction (enabled if the Show Transactions option is selected).

  1. Click OK. On the Publisher form, click the tab to select the output device you want to use and then complete any settings or options you want to apply to the output device. To process the output, click Publish.