Item cost variance report

The Item Cost Variance report lets you analyze purchases made from a certain vendor. Specifically, it lists items that have a cost difference between the invoice and purchase order, by vendor.

You run the report by an item or by a category of items. A category of items represents a manufacturer code, commodity code, purchasing class, or UNSPSC code.

  • Manufacturer codes identify the manufacturer

  • Commodity codes are helpful in analyzing spending patterns by type of item

  • Purchasing classes (major and minor) are another way of classifying items into "families" of like items

  • UNSPSC codes are a standard way of categorizing items that people buy (for example, mailing supplies and office equipment)

To report on item cost variance

  1. Load the necessary data by running this load program. Access Utilities > Data Extraction.

    • Click the Load PO Invoice Line Data program to extract invoice line data. Select the procurement group, beginning and ending match date.

    Note: 

    You can schedule load programs to run periodically (nightly or weekly, for example). To do so, click the Schedule button and complete the appropriate fields. In this case, you do not need to manually run the load program before running the report itself.

  2. Run the Item Cost Variance report by accessing Inquiries And Reports > My Reports > Item Cost Variance.

    Use the following guidelines to enter field values.

    Vendor

    Type the vendor you want to report on.

    From PO Date

    Type the from purchase order date you want to report on for the vendor.

    Thru PO Date

    Type the through purchase order date you want to report on for the vendor.

    Above Percent Variance

    This represents the percentage difference between the invoice and the purchase order.

    Above Amount Variance

    This represents the amount difference between the invoice and the purchase order.

    Purchases Option

    Indicate which purchases you want to display.

    • Purchases with or without a vendor agreement

    • Vendor agreement purchases only

    • Non-vendor agreement purchases

    Item

    Enter the item on which you want to report.

    Note: 

    You can report by item or category of items, but not both.

    Manufacturer Code

    Type the manufacturer code you want to report on.

    Division

    Type the manufacturing division you want to report on.

    Commodity Codes

    Type the commodity code to use for reporting.

    Purchasing Class Major and Minor

    Enter the major and minor purchasing class to report on.

    UNSPSC Segment

    Type the UNSPSC segment, family, class, and commodity to report on.

    Include Detail

    Indicate whether the report is to include PO detail, such as the date of the purchase order.

    Print Parameters

    Indicate whether parameters are to print on the report.