Configuring Procurement Analysis Inquiries

To define procurement controls, use the Define Procurement Controls component (PRCR_ENTITY_CNTL). To define field candidates, use the Field Candidates component (PRCR_FLDCAN_TBL). To define profile inquiries, use the Profile Inquiries component (PRCR_PRF_OPR). To define views, use the View component (PRCR_VIEW_CAN).

This section discusses how to Configure Procurement Analysis Inquiries:

Page Name

Definition Name

Usage

Define Procurement Controls Page

PRCR_ENTITY_TBL

Set up reporting entities, which function as high-level groupings for your inquires and pagelets.

Field Candidate Setup Page

PRCR_FLDCAN_TBL

Select fields that you want to be eligible for selection for an inquiry type.

View Candidate Setup Page

PRCR_VIEW_CAN

Create views of procurement data to use in inquiry functions.

Inquiry Profile Setup Page

PRCR_PRF_OPR

Define up to seven inquiry profiles per user ID to be used as filters for viewing either history files or current data in procurement tables (called lists).

Setup Procurement Users Page

OPR_DEF_RPT_TBL

Assign users to a Reporting Entity and specify the periods for which data should be displayed.

Use the Define Procurement Controls page (PRCR_ENTITY_TBL) to set up reporting entities, which function as high-level groupings for your inquires and pagelets.

Navigation:

Purchasing > Analyze Procurement > Setup Profiles > Define Procurement Controls

Note: This page displays different fields depending on whether you are defining a procurement history reporting entity type or a spend analysis reporting entity type.

Procurement History Reporting Entity Type

Field or Control

Description

Chunk Size

Enter the number of rows to display at one time. To help improve performance, PeopleSoft recommends that you indicate a specific number of rows of data to retrieve (for example, 10 rows).

Calendar ID

Select the ID for a predefined calendar, which you set up on the Business Calendar page. Procurement analysis uses it to determine which data to retrieve and process based on dates.

Data Selection Criteria

Use the Data Selection Criteria group box to define high-level reporting entity data selection criteria.

Field or Control

Description

Include PO Data

Select if you want the inquiries for the reporting entity to include purchase order data.

Include all PO units

Select if you want to include all purchasing business units in this reporting entity.

Include AP Data (include accounts payable data)

Select if you want the inquiries for the reporting entity to include voucher data.

Include all AP units (include all accounts payable units)

Select if you want to include all accounts payable business units in this reporting entity.

Include Receiver Data

Select if you want the inquiries for the reporting entity to include receipt data.

Include all Receiving units

Select if you want to include all receiving business units in this reporting entity.

Include Lines With no Item ID

Select if you want to include lines with no item ID specified.

Business Unit

Select all the PeopleSoft Purchasing, Receiving or Payables business units for which this reporting entity is responsible. When updating the procurement history tables, the process selects all purchase orders assigned to the PeopleSoft Purchasing business units specified here.

Spend Analysis Reporting Entity Type

Field or Control

Description

Reporting Entity ID

Enter a unique identifier for spend history.

Reporting Entity Type

Select Spend Analysis.

Description

Enter a short description for the reporting entity.

Calendar SetID

Select the SetID for the calendar you wish to use to bucket expenditures.

Calendar ID

Select a predefined calendar in which to bucket purchase order expenditures. This calendar will determine how purchase order commitments will be displayed by period.

For example, if you selected a calendar where Period 1 was defined from 01/02/2005 to 01/29/2005 and Period 2 was from 01/30/2005 to 02/26/2005 and you created the following purchase orders:

  1. You have 2 purchase order schedules, one for 100.00 due 01/15/2005 and another for 200.00 due 1/30/2005.

  2. When the graph for the Buyer Spend Total is generated, you would see 100.00 in Period 1 and 200.00 in Period 2.

See Calendar Periods Page.

Currency Code

Select a currency to which all purchase order spend information will be converted. This will be the currency that all buyers or managers assigned this reporting entity will view their total spend information.

Rate Type

Select the rate type used to convert the currency for purchase orders.

Unit Type

Displays the business unit type. You have PO and AUC as the options.

Business Unit

Select all the PeopleSoft Purchasing business units for which this reporting entity is responsible. When updating the spend history tables, the process selects all purchase orders assigned to the PeopleSoft Purchasing business units specified here.

You should set up a reporting entity for all possible combinations of business units for which buyers are responsible. For example, if Buyer A and Buyer B both can purchase only for Purchasing Business Unit 1, you would need only one reporting entity. However, if Buyer A can purchase for Purchasing Business Unit 1 and 2 and Buyer B can purchase for Purchasing Business Unit 2 and 3, you would need two separate reporting entities.

When defining a manager as a buyer, you should ensure the reporting entity specified on the manager's dashboard preferences is either the same as the buyers for which he or she is responsible or encompasses all the business units for the buyers. For example, if both Buyer A and Buyer B purchased for Purchasing Business Unit 1 and reported to Manager XYZ, you could use the same reporting entity when setting up Buyer A, Buyer B and Manager XYZ However, if Buyer A purchases for Business Unit 1 and 2 and Buyer B purchases for Business Unit 2 and 3, you would need to set up a third reporting entity that included Business Units 1, 2 and 3 and assign that reporting entity to Manager XYZ. That way, Manager XYZ would be able to view all the business units for all the buyers for which he or she was responsible.

Use the Field Candidate Setup page (PRCR_FLDCAN_TBL) to select fields that you want to be eligible for selection for an inquiry type.

Navigation:

Purchasing > Analyze Procurement > Setup Profiles > Field Candidate Setup

Field or Control

Description

Inquiry Type

Displays the inquiry type that maps to the applicable view name below. Values include:

  • PO Schedule List (PRCR_LST_APO_VW).

  • Procurement History List (PRCR_HST_AAA_VW).

  • Receiver Schedule List (PRCR_LST_ARC_VW).

  • Requisition List (PRCR_LST_ARQ_VW).

  • Voucher List (PRCR_LST_AAP_VW).

Field Heading

Enter a user-defined field heading name that you use to identify the candidate field that you select in the Field Name field. When you define inquiry profile IDs, you define the field data that you want to retrieve by selecting from these field headings.

Field Name

Select the candidate field that you want to retrieve. The field must exist in the selected inquiry type view to be available for selection.

Field Type

Displays the field data type, such as numeric or character.

Use the View Candidate Setup page (PRCR_VIEW_CAN) to create views of procurement data to use in inquiry functions.

Navigation:

Purchasing > Analyze Procurement > Setup Profiles > View Candidate Setup

Field or Control

Description

View By

Displays the user-defined name of the view.

View ID

Select the view used to create the View By.

Inquiry Type

Select the inquiry type for which the view by value can be used. Types are:

  • History

  • PO List

  • Recv List (receiver list)

  • Req List (requisition list)

  • Vchr List (voucher list)

Use the Inquiry Profile Setup page (PRCR_PRF_OPR) to define up to seven inquiry profiles per user ID to be used as filters for viewing either history files or current data in procurement tables (called lists).

Navigation:

Purchasing > Analyze Procurement > Setup Profiles > PO Analysis Profile Inquires

Field or Control

Description

User ID

Select the user ID that uses the inquiry profile.

Procurement Profile ID

Select a profile ID. Seven profile IDs exist for each user ID:

  • PO History Items

  • PO Schedule List

  • Receiver History Items

  • Receiver Schedule List

  • Requisition List

  • Voucher History Items

  • Voucher List

RPT Entity (reporting entity)

Select the data selection criteria that are defined for the selected reporting entity that apply to the inquiry profile.

Inquiry Type

Displays the inquiry type with which the inquiry profile is associated. The profile can be used only by this corresponding procurement analysis inquiry.

View By

Select a view by which to display the inquiry. System-delivered views include By Supplier, By Ship To, or By Ship to by Supplier, but your organization can configure views and set them up by using the View Candidate Setup page.

Field Sequencing

Use the Field Sequencing group box to specify the inquiry fields and the sequence in which they appear. To change the sequence of the fields, use the arrows that are adjacent to the field heading.

You can override defaults that you configure here on the inquiry display pages.

Use the Set up Procurement Users page to assign users to a Reporting Entity and also specify the periods for which data should be displayed. Current period data is displayed in case no data is specified.

Navigation:

Purchasing > Analyze Procurement > Setup Procurement Operations > Setup Procurement Users

This example illustrates the fields and controls on the Setup Procurement Users. You can find definitions for the fields and controls later on this page.

Setup Procurement Users

Field or Control

Description

User ID

A user assigned to the reporting entity, can only be associated with one reporting entity. The user's reporting entity is used in the Procurement Operations Home Page and select procurement pivot grids.

Prior Periods

Enter the number of periods before the start of the current period at which you want to begin displaying procurement spend accumulation in the Procurement Operations Home Page.

Future Periods

Enter the number of periods after the start of the current period at which you want to end displaying procurement spend accumulation in the Procurement Operations Home Page.