This report displays a list of sales information about each item: direct unit cost, unit price, sales quantity, sales in LCY, profit and profit percentage. It also shows totals for all the items for the last four categories. The report can be used for analyses of profit on individual items or trends in revenues and profit.
You can define what is included in the report by setting filters. You can set additional fields on the Item tab by clicking the Field field, then clicking the AssistButton that appears to the right. You can also determine what is shown in the report by filling in the fields on the Options tab. Fill in the fields as follows:
No.: Here you can specify the numbers of the items to be included in the report. To see the existing item numbers, click the Filter field, then click the AssistButton that appears to the right.
Search Description: Here you can set a filter on the Search Description field.
Bill of Materials: Enter Yes if the items that will be included in the report are BOMs.
Inventory Posting Group: Here you can specify the inventory posting groups to be included in the report. To see the existing inventory posting groups, click the Filter field, then click the AssistButton that appears to the right.
Statistics Group: Here you can specify the statistics groups to be included in the report. The field can be used only if the corresponding field on the item card is filled in.
Unit of Measure: Here you can specify that only items with a particular unit of measure (such as pcs, pound or bushel) are included in the report.
Date Filter: Enter the period to be covered in the report (for example, 03/01/00..03/31/00).
Click the up-arrow at the lower left-hand corner of the window to see the result 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... .
Include Items Not Sold: Place a check mark in the check box to specify that items that have not yet been sold are also included in the report.
Click the Print button to print out the report. If you want to see the report on the screen before printing, click the Preview button. If you do not want to print the report now, click Cancel to close the window.