Inventory Cost and Price List Report

This report displays a list of price information for the selected items or stockkeeping units: direct unit cost, last direct cost, unit price, profit percentage and profit.

If you want to include more information, on the Item tab you can select additional fields to be included in your report. To do this, press F3, click the AssistButton and then select the relevant field(s).

You can specify further what is included in the report by setting filters. If you do not set any filters, the report will include all your records. You can also determine what is shown in the report by filling in the field on the Options tab.

To print the report, click Print. To see the report on the screen before printing it, click Preview. if you want to save your report and print it later, click Cancel. The program automatically saves your settings.

To set filters in the report, fill in the fields as follows:

Item

No.: Here you can specify the numbers of the items that you want to include in the report.

Location Filter: In this field, you can enter the locations that you want to include in the report.

Variant Filter: In this field, you can enter the item variants that you want to include in the report.

Search Description: Here you can set a filter on the Search Description field.

Bill of Materials: Enter Yes if the items that you want to include in the report are BOMs.

Inventory Posting Group: Here you can specify the inventory posting groups that you want to include in the report.

Click the up-arrow in the lower left-hand corner of the window to see the results of the filters you have defined for the table.

To see the sorting keys and determine the order in which the information will be displayed in the report, click Sort.

Options

Use Stockkeeping Unit: If this field contains a check mark, the report will be based on stockkeeping units rather than items.

Print to Excel: Place a check mark in the check box if you want to export the data to an Excel spreadsheet for further analysis or formatting before printing.