Creating consolidated records for Spend Analysis

Use this procedure to create consolidated spend records, which you can view on Spend Analysis. Consolidate Spend Analysis consolidates raw invoice detail data into useful summaries and views.

Note: 

You may want to run Load And Consolidate Spend Analysis to both load and consolidate invoice data the first time you create spend analysis data. After that, you may want to use Load And Consolidate Spend Analysis to update the invoice data from accounts payable and purchase order to build your records (perhaps use Schedule to create an update that runs nightly). In a separate run, you would use Consolidate Spend Analysis to create the consolidated records for viewing in Spend Analysis.

Monitor set action programs using My Actions. Select your action in the list and the Action Instances region shows the progress or status of the action. Once your action finished, it will disappear from the form.

You must load invoice detail information using Load And Consolidate Spend Analysis before you can create consolidated spend records.

To create consolidated records for spend analysis

  1. Access Spend Analysis > Consolidate Spend Analysis.
  2. Select the vendor group.
  3. Use the following guidelines to enter field values.
    Consolidation Date Range

    Select a date range or select the Consolidate The Last Twelve Months field.

    Consolidate The Last Twelve Months

    You must select this field or enter a consolidation date range.

    Consolidation Options

    Select at least one consolidation option.

    You can use different consolidation date ranges for different consolidation options (you would have to run the program multiple times).

  4. Optional. You can use the Schedule... button to set the set action to run regularly.
  5. Select OK.

    When this program runs, all old consolidation records for the consolidation options selected are purged. You see only the newest records on the Spend Analysis form.