Vendor/Item Purchases Report

This report shows a list of item entries for each vendor in a selected period. The report contains information on invoiced quantity, amount and possible discounts. It can be used, for example, to analyze a company's item purchases and to show whether there is a relationship between discounts and item purchases.

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 Vendor 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). You can also determine what is shown in the report by filling in the field on the Options tab.

To print the report, click the Print button. To see the report on the screen before printing it, click Preview. If you want to save the settings of the 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:

Vendor

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

Search Name: In the Filter field, you can enter the search names of the vendors that you want to include in the report.

Vendor Posting Group: In the Filter field, you can enter the vendor 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 result of the filters you have defined for the table.

Value Entry

Posting Date: In the Filter field, you can enter the posting dates of the item entries that you want to include in the report.

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

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

Options

New Page per Vendor: You can place a check mark in this field if you want the item statistics of each vendor to be printed on a separate page.



© 2009 Microsoft Corporation. All rights reserved.