Inventory - Customer Sales Report

This report displays a list of the customers that have purchased the selected items within a selected period. It shows the quantity, amount, discount, profit and profit percentage. The report can be used in an analysis of customers' purchasing patterns.

You can specify what is included in the report by setting filters. If you do not set any filters, the report will include all your records.

On the Item and Value Entry tabs, you can fill in the standard field filters, or you can select additional filters. To do this, press F3, click the AssistButton and then select the relevant filter(s).

To print the report, click Print. To see the report on the screen before printing it, click Preview.

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

Item

No.: In the Filter field, you can specify the numbers of the items that you want to include in the report.

No. 2: In the Filter field, you can specify the alternative item numbers of the items that you want to include in the report.

Search Description: In the Filter field, you can set a filter on the Search Description field.

Bill of Materials: In the Filter field, enter Yes if the items that will be included in the report are BOMs.

Inventory Posting Group: In the Filter field, 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.

Value Entry

Posting Date: In the Filter field, you can enter a date to specify the beginning of the period for which information from the Value Entry table will be shown.

Source No.: In the Filter field, you can specify the source numbers that you want to include in the report.

Source Posting Group: In the Filter field, you can specify the source 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.



© 2009 Microsoft Corporation. All rights reserved.