Commodity spend by vendor report

The Commodity Spend by Vendor report shows the amount that was spent by a vendor for a commodity code. The report is useful in identifying vendors previously used to procure a commodity and the amount of business done with each vendor.

The report lists purchasing in both graphical and text format, including:

  • Vendor group and vendor

  • Item and item type

  • Purchase total in base currency

  • Total amount spent for the given commodity code

To report on commodity code spend by vendor

Access My Reports > Commodity Spend by Vendor.

Use the following guidelines to enter field values.

Company

Type the company you want to report on.

Vendor Number

Type the vendor number whose purchases you want to evaluate.

Note: 

Type an asterisk to report on all vendors.

Commodity Code

Type the commodity code to report on.

Note: 

Type an asterisk to report on all commodity codes.

Item Type

Select the type of item to include on the report:

  • Inventory

  • Non-stock

  • Special

  • Service

PO Codes

Type purchase orders codes to include on the report.

Note: 

You separate multiple values by typing an asterisk.

Invoice Date Range

Type the beginning and ending invoice date range that you want to report on.

Include PO Detail

Indicate whether to include detail about the purchase orders.

Include Invoice Detail

Indicate whether to include detail about the invoices.

Print Graph

Indicate whether to print the graph on the report.

Print Parameters

Indicate whether to print the parameters on the report itself.