Defining Procurement Options

This chapter provides an overview of procurement options and discusses how to:

Click to jump to parent topicUnderstanding Procurement Options

To define bank replacement rules, use the Bank Replacement Rules component (BANK_RPL_RULE_DEFN).

In addition to the tables that all PeopleSoft applications share, there are tables specific to PeopleSoft Payables and PeopleSoft Purchasing that form the foundation of the procurement system. Before you begin entering requisitions, purchase orders, or vouchers, you need to configure these tables to define the accounts payable and purchasing environments. Use the pages described in this chapter to configure these tables. Most of these pages can be found in the Set Up Financials/Supply Chain, Product Related, Procurement Options menu.

This chapter does not discuss all of the components found in that menu, however. The following table lists the procurement option components and pages that we discuss in the PeopleSoft Payables PeopleBook:

Component

Page Names

Chapter

Stamp Tax (APD_STAMP_TAX_COM)

  • Stamp Tax

  • Stamp Tax Rule

See Processing Drafts.

Define Aging Categories (AP_AGING_CYCLE)

AP Aging Cycle

See Reporting and Reconciling Open Liabilities.

Bank Replacement Rules (BANK_RPL_RULE_DEFN)

Bank Replacement Rule

See Establishing Pay Cycles.

Sight Codes (APD_SIGHT_CODE_COM)

Draft Sight Codes

See Processing Drafts.

Reschedule Payments Conditions (SMT_SPLIT_CDTN_COM)

Reschedule Payments

See Using Additional Payment Processing Options.

Voucher Origin (ORIGIN1)

  • Accounting and Pay Options

  • Vouchering Options 1

  • Vouchering Options 2

  • Tax Options

See Organizing Vouchers with Origins and Control Groups.

All within the Withholding menu.

All pages

See Organizing Vouchers with Origins and Control Groups.

All within the Reports menu.

All pages

See PeopleSoft Payables Reports.

(USF) Regional Financial Code (RFC_CODE)

Regional Financial Code

See (USF) Processing PeopleSoft Payables for U.S. Federal Agencies.

(USF) Payment Schedule (SCHD_PYMNT_MTHD)

Payment Schedule Restrictions

See (USF) Processing PeopleSoft Payables for U.S. Federal Agencies.

(USF) Spending Region Installation (SPNDNG_REG_INST)

(USF) Spending Region Definition (SPNDNG_REG_DFN)

Spending Region Install Option

Spending Region Definition

See (USF) Processing PeopleSoft Payables for U.S. Federal Agencies.

Click to jump to parent topicDefining Miscellaneous Charges and Landed Costs

To define miscellaneous charges and landed costs, use the Misc Charge/Landed Cost Defn component (miscellaneous charge and landed cost definition component) (CM_LC_COMPONENT).

This section discusses how to define miscellaneous charges and landed costs.

See Also

Defining Miscellaneous Charges and Landed Costs

Click to jump to top of pageClick to jump to parent topicPage Used to Define Miscellaneous Charges and Landed Costs

Page Name

Object Name

Navigation

Usage

Misc Charge/Landed Cost Defn (miscellaneous charge and landed cost definition)

CM_LC_COMPONENT

Set Up Financials/Supply Chain, Product Related, Procurement Options, Charges/Costs, Misc Charge/Landed Cost Defn, Misc Charge/Landed Cost Defn

Set up miscellaneous charges, along with their purchasing attributes and landed cost component information.

Click to jump to top of pageClick to jump to parent topicSetting Up Miscellaneous Charges and Landed Costs

Access the Misc Charge/Landed Cost Defn page.

Type

Select a charge type for the miscellaneous charge. Values are:

Freight Expense: Freight charges calculated by the PeopleSoft Structure Freight/Transport menu.

Miscellaneous Charge Expense: Miscellaneous charges set up for PeopleSoft Purchasing item and category vendor relationships.

Sales Tax Expense: System-calculated sales tax that needs to be accounted for as a landed cost.

Use Tax Expense: System-calculated use tax that needs to be accounted for as a landed cost.

VAT Input Non-Recoverable (value-added tax input nonrecoverable): System-calculated VAT that needs to be accounted for as a landed cost.

Prorate

Select to prorate this miscellaneous charge among invoice lines according to the distribution proportions established on the purchase order schedule.

If you choose not to prorate the charge, and then subsequently choose to use the landed cost component, the system selects this option and renders the check box unavailable for entry. Non-prorated charges are written to a general ledger account as per the accounting entry template and are therefore not included as part of the landed cost component.

Purchasing Attributes

Calculation Method

Select a calculation method for the system to use to derive the charge when the charge is defined for an item or category. The calculation method determines the expected charge for the landed cost component. Values are:

% Value (percent of value): Miscellaneous charges are a percentage of the total value of the items.

Flat Amt (flat amount): Vendor charges a flat amount.

Free: No miscellaneous charges.

Freight: Vendor charges for freight costs.

Sales Tax: Default value when the charge type is set to Sales Tax Expense.

Unit Amt (unit amount): Miscellaneous charges are calculated by unit of measurement.

Use Tax: Vendor charges a system-calculated use tax. This is the default value when the charge type is set to Use Tax Expense.

VAT (value-added tax): The nonrecoverable portion of VAT is included in the inventory value. This is the default value when the charge type is set to VAT Input Non-Recoverable.

Volume: Miscellaneous charges are calculated by volume.

Weight: Miscellaneous charges are calculated by weight.

Allocation Method

Select an allocation method for this miscellaneous charge. The system uses the allocation method to create line and schedule estimates when the landed cost component is attached to a purchase order header. Values are:

Matl Value (material value): Allocation estimates are based on the material value of the items.

Quantity: Allocation estimates are based on the quantity of items.

Volume: Allocation estimates are based on the volume of items.

Weight: Allocation estimates are based on the weight of items.

Landed Cost Component

Select if the miscellaneous charges have a landed cost component. If you select this option, the system selects the Prorate and the Accrue Charge check boxes by default. The Prorate check box is then unavailable for selection because you cannot use the landed cost component without prorating the cost. The Accrue Charge check box remains active unless you also select the Merchandise Vendor Charge check box, in which case it is unavailable for selection. Also, when you select this check box, the fields in the Landed Cost Component Info group box become active.

RTV Credit (return to vendor credit)

Select if you will receive credit from the vendor for these miscellaneous charges if you return any of the items. This check box is active only if the Merchandise Vendor Charge option is selected.

Merchandise Vendor Charge

Select if the miscellaneous charges are typically charges by the merchandise vendor. If this check box is selected, the charge appears on the purchase order when it is dispatched to the vendor. Do not select this check box if the charge is typically billed by a third-party vendor. When you select this check box, the RTV Credit check box becomes active.

If you have selected the Landed Cost Component check box and subsequently select the Merchandise Vendor Charge check box, the system selects the Accrue Charge check box by default and makes it unavailable for selection. You cannot use the landed cost component and merchandise vendor charges without accruing the charges to an expense account.

Landed Cost Component Info

Cost Element

Select a cost element for the miscellaneous charge. A cost element is a type of cost such as freight or handling costs.

Landed Cost Group

Select the landed cost group to which this miscellaneous charge belongs. Landed cost groups are defined on the Misc Chg/Landed Cost Template page.

% Ext Amount Tolerance (percent extended amount tolerance)

Select a total amount tolerance percentage. The tolerance amount is used to automatically close purchase orders and receipts for landed costs if the invoice amount is within tolerance of the purchase order amount.

Qty Rcvd Tolerance % (quantity received tolerance percent)

Select a percent tolerance for received quantities. The tolerance is used to automatically close purchase orders and receipts for landed costs if the invoice quantity is within tolerance of the purchase order.

Accrue Charge

Select if the miscellaneous charge is to be included in inventory value at putaway. If this check box is cleared, the charge is expensed upon invoicing.

See Also

Defining Miscellaneous Charges and Landed Costs

Click to jump to parent topicDefining Miscellaneous Charge and Landed Cost Templates

To define miscellaneous charge and landed cost templates, use the Misc Chg/Landed Cost Template component (miscellaneous charge and landed cost template component) (CM_LC_TEMPLATE).

This section discusses how to define miscellaneous charge and landed cost templates.

See Also

Defining Miscellaneous Charges and Landed Costs

Click to jump to top of pageClick to jump to parent topicPage Used to Define Miscellaneous Charge and Landed Cost Templates

Page Name

Object Name

Navigation

Usage

Misc Chrg/Landed Cost Template (miscellaneous charge and landed cost template)

CM_LC_TEMPLATE

Set Up Financials/Supply Chain, Product Related, Procurement Options, Charges/Costs, Misc Chrg/Landed Cost Template, Misc Chg/Landed Cost Template

Group miscellaneous charge types in a single template. Use landed cost templates to conveniently apply groups of charges to a vendor item definition. Charges that are available for selection are defined on the Misc Charge/Landed Cost Defn page.

Click to jump to parent topicDefining SpeedCharts

To define SpeedCharts, use the SpeedChart component (SPEEDCHART).

This section provides an overview of SpeedCharts and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding SpeedCharts

SpeedCharts greatly increase data entry efficiency by reducing the number of keystrokes required to enter frequently used ChartField combinations. SpeedChart codes can be defined with multiple accounting distributions and are used by entering the SpeedChart code during data entry instead of the individual ChartField combinations.

The system automatically prorates accounting line amounts according to the proration percentages defined on the SpeedChart. You can define a skeleton SpeedChart where the total percentage is zero if you need to enter requisitions, purchase orders, or vouchers where the ChartField values are constant but the accounting line amounts vary.

For example, suppose that all departments in the organization use express mailing services, but the actual charge for any one department varies from month-to-month. In this case, a specific percentage does not apply to each distribution accounting line. When you use this type of SpeedChart, during data entry you supply the accounting line amounts. When needed, you can define SpeedCharts based on an item's unit of measurement weight rather than by percentage.

As another example, suppose that you set up a SpeedChart to define a distribution for equipment upgrade expenses so that each department is billed a percentage of the total amount. The system automatically prorates distribution line amounts according to the proration percentages defined on the SpeedChart. The distribution line with the largest amount receives any remainder caused by rounding the distributions. Once you set up the SpeedCharts, you can generate a report that displays information about the SpeedCharts.

It is important to understand the difference between PeopleSoft SpeedCharts and PeopleSoft SpeedTypes. PeopleSoft SpeedCharts enable you to group together and name an unlimited number of ChartField combinations, while PeopleSoft SpeedTypes enable you to assign a code to a single ChartField combination.

Vouchers, purchase orders, and requisitions use accounting information from the control hierarchy. This information is ignored when you use SpeedCharts.

See Also

PeopleSoft Source-to-Settle Common Information Reports

Click to jump to top of pageClick to jump to parent topicUnderstanding Multiple SpeedCharts

Multiple SpeedChart functionality provides you with the ability to choose whether you want to override or append multiple SpeedCharts to existing ChartField values; existing single SpeedChart functionality always overwrites existing ChartField values. Use Multiple SpeedChart to automatically calculate distribution quantities, amounts, and percentages regardless of the selected distribution method; existing single SpeedChart functionality does not automatically calculate these values when distributing by quantity.

Click to jump to top of pageClick to jump to parent topicPage Used to Use SpeedCharts

Page Name

Object Name

Navigation

Usage

SpeedChart

SPEEDCHART

Set Up Financials/Supply Chain, Product Related, Procurement Options, Management, SpeedChart, SpeedChart

Define SpeedChart codes for frequently used ChartField combinations to increase data input efficiency by reducing the number of keystrokes.

Maintain Requisitions - Schedule

REQ_SCHEDULE

Purchasing, Requisitions, Add/Update Requisitions, Schedule

Specify multiple shipping schedules for each requisition line and define multiple distributions for each schedule.

Distribution Information

REQ_DISTRIB_DETAIL

Click the Distribution link on the Maintain Requisitions - Schedule page.

Enter distribution details for each requisition schedule. Define accounting distributions for each schedule. Assign internal delivery location, asset, project, and inventory information to distributions.

Maintain Purchase Orders - Schedule

PO_SCHEDULE

Purchasing, Purchase Orders, Add/Update Purchase Orders, Schedule

Specify ship to locations, quantities, due dates, comments, sales and use tax amount, miscellaneous charges, price adjustments, and multiple distributions to purchase order schedules.

Distributions

PO_SCHED_DISTRIB

Click the Distributions link from the Maintain Purchase Orders - Schedule page.

Define multiple distributions for a purchase order schedule.

Multiple SpeedCharts

RUN_POSPCHARTS_OL

Click the Multi-SpeedCharts link on the Distributions page.

Assign multiple SpeedCharts to a single purchase order schedule to create applicable distribution lines.

Click to jump to top of pageClick to jump to parent topicDefining SpeedCharts

Access the SpeedChart page.

Total Percent

Indicates the total of the proration percentages that you selected for the SpeedChart lines.

Security Option

Universal (All Users)

Select to make a SpeedChart available to all users.

One User

Select to make a SpeedChart available to one user. When you select this option, enter a value in the adjacent field.

Permission

Select a permission level that users need to have to access the designated SpeedChart. When you select this option, enter a value in the adjacent field.

Note. You must enter at least two ChartField distributions unless you use the Universal user, in which case you can enter a single ChartField distribution.

Definition

Enter Percentages

Select to distribute cost by a percentage of the total amount. When you select this option, enter a proration percent value for each SpeedChart line.

Enter Weights

Select to distribute cost by item unit of measurement weight. When you select this option, enter a proration weight value for each SpeedChart line.

UOM (unit of measurement)

Select a unit of measurement for distributing cost by weight.

Click to jump to top of pageClick to jump to parent topicUsing Multiple SpeedCharts with Requisitions

Access the Distribution Information page.

Open Qty (open quantity)

If the Distribute by option is set to Qty, displays the quantity on the schedule available to be sourced to a purchase order.

Open Amt (open amount)

If the Distribute by option is set to Amt, displays the amount on the schedule available to be sourced to a purchase order.

Multi-SpeedCharts

Click to access the Multiple SpeedCharts page, where you can assign multiple SpeedCharts to a single requisition schedule.

See Also

Entering Distribution Information

Click to jump to top of pageClick to jump to parent topicEntering Multiple SpeedCharts on Requisitions

Access the Multiple SpeedCharts page.

Note. The field labels and values on this page adjust depending on the field value in the Distribute by field. If the field value is set to Quantity, fields reflect quantity-based values. If the field value is set to Amount, fields reflect amount-based values.

Distribute by

Displays according to the Distribute by option selected on the Distribution Information page.

Values are:

Quantity: If the requisition distribution is distributed by quantity and the distribution is associated with an inventory item with applicable rounding rules, the distributed quantity is rounded to whole numbers. The quantity in the last distribution line generated for the SpeedChart may be a decimal or a whole number. If the distribution is not associated with an inventory item with applicable rounding rules, the quantity may be distributed as decimals or whole numbers.

Amount: If the requisition distribution is distributed by amount, the amount may be distributed as decimals or whole numbers.

Req Qty (requisition quantity)

If the Distribute by option is set to Quantity, displays the requisition schedule quantity.

Amount

If the Distribute by option is set to Amount, displays the requisition schedule amount.

Remaining Amount

If the Distribute by option is set to Amount, displays the requisition schedule amount remaining to be distributed. This is the Amount value less the sum of distributed amounts on the Distribution Information page and Multiple SpeedCharts page.

SpeedChart

Enter a SpeedChart value. You cannot enter duplicate SpeedChart values on this page.

Quantity to Distribute

If the Distribute by option is set to Quantity, enter the quantity you want to distribute using the selected SpeedChart.

Amount to Distribute

If the Distribute by option is set to Amount, enter the amount you want to distribute using the selected SpeedChart.

You can have the system automatically calculate SpeedChart distribution quantities and amounts, manually enter values, or use a combination of these options.

If you do not specify an associated quantity or amount in the Quantity to Distribute or Amount to Distribute field, the system populates distributions with ChartField values based on the selected SpeedChart and sets the distribution quantities, amounts, and percentages on the Distribution Information page to zero. This enables you to manually enter the data.

If you enter an associated quantity or amount, the system populates distributions with ChartFields values based on the selected SpeedChart and automatically calculates and populates the distribution quantities, amounts, and percentages on the Distribution Information page.

When you enter a SpeedChart and an associated quantity or amount for distribution, the system validates the quantity or amount entered. You cannot select the Append process option and enter a quantity or amount that is greater than the original remaining quantity or amount for the schedule. You cannot select the Overwrite process option and enter a quantity or amount that is greater than the quantity or amount for the schedule.

SpeedChart Process Options

Append

Select to have the SpeedChart selections added to existing distributions. If selected, you can enter a total Quantity to Distribute or Amount to Distribute value up to the original remaining quantity or amount.

Overwrite

Select to have the SpeedChart selections overwrite existing distributions. If selected, you can enter a total Quantity to Distribute or Amount to Distribute value up to the requisition schedule quantity or amount.

Click to jump to top of pageClick to jump to parent topicUsing Multiple SpeedCharts with Purchase Orders

Access the Distribution page.

Multi-SpeedCharts

Click to access the Multiple SpeedCharts page, where you can assign multiple SpeedCharts to a single purchase order schedule.

See Also

Creating Purchase Order Distributions

Click to jump to top of pageClick to jump to parent topicEntering Multiple SpeedCharts on Purchase Orders

Access the Multiple SpeedCharts page.

Note. The field labels and values on this page adjust depending on the field value in the Distribute by field. If the field value is set to Quantity, fields reflect quantity-based values. If the field value is set to Amount, fields reflect amount-based values.

Click to jump to parent topicDefining Payment Terms

To define payment terms, use the following components:

This section provides on overview of payment terms and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Payment Terms

Payment terms are used to calculate net due date, discount due date, and discount amount calculations. You need to define the payment terms and timing methods that the system uses for vendor payments. The system supports percentage and fixed amount discount calculations. PeopleSoft Payables uses these payment terms and timing methods to schedule payments for invoices and to calculate amounts remitted to vendors.

You can establish separate payment terms for single and multiple payments. Before you can establish the actual payment terms, however, you must define a payment terms timing for each time frame that you reference in the payments. You do this on the Payment Terms Timing Codes page. Once you have established timing codes, you can set up payment terms for single payments. Timing codes are directly referenced in single payment terms and must be defined as a prerequisite to defining single payment terms. Single payment terms are directly referenced in multiple payment terms, and likewise must be defined first.

Click to jump to top of pageClick to jump to parent topicPages Used to Define Payment Terms

Page Name

Object Name

Navigation

Usage

Payment Terms Timing Codes

PYMT_TERMS_TIMING

Set Up Financials/Supply Chain, Product Related, Procurement Options, Payments, Payment Terms Timing Codes, Payment Terms Timing Codes

Define payment terms timing codes for each time frame that you reference in the payments. These codes define the number of days or months that must be added to the basis date to calculate the scheduled pay date.

Payment Terms Timing Codes - Search Where Used

TIMING_WHERE_USED

Click the Search Where Used link on the Payment Terms Timing Codes page.

View payment terms that use the timing ID.

Payment Terms Timing Codes - Calculate Example Due Dates

TIMING_CLC_DUE_DTS

Click the Calculate Example Due Dates link on the Payment Terms Timing Codes page.

Calculate the payment due date for the timing ID, based on the basis date that you enter.

Payment Terms - Single Payment

PYMT_TERMS_SINGLE

Set Up Financials/Supply Chain, Product Related, Procurement Options, Payments, Payment Terms - Single Payment, Payment Terms - Single Payment

Define valid payment terms for single payments. You enter payment terms using payment terms timing codes.

You must have already defined at least one payment terms timing ID on the Payment Terms Timing Codes page.

Payment Terms - Single Payment - Search Where Used

SNGL_TRMS_WHR_USED

Click the Search Where Used link on the Payment Terms - Single Payment page.

View the multipayment terms IDs that uses the selected single payment terms ID.

Payment Terms - Multi Payment

PYMT_TERMS_MULTI

Set Up Financials/Supply Chain, Product Related, Procurement Options, Payments, Payment Terms - Multi Payment, Payment Terms - Multi Payment

Define multipayment terms by grouping single payment terms for payments split into multiple payments or installments. You enter multiple payment terms using two or more single payment terms.

You must have already defined payment terms timing codes and single-payment terms.

Calculate Example Payment Data

MLT_TR_CLC_PAY_DTA

SNG_TR_CLC_PAY_DTA,

Click the Calculate Example Payment Data link on the Payment Terms - Single Payment page or the Payment Terms - Multi Payment page.

Calculate example payment data for the Payment Terms ID based on currency, gross amount or basis amount, and basis date.

This enables you to perform a what-if examination of the effect of various parameter settings on the calculated result, before you save a particular term's definition.

Examine Installment Detail

EXMN_INST_DETAIL

Click the Examine Installment Detail button on the Calculate Example Payment Data page that you access from the Payment Terms - Multi Payment page.

View single payment data for scheduled multipayment installments based on gross amount, discount, and basis date parameters.

Click to jump to top of pageClick to jump to parent topicDefining Payment Terms Timing Codes

Access the Payment Terms Timing Codes page.

Use the Timing Basis Option and Timing Adjustment group boxes to specify timing options. The Timing Basis Option group box enables you to select a basic calculation approach. The Timing Adjustment group box enables you to fine tune this approach by adding or subtracting a fixed number of days, months, or years.

PeopleSoft supports these timing methods:

Example of Using Timing IDs to Define Payment Terms

Suppose that you want to create timing IDs for the standard payment terms of 2 percent, 10 days, and net 30 days. First, establish a timing ID of 10 days, with a day increment of 10 days, and a timing ID of 30 days with a day increment of 30 days. Then, use these two timing IDs when defining the actual payment terms.

Or, suppose that you want to create a timing ID for payments due on the 15th day of the month. For this timing ID, select End of Relative Month as the timing basis option and set the counter to -1 to indicate the last day of the prior month as the start day to which the relative day value of 15 is added. This ensures that the resulting date falls within the current month. Then, enter 15 in the Day Increment field.

Click to jump to top of pageClick to jump to parent topicViewing Payment Terms by Timing Code

Access the Payment Terms Timing Codes - Search Where Used page.

Net Terms Occurrences

Displays the number of times that the timing ID is used within the net calculation of the payment terms ID. This value is greater than one if the terms are split and a timing ID is used more than once. This is more likely to occur in the discount calculation than in the net.

Discount Terms Occurrences

Displays the number of times that the timing ID is used within the discount calculation of the payment terms ID.

Click to jump to top of pageClick to jump to parent topicCalculating Example Payment Due Dates

Access the Payment Terms Timing Codes - Calculate Example Due Dates page.

Basis Date

Select the timing calculation basis date. The default value is the current date.

Click the Calculate Due Date button to calculate the due date. The system calculates the due date and populates the Due Date field.

Due Date

Displays the due date calculated based on the timing ID specified on the Payment Terms Timing Codes page and the basis date value.

Click to jump to top of pageClick to jump to parent topicDefining Single Payment Terms

Access the Payment Terms - Single Payment page.

Payment Terms Control

Terms Applicability

Describes the customers or vendors to which these payment terms apply.

Split Net Terms

Select to define payment terms that contain multiple net terms and any associated discounts. This allows for a variable due date depending on the invoice date.

For example, select this option to use one timing ID if the basis date is between the 1st and 15th, and another timing ID if the basis date is between the 16th and end of the month.

Split terms definitions enable you to set up variable net due date terms. There are terms that, depending on the basis date, result in more than one possible set of net or discount due dates.

Note. The split payment terms functionality cannot calculate staggered discount payments, which are graduated discounts that are based on a certain number of days past the invoice date (for example, a 2% discount when paid within seven days, then a 1% discount when paid within fourteen days, then zero discount when paid within thirty days).

Number of Terms

Indicates the number of terms that apply to this single payment term. This field is available when you select the Split Net Terms check box.

Net Due Terms

Basis From Day

Indicates the beginning day of the basis day range. The basis date's day value must be equal to or greater than this day, or the terms definition does not apply. This field is available when you select the Split Net Terms option.

Basis To Day

Indicates the ending day of the basis day range. The basis date's day value must be equal to or less than this day, or the terms definition does not apply. This field is available when you select the Split Net Terms option.

Note. All available days, 1 to 31, must be accounted for in the basis from day and basis to day range.

Timing ID

Displays the timing ID used to calculate the net payment due date for this day range within the single payment term.

Rebate Term Available

Select if the terms you are defining include rebate terms. Rebate terms are calculated as:

Days payment precedes due date * Daily rebate percentage, not to exceed a maximum percentage of the amount due.

There are special edits performed when you enter vouchers with rebate terms.

See Scheduling and Creating Voucher Payments for Online Vouchers.

Daily Rebate Percent

Enter the daily rebate percentage to be applied to the days the payment precedes the due date.

Maximum Rebate Percent

Enter the maximum percentage of the amount due that is available as a rebate.

Discount Terms Available

Select if the terms that you are defining include discount terms.

Discount Terms

Timing ID

Displays the timing ID used for the discount portion of this single payment term.

Adjustment Days

Displays the number of days used to adjust the discount due date for this single payment term. Use this field to define flexible discount terms by specifying either "basis date relative" or "due date relative" discount due dates. This is useful if the discount terms are often calculated as, for example, 2 percent for the first 10 days following the start-of-terms (basis) date, or 2 percent up to 10 days before the payment due date.

Discount Terms Percent

Displays the discount percent that is applied to the invoice gross amount to calculate the discount amount.

Note. The discount is less nonmerchandise charges, freight, miscellaneous charges, and sales tax. In a value-added tax (VAT) environment, you may configure the system to include VAT in the amount upon which the discount is calculated.

Discount Terms Amount

Displays the flat amount discount that is applied to the invoice. Entering a value in this field causes a constant amount to be used for the discount regardless of the invoice amount.

The discount terms amount value is applied using the transaction currency units defined for the voucher. The particular currency to use is not defined here, but is determined by context.

Click to jump to top of pageClick to jump to parent topicViewing Multipayment Terms That Use a Single Payment Term

Access the Payment Terms - Single Payment page - Search Where Used page.

Multi-Payment Terms ID

Displays the multipayment terms IDs that include the single payment terms you are searching on.

Number of Terms

Displays the number of installments contained within the multipayment terms ID.

Number of Occurrences

Displays the number of times that this payment terms ID is used within the multipayment terms.

Click to jump to top of pageClick to jump to parent topicDefining Multipayment Terms

Access the Payment Terms - Multi Payment page.

Payment Terms Control

Terms Applicability

Describes the entities to which these payment terms apply. For example, the value in this field can tell you if the terms apply to the vendor, the customer, or both.

Number of Installments

Displays the number of installments for the multipayment terms.

Installment Terms

Use the Installment Terms grid to determine the installment terms. The calculated due date for each installment becomes the basis date for the next sequential installment.

Single Terms ID (single payment terms ID)

Specify the single payment terms ID for each installment.

Installment Percent

Change the installment percentage.

The system initially calculates the installment percentage based on the number of installments that you specify. For example, if you set the number of installments to 2, the system inserts two rows in the installment terms grid and sets the installment percent for each row to 50.000. You may change this value.

Freeze Pct (freeze percent)

Select to freeze or set the installment percentage at the entered amount. Freezing the percentage prevents the system from trying to recalculate it.

The freeze percent settings are session-temporary only. They are not saved as part of the terms definition, but are only used during initial setup to help allocate the wanted percentage to each installment. For example, suppose that the display is initialized to two installments of 50 percent each.

To set up terms with three installments with a 40 percent/30 percent/30 percent split, entering 40 percent for the first installment automatically sets the Freeze Pct check box for it and results in 60 percent being allocated to the unfrozen second installment. From this point, you can increment the number of installments from two to three, and the unfrozen percentage is now split between the second and third installments.

Click to jump to top of pageClick to jump to parent topicCalculating Example Payment Data for a Payment Term

Access the Calculate Example Payment Data page.

Calculation Parameters

Currency

Select the transaction currency. The currency selected affects the rounding decimal units for the calculated discount amount.

Gross Invoice Amount

Displays the total payment amount to be scheduled for the voucher—for example, the gross amount owed to the vendor.

Terms Basis Amount

Enter the terms basis amount. If the payment terms include a provision for discounts, you can use this field to simulate a mix of discount-applicable and nondiscount voucher lines by entering the total applicable amount here. The default field value is equal to the gross invoice amount value, meaning that the default is 100 percent discount-applicable. Select the Use Basis Amount check box to make this field available for entry, and enter a different value.

Use Basis Amount

Select to make the Terms Basis Amount field available for entry, thus enabling you to override the default value.

Basis Date

Select the basis date. The system populates this field with the current date by default.

Click the Calculate Example Payment Data button to calculate the payment data based on the values entered on the page.

Calculation Results

When accessed from the Payment Terms - Single Payment page, this grid is labeled Calculation Results - Single Payment Alternatives. When accessed from the Payment Terms - Multi Payment page, this grid is labeled Calculation Results - Scheduled Installments. The grids display payment and due date information based on the values entered in the Calculation Parameters group box calculated against values entered on the originating Payment Terms page.

Net Due Date

Displays the net due date based on the basis date value and the terms defined on the originating Payment Terms - Single Payment page or Payment Terms - Multi Payment page. The calculated due date for each installment becomes the basis date for the next sequential installment.

Net Amount

Displays the net amount due based on the gross amount value calculated against any applicable discount terms entered on the originating Payment Terms - Single Payment page or Payment Terms - Multi Payment page.

Discount Due Date

Displays the due date for qualifying for a discount on the net amount based on the basis date and terms defined on the originating Payment Terms - Single Payment page or Payment Terms - Multi Payment page.

Discount Amount

Displays the amount of the discount based on the basis amount calculated against any applicable discount terms entered on the originating Payment Terms - Single Payment page or Payment Terms - Multi Payment page.

Click the Examine Installment Detail button to access the Examine Installment Detail page.

Click to jump to top of pageClick to jump to parent topicViewing Installment Details for a Multipayment Installment

Access the Examine Installment Detail page.

Calculation Parameters

This group box displays the parameters you defined on the Calculate Example Payment Data page.

Calculation Results - Single Payment Alternatives

The Calculation Results - Single Payment Alternatives group box displays payment and due date information based on the values in the Calculation Parameters group box calculated against values entered on the originating Payment Terms - Multi Payment page.

Net Due Date

Displays the net due date based on the basis date value and the terms defined on the originating Payment Terms - Multi Payment page.

Net Amount

Displays the net amount due based on the gross amount value calculated against any applicable discount terms entered on the originating Payment Terms - Multi Payment page.

Discount Due Date

Displays the due date for qualifying for a discount on the net amount based on the basis date and terms defined on the originating Payment Terms - Multi Payment page.

Discount Amount

Displays the amount of the discount based on the basis amount calculated against any applicable discount terms entered on the originating Payment Terms - Multi Payment page.

Installment Number

Displays the installment sequence assigned to this single payment.

Click to jump to parent topicEstablishing Additional Payment Processing Options

To establish additional payment processing options, use the following components:

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Establish Additional Payment Processing Options

Page Name

Object Name

Navigation

Usage

Payment Handling Codes

PYMNT_HNDL_CD_PNL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Payments, Payment Handling Codes, Payment Handling Codes

Enter codes that indicate how to handle individual payments. Payment handling codes help determine the order in which payments are generated—typically they are used to determine the order in which checks are printed. You must enter at least one code for the system to process payments.

Payment Message

PYMNT_MSG

Set Up Financials/Supply Chain, Product Related, Procurement Options, Payments, Payment Messages, Payment Message

Enter standard payment messages for printing on payment advices.

Click to jump to top of pageClick to jump to parent topicDefining Payment Handling Codes

Access the Payment Handling Codes page.

Payment handling codes work with sequence numbers to determine the order in which payments get generated (that is, typically, the order in which checks get printed) within a pay cycle. Payments with the same handling code get generated together. A higher handling code sequence number causes a payment to be generated last; for checks this means that payments with handling codes of a higher sequence number are printed last and end up on the top of the pile.

Payment Handling

Enter a payment handling code to indicate how you want to handle individual payments. PeopleSoft delivers the following codes, but you can add your own:

  • HD (high dollar payment): This code identifies high-amount payments that typically require special approval or signatures; by assigning them a high sequence number—the delivered sequence number is 99—high-amount checks will print last and therefore be on the top of the pile, where they can easily be extracted for approval and special signatures.

    Note. This code can apply to any currency, despite its name.

  • IN (internal distribution): This code identifies payments to be distributed within the organization by interoffice mail.

  • PO (route to purchasing): This code identifies payments to be routed to purchasing before being transmitted to vendors.

  • RE (regular payments):

The payment handling code defaults onto the payment from the voucher origin associated with the user or the vendor, but it can be overridden on the voucher. When you set up bank accounts, you can define a high dollar amount that, when reached, causes the payment handling code on a voucher automatically to switch toHD (high dollar payment).

Sequence Number

Determines the sort sequence of the payments generated.

Note. If you are entering multiple payment handling codes, keep a gap between the sequence numbers so that you can subsequently add additional codes between the existing ones.

Note. Typically, multiple scheduled payments to one vendor in a pay cycle are bundled into one payment. This is not the case when the scheduled payments have different payment handling codes. In the last instance, the system produces one payment for each handling code.

See Also

Payment Sorting

Click to jump to top of pageClick to jump to parent topicEstablishing Standard Payment Messages

Access the Payment Message page.

You can print the messages entered on this page on the payment advice by selecting them from the Payments page in the Voucher component (VCHR_EXPRESS).

Description

Enter a description for the payment message.

Payment Message

Enter the text of the payment message, up to 70 characters. You can have multiple messages for each message code.

See Also

Entering Payment Information for Vouchers

Click to jump to parent topicDefining Late Interest Charges

To define late interest charges, use the following components:

This section provides an overview of late interest charges and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Late Interest Charges

If you enable late interest charges on the Installation Options - Payables page, the system can automatically calculate interest charges for late payments to vendors. Once you have set up the late interest charges, you can define late charge options at the PeopleSoft Payables business unit, origin, vendor and voucher levels of the control hierarchy.

Late interest charge calculation is primarily a U.S. federal feature.

Note. Late charges are calculated during pay cycle processing. They are calculated on the voucher gross amount and, once calculated, converted from the invoice currency to the payment currency, if necessary.

See Also

Calculating Late Interest Charges

Click to jump to top of pageClick to jump to parent topicPages Used to Define Late Interest Charges

Page Name

Object Name

Navigation

Usage

Late Interest Charges

LATE_CHRG_TBL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Payments, Late Interest Charges, Late Interest Charges

Define late charge interest rates.

Late Charge ChartField Override

LATE_CHRG_CF

Set Up Financials/Supply Chain, Product Related, Procurement Options, Payments, Late Interest Chrg Chartfields, Late Charge ChartField Override

For a particular Fund Code, replace particular ChartField values for the late interest charge distributions defined on the Accounting Entry Template and by inheritance.

Payment Reason Codes

PYMNT_REASON_CD

Set Up Financials/Supply Chain, Product Related, Procurement Options, Payments, Payment Reason Codes, Payment Reason Codes

Assign reason codes to late payments to explain why the payments are late.

Late Charge Information

LATE_CHRG_SBP

Accounts Payable, Vouchers, Add/Update, Regular Entry, Payments

Click the Late Charge link on the Voucher - Payments page.

Override late interest charge information for a voucher.

Click to jump to top of pageClick to jump to parent topicDefining Late Interest Charges

Access the Late Interest Charges page.

Interest and Minimum Amount

Interest Rate

Enter the interest rate used to calculate late charges.

Minimum Pay Amount

Enter a threshold for the calculated late interest charge below which it will not be paid.

Penalty

Check to indicate that this is a late charge assessed directly by the vendor. Such charges are reported in Section E (Other Penalties) of the Prompt Payment Report (APS2001).

Interest Calculation Days

Days in Year

Enter the days in the year based on the business needs. Some organizations choose 365 but, for others, 360 is a better choice.

Simple Interest Days

Enter the days subject to simple interest. The system calculates compound interest on the number of days the payment is past due minus the number of simple interest days.

Max Pay Days (maximum pay days)

Enter the maximum number of days the system computes interest.

Click to jump to top of pageClick to jump to parent topicOverriding Late Charge ChartFields

Access the Late Charge ChartField Override page.

Late charges are charged to late charge accounting entries generated by the late charge distribution defined on the Accounting Entry Template and by inheritance. You can override these distributions with other ChartField values for a particular Fund Code.

For example, if the budget has expired, you could override late charge ChartFields to hit an active budget. In this case, if you override the ChartFields, you must enter a budget start date, budget end date, and account. The additional ChartFields are optional for override.

Click to jump to top of pageClick to jump to parent topicDefining Payment Reason Codes

Access the Payment Reason Codes page.

Definition Option

User Applied

Select to manually assign reason codes to individual payments at the voucher level.

System Applied

Select to automatically inserts reason codes at the business unit definition level.

Reason Code Type

Early and Late

Indicate whether this reason code applies to a payment that is early or one that is late.

Click to jump to parent topicDefining Credit Card Issuers

To define credit card vendors, use the ProCard Card Issuers component (CC_CARD_TBL).

This section discusses how to enter card issuer information.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Credit Card Issuers

Page Name

Object Name

Navigation

Usage

Card Issuer

CC_CARD_TBL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, ProCard Card Issuers, Card Issuer

Enter details about procurement/corporate card vendors and link the details to a vendor ID. The vendor ID controls the bank account and other important vendor attributes for that card provider.

You must have already set up the vendor ID for the card provider in the Vendor Information component.

VAT Defaults Setup

VAT_DEFAULTS_DTL

Click the VAT Default link on the Card Issuer page.

Define VAT defaults for the card provider.

Card Issuer - Setup Prepayment ChartFields

CC_CARD_TBL_CF

Click the Setup Prepayment ChartFields link on the Card Issuer page.

Define prepayment ChartFields.

Click to jump to top of pageClick to jump to parent topicEntering Card Issuer Information

Access the Card Issuer page.

Credit Card Provider Record

AP Business Unit (accounts payable business unit)

Select the PeopleSoft Payables business unit which the system will use to settle charges for this card provider.

Vendor ID

Select the vendor associated with this corporate card provider. This is the vendor that is used for payment and posting purposes.

Vendor Location

Select the vendor location for this card provider.

Corporate Number

Enter a corporate number if the business uses corporate numbers to reference credit card vendors. The system uses this optional field for reporting and informational purposes.

Load Level 3 Data

Select this check box to enable loading detailed transaction information from the card provider.

Bill Includes Tax (if applied)

Select if the transaction amount on the bank statement includes a tax amount (tax inclusive). Based on this setting, the system can accurately calculate the merchandise amount and the tax amount, if the proper tax code or tax percentage is provided (either by the bank statement or by the employee performing the statement reconciliation).

If a bank captures the transaction amount and tax amount separately, or supports, captures, and provides level two (item information, tax information) and level three information (account information, charge code), then clear the Bill Includes Tax (if applied) check box.

Corporate card providers can support multiple levels of data capturing. Some credit card providers can single out taxes on the statement, and others simply include the tax in the total amount.

Bill Includes VAT (if applied)

Select this check box if the transaction amount on the bank statement includes VAT.

VAT Default

Click this link to access the VAT Defaults Setup page. Use this page to define VAT defaults for the card provider.

Notify Pending Reconciliation

Enter the number of days after a billing cycle that users have to review and reconcile their statements before the system processes the Voucher Build Application Engine process (AP_VCHRBLD).

Expiration Grace Days

Enter a grace period which you want to prevent card usage before the cards stated expiration date.

Prepayment Voucher Default

Create Prepayment Voucher

Select this check box if you want to automatically stage a prepayment voucher when loading statements from this procurement card provider.

Prepayment Voucher Options

Select the prepayment voucher option. Values are:

  • Auto Apply: Select this option if we want to use the ChartFields from the accounting entry template for accounting for the prepayment asset, and you want all charges to this credit card vendor to draw down the prepayment balance.

  • Specify: Select this option if the prepayment will use the ChartFields entered on the Card Issuer - Setup Prepayment ChartFields page. The prepayment will be assigned a unique identifier that will enable only the transactions from the same statement to draw it down.

Payment Terms ID

Select the payment terms. The system will use this field to determine when based on the statement date the prepayment will be scheduled to pay.

Setup Prepayment ChartFields

Click this link to access the Card Issuer - Setup Prepayment ChartFields page. Use this page to define prepayment ChartFields. This link is only available if you select the prepayment voucher option of Specify.

See Also

Managing Procurement Cards

Working with VAT

Click to jump to parent topicDefining Vendor Freight Groups

To define vendor freight groups, use the Vendor Freight Group component (PO_VNDR_FRT_GRP).

This section discusses how to create vendor freight groups.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Vendor Freight Groups

Page Name

Object Name

Navigation

Usage

Vendor Freight Group

PO_VND_FRT_GRP

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, PO Vendor Freight Group, Vendor Freight Group

Create vendor freight groups by grouping vendor locations under a single freight group code.

Click to jump to top of pageClick to jump to parent topicCreating Vendor Freight Groups

Access the Vendor Freight Group page.

Vendor Freight Info

Arbitration Plan ID

Displays the arbitration plan ID, which determines how the system calculates transportation lead times and freight charges.

Global

Select to apply the arbitration plan to all the vendors. If you select this check box, you don't need to fill in the Vendor Freight Group scroll area fields. All of the vendors are subject to the arbitration plan that you select.

Click to jump to parent topicDefining Ship To Locations

To define ship to codes, use the Ship To Codes component (SHIP_TO_CODES).

This section discusses how to:

When you define the general options for the PeopleSoft system, you set up location definitions to store address information for the various locations of the organization. You can identify these locations as ship to locations, which are places where you receive goods from vendors.

You can assign ship to locations to PeopleSoft Purchasing requesters and buyers to create default shipping information for requisition and purchase order schedules. This default information passes through the system when you create transaction documents. For example, the system passes the requisition ship to location to the purchase order schedules when the requisition is sourced.

You can also update the PeopleSoft Purchasing user preferences to create default shipping information for requisitions and purchase orders.

In the PeopleSoft Purchasing system, the ship to location carries the sales and use tax (SUT) information, specifying how sales and use taxes are handled for items shipped to that location. Normally, the SUT is based on the ship to location or the ultimate use of the items. However, different geographic locations have different SUT regulations. For this reason, different locations and different items can be taxed at varying rates. PeopleSoft Purchasing enables you to indicate tax exception information for each ship to location. You can also specify various combinations of ultimate use, vendor location, item category, and item ID data that are either taxable or nontaxable. When you create a purchase order or voucher, the system uses the SUT default information to determine the appropriate tax rate. The system uses the data that most closely matches the purchase order schedule line or voucher line.

The ship to location also carries vendor order location information so that you can associate specific vendor locations with each ship to location. This enables you to order goods from the closest or preferred vendor location. For example, suppose that most of the offices are located on the East Coast of the U.S. You normally order from the vendor's New York location, but you also have one office on the West Coast. For this office, you might want to place the orders with the vendor's San Francisco location. To do this, specify a vendor order location for the San Francisco office.

Note. When you need purchased goods drop-shipped to a one-time use site that is not one of the existing locations, define a one-time ship to address on either the requisition or purchase order by using the One Time Address Default page (header-level) and the One Time Address page (schedule-level). Because you use this address only once, there is no need to create a new location or ship to location.

See Also

Entering Purchase Order Schedule One-time Address Information

Creating One-Time Requisition Default Addresses

Click to jump to top of pageClick to jump to parent topicPages Used to Define Ship To Locations

Page Name

Object Name

Navigation

Usage

Ship To Locations

SHIPTO_HDR

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Ship To Locations

Create ship to location IDs that designate existing location IDs as places where you receive goods from vendors. You must specify an existing location ID as the ship to ID.

Sales/Use Tax

SUT_DFLT_TBL

Click the Sales/Use Tax link on the Ship To Locations page.

Specify default sales and use tax information for each ship to location. The sales and use tax rates are normally based on the final destination of the shipment (the ship to location).

Indicate exceptions to the normal tax rate for each ship to location, and indicate whether the tax exception status is Active or Inactive.

ShipTo Vendor Order Location

SHIPTO_VNDR_LOC

Click the Vendor Order Location link on the Ship To Locations page.

Specify a vendor order location for a ship to location, and indicate the applicable sales and use tax for the vendor order location.

Click to jump to top of pageClick to jump to parent topicCreating Ship To Locations

Access the Ship To Locations page.

Ship To Details

Status

Specify a status for this ship to location. The status takes effect on the effective date. Values are: Active and Inactive.

Distribution Network SetID

Displays the distribution network setID for the ship to location. The distribution network setID identifies the entire distribution network.

Distribution Network Code

Displays the distribution network code for this ship to location. The distribution network code identifies a subset of the entire distribution network.

Inventory Unit

Displays the inventory business unit for this ship to location. The inventory business unit is where items shipped to the ship to location are actually stocked.

Receiving Business Unit

Displays the default receiving business unit for use by the Receive Load process (PO_RECVLOAD).

Region SetID and Region Code

Displays the region setID and region for this ship to location.

Send Expected Receipt

Select to send purchase orders that you expect to receive at the ship to location to the location by using XML.

Copy to Transactions

Select to copy delivery instructions text for this ship to location to the purchase order.

Send to Vendor

Select to send delivery instructions text for this ship to location to the vendor.

Click to jump to top of pageClick to jump to parent topicSpecifying Ship To Location Sales and Use Tax Defaults and Exceptions

Access the Sales/Use Tax page.

Tax Exception

Exception Type

Select an exception type. This field designates whether the ship to location is a tax exception. Options are:

Direct Pay: For this location, tax is paid directly to the tax agency rather than to the vendor.

Exempt: This location is not subject to sales or use tax.

None: This location does not have a tax exception.

Excptn End Date (exception end date)

Displays the exception end date. Required if the exception type is Direct Pay.

Sales/Use Tax Exception Certif (sales and use tax exception certificate)

Required if the exception type is Direct Pay. Applies to PeopleSoft, Taxware, and Vertex calculations.

Calculation Parameters

Calculation parameters are applicable only to Taxware and Vertex, providing these third-party tax applications with tax calculation rules for the ship to location. These applications use the GeoCode for the ship to location to apply these rules to the appropriate tax calculation algorithms. They may also use the GeoCode for the order acceptance location, ship from location, and (Taxware only), the place of order origin.

Include VAT

Indicates that the VAT amount must be taxed and added to the net-extended amount before calculating SUT. This field is information-only. Tax applicability of VAT amounts is determined as part of VAT setup.

See Working with VAT.

Include Freight

Indicates that the freight amount must be taxed and added to the net-extended amount before calculating SUT. This option is used for Taxware only.

Include Discount

Indicates that PeopleSoft calculates any applicable discount and passes the discount amount to Taxware or Vertex.

Include Misc Charges (include miscellaneous charges)

Indicates that any other charges must be taxed and added to the net-extended amount before calculating SUT.

Sales/Use Tax Info

When creating sales and use tax information in this section of the page, you must first create at least one row that will represent the default sales and use tax information for the ship to location. Each ship to location has to have either a row that is Taxable with no qualifiers (ultimate use code, category, item ID, vendor ID, and vendor location) or a row that is Exempt with no qualifiers. After you create the default sales and use tax information you can then create additional sales and use tax information with the specific qualifiers (ultimate use code, category, item ID, vendor ID, and vendor location). The system will use the default sales and use tax information if no specific sales and use tax information exists for a ultimate use code, category, item, vendor, or vendor location.

Use these fields to specify further tax information for the ship to location. The value in the Sales/Use Tax Applicability field must match the value in the Exception Type field as follows:

These rules apply to PeopleSoft, Taxware, and Vertex calculations. All values are copied to the payables voucher.

See Also

Integrating with Sales and Use Tax Applications

Setting Up Sales and Use Taxes and Value-Added Taxes (VAT)

Click to jump to top of pageClick to jump to parent topicSpecifying Ship To Location Vendor Order Locations

Access the ShipTo Vendor Order Location page.

Vendor Order Location

Vendor SetID

Displays the vendor setID. This field value determines the values available for the vendor ID.

Apply to All Vendors

Select to indicate that the SUT Flag option applies to all vendors.

Vendor ID

Displays the vendor ID. Only values for the selected vendor setID are available. This field determines the values available for the order vendor location.

Order Vendor Loc (order vendor location)

Displays the vendor order location that you want to associate with the ship to location. The vendor location that you select here is the primary attribute used for calculating item pricing.

SUT Flag (sales and use tax flag)

Designate the SUT applicability for the ship to vendor order location. Values are: None, Sales, and Use.

Click to jump to parent topicDefining Origin Codes

To define origin codes, use the Origin Codes component (PO_ORIGIN_CODES).

This section discusses how to define origin codes.

Origin codes identify places in the system from which transactions originate. For example, you can define origin codes to indicate online entry, fax, or email. You can also use these codes to identify departments or groups within the organization. Origin codes enable you to group the transactions, and they provide an additional level from which information can appear by default in transactions.

PeopleSoft Purchasing and PeopleSoft Payables share the same procurement origin code table. This enables the PeopleSoft Payables Voucher Build process to build vouchers from PeopleSoft Purchasing receipts, non-purchase order receipts, purchase orders, and contracts, regardless of the origin code default values. Because these two applications share origin codes, PeopleSoft Payables is able to recognize default origin codes regardless of where they are set.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Origin Codes

Page Name

Object Name

Navigation

Usage

Origin Codes

ORIGIN_PO

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, PO Origin Codes, Origin Codes

Create a code that identifies the originator of a transaction in the system.

Click to jump to parent topicPreparing to Dispatch by Fax and Email

To define fax cover letter, fax location, file location options, and purchasing dispatch configurations, use the Fax Cover (FAX_COVER), Fax Location (FAX_LOCATION), File Location (FILE_LOC), and Purchasing Dispatch Configuration (PO_DISP_CON) components.

The PeopleSoft Purchasing dispatch mechanism and setup procedures are universal to purchase orders, contracts, requests for quotations (RFQs), and RTVs. Dispatching these transactions by fax and email requires the additional setup steps discussed here. Dispatching by print, phone, and electronic data exchanges (EDX) does not require additional setup.

To set up the system to dispatch transactions by fax or email:

  1. Access the File Locations page to set up valid file extensions and directory locations.

  2. Access the Fax Location page to define the file extension to be used to create the fax control file.

  3. Access the Dispatch Configuration page to specify the file extensions and, consequently, the output directories to be used for fax and email dispatch processes.

  4. Access the Purchase Order Images page to set up the system to print a logo or signature on the purchase orders.

  5. Access the Fax Cover Letters page to select the fax cover letters in the system to use when dispatching by fax.

Tips for Dispatching and Printing Transactions

The following may be setup issues:

Click to jump to top of pageClick to jump to parent topicPages Used to Prepare to Dispatch by Fax and Email

Page Name

Object Name

Navigation

Usage

File Locations

FILE_DIR_FS

Set Up Financials/Supply Chain, Common Definitions, File Locations and Images, File Locations

Define file locations by specifying the file extensions that you want the system to recognize.

As part of defining file extensions, you can specify the file directory locations that the system searches to find attachments for the purchase orders, contracts, and so on.

You can also specify file extensions that designate the email output, fax output, and fax control files. As part of defining these file extensions, you can define the file server directories where various dispatch processes create output files.

Depending on the context of use, these file extensions are not necessarily conventional file extensions such as .DOC and .BMP, but can be any 3-character code that you use to recognize a file type.

Fax Location

FAX_LOCATION

Set Up Financials/Supply Chain, Common Definitions, Location, Fax Location

Set up fax locations by defining business-unit-level information that enables dispatch processes to construct appropriate dispatch fax numbers. The information defined on this page also enables dispatch processes to assign proper extensions to the fax control files that they produce.

Dispatch Configuration

PO_DISP_DEST

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Dispatch PO Configuration, Dispatch Configuration

Define dispatch configurations by entering information that enables the system to identify how to handle output files when you dispatch by either email or fax.

Purchase Order Images

BUS_UNIT_PM_IMAGE

Click the Define Images link on the Purchasing Definition - Business Unit Definition page.

Define a file directory location for an image that you want to print on the purchase orders.

Fax Cover Letters

PO_FAX_COVER_LTRS

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Fax Cover Letters

Define fax cover letters by selecting the fax cover letters in the system to use when dispatching by fax.

Click to jump to top of pageClick to jump to parent topicDefining File Locations

Access the File Locations page.

Throughout PeopleSoft applications, you can append various documents and other items—such as Microsoft Excel spreadsheets, ASCII files, or blueprints—as attachments. You can also route output from certain background processes, such as dispatching purchase orders, to a vendor using email, fax, or EDX. Please note that an external file—for example, a Microsoft Word document—that is attached to a purchase order is not included in the output file when that purchase order is dispatched or printed.

To use attachments, you must define the default locations, or file directories, for the documents that you use within the PeopleSoft system. You must also specify a server's location to route process output to the correct server.

You must set up a file location for each type of file that resides on a particular server. By categorizing file types and storing them in the same file directory, the system can easily locate the different types of files used as multimedia attachments or for server processing.

The file extensions that you define here are used for retrieving file directory information for the defined file types. This information is not used by PeopleSoft Purchasing dispatch processes to determine the file extensions of the output files that they create.

The actual extensions of the output files created by the dispatch processes are based on the output format that you specify for the dispatch on the Process Scheduler Request page. For example, if you select an output format of HP, LP, PS, or OTHER, the system creates the output file with a .LIS file extension.

File Ext (file extension)

Specify the file extension for each type of attachment. Depending on the context of use, these file extensions are not necessarily conventional file extensions such as .DOC and .BMP, but can be any 3-character code that you use to recognize a file type. For example, enter DOC for Microsoft Word document files and BMP to designate bitmap files. You can also enter FAX to designate fax output files or CTL to designate fax control files. This value serves as the primary key.

The actual file extensions for output files for faxes and emails are ultimately determined by the format that you select for the dispatch on the Process Scheduler Request page.

File Directory

Enter the location path to be used by PeopleSoft Purchasing online page PeopleCode to determine where to retrieve file attachments. This is the directory where the file attachments for purchase orders, contracts, and so on are stored.

Use this syntax to define the file directories: http://host_name/folder_name/. Be sure to include the last slash (/). The actual file directory that http://host_name is translated into is determined by the web server that you install along with its configuration.

For example, for a Microsoft IIS web server, http://host_name is translated into C:\Inetpub\wwwroot\ by default.

For an Apache web server, the translation of http://host_name is determined by the content of the httpd.conf file. If there is no Alias directive specified in this file, then the entry for DocumentRoot is used, which is normally C:\Program Files\Apache Group\Apache\htdocs\. If there is an Alias directive specified, then the translation is based on the entry for the corresponding Alias entry. For example, with Alias /image/ftp/pub/image, a request for http://host_name/image/pslogo.gif causes the server to return the file /ftp/pub/image/pslogo.gif.

The folders specified as file locations need to be designated as shared folders in order for them to be accessible to users over a browser.

For network (LAN) file directories, directory formats include:

  • file:\\psh-storwks-01\SRMsupport\customers\

  • file:\\\psh-storwks-01\SRMsupport\customers\

  • file://c:/user/attachments

  • file:///c:/user/attachments

File Directory - Server

Enter a location path to a file server directory where you want dispatch processes to save the output files that they create. This is the file server directory where the POPO005.SQR (PO Dispatch), POCNT100.SQR (Contract Dispatch), PORFQ01.SQR (RFQ Dispatch), and PORT001.SQR (RTV Dispatch) SQR dispatch programs create output files. The value in this field is used primarily by PeopleSoft Purchasing dispatch processes.

Use this syntax to define these file server directories for the Microsoft Windows environment: \\server_name\folder_name\. Be sure to include the last slash (\).

If the PeopleSoft Process Scheduler server and output directory are on the same computer, use this syntax to define the file server directories: c:\folder_name\. Be sure to include the last slash (\).

The folders specified as file locations need to be designated as shared folders in order for them to be accessible to users by browser.

The fax control file is always written to the same file location as the fax output file. Although you can specify a different file location for the fax control file, it will be ignored. You can specify the file extension for the fax control file on the Fax Location page.

See Also

Enterprise PeopleTools 8.48 PeopleBook: PeopleSoft Process Scheduler

Click to jump to top of pageClick to jump to parent topicSetting Up Fax Locations

Access the Fax Location page.

You can fax documents directly from within PeopleSoft applications. You can also route output from certain background processes, such as dispatching purchase orders, to a vendor by way of fax.

To fax documents, you must define the business-unit-level information that enables dispatch processes to construct appropriate dispatch fax numbers, and assign proper extensions to the fax control files that they produce.

When you send a fax to a vendor, the system compares the location information with the vendor's telephone information, to determine which parts of the fax number to ignore and which additional numbers to dial. You enter vendor fax information on the Phone Information page in the Vendor Information component.

Control File Extension

Designate the file extension to be used for the fax control files. The directory for the fax control file is based on the directory defined for the fax output file. The fax control file is always created in the same file directory in which the fax output file is created. The output directory for the fax file is defined on the Dispatch Configuration page.

A fax control file contains the information necessary to send a fax, such as which files to send, dialing instructions, and telephone numbers to dial. The file extension that you enter must have first been defined on the File Locations page.

Click to jump to top of pageClick to jump to parent topicDefining Dispatch Configurations

Access the Dispatch Configuration page.

With PeopleSoft Purchasing, you can phone in the purchase orders or other transactions, you can print and mail them to the vendors, or you can use email or fax to dispatch them. If you are dispatching by email or fax, you need to set up one dispatch configuration for each of the setIDs.

This dispatch configuration specifies the file extensions to be used to derive the file directory locations to use for the creation of email and fax output files. The system matches the output file extensions that you define on this page with the File Directory - Server field values that you defined on the File Locations page, to determine which file directory to use.

For faxing, you also need to designate the fax server and extension that identifies the fax cover letter.

Email File Extension

Select the 3-character code that identifies the email output files. This code is used to derive the file directory location to be used when creating the email output file. These file directory locations are defined on the File Locations page.

When processing for email, the dispatch programs use the value entered here (combined with the selected setID) to search the PS_FILE_DIR_FS table for the FILE_DIR_SERVER field to determine the directory in which to create the output file.

The actual file extension of the output file is determined by the output format selected on the Process Scheduler Request page. For example, if the selected output format is PDF, then the file extension assigned is .PDF. If the selected output format is HP, then the file extension assigned is .LIS.

FAX Server Setup

Use the FAX Server Setup group box to define the setup information for dispatching by using a fax server.

Fax Sender

Enter the fax server name. This value appears in the From field in the fax control file.

File Extension

Select the 3-character code that identifies the fax output files. This code is used to derive the file directory location to be used when creating the fax output file. These file directory locations are defined on the File Locations page.

When processing for fax, the dispatch programs use the value entered here (combined with the selected setID) to search the PS_FILE_DIR_FS table for the FILE_DIR_SERVER field, to determine the directory in which to create the output file.

The actual file extension of the output file is determined by the output format selected on the Process Scheduler Request page. For example, if the selected output format is PDF, then the file extension assigned is .PDF. If the selected output format is HP, then the file extension assigned is .LIS.

Cover Letter File Extension

Enter the extension that identifies the fax cover letter files. The dispatch programs join the cover letter file name that you specify on the applicable run control page with the selected cover letter file extension. The dispatch program then writes the combined information to the fax control file. Determining the value to enter in this field, as well as which cover letter file name to use, is mainly determined by the fax software that you use.

For example, with some fax software packages, you cannot use just any document as a cover letter, but rather the software provides you with tools to create a set serialized cover letter managed by that software. In this case, you can use the serial number as the cover letter file name and leave the cover letter file extension blank.

Fax Location

Enter the business unit where the fax server is set up. Fax locations are defined on the Fax Location page.

See Also

Enterprise PeopleTools 8.48 PeopleBook: PeopleSoft Process Scheduler

Click to jump to top of pageClick to jump to parent topicDefining Fax Cover Letters

Access the Fax Cover Letters page.

If you create fax cover letters in the system, you can identify them with file names and descriptions. When you dispatch purchasing transactions by fax, you can specify the fax cover letter that you want to use by selecting one of the short descriptions defined on this page.

List of Fax Cover Letters

Use the List of Fax Cover Letters group box to identify the fax cover letters in the system that users can select from when dispatching purchasing transactions by fax.

Short Desc (short description) and Description

Enter short and long descriptions of the fax cover letter. Users can search by the short description and use the long description to verify that they have located the cover letter that they want to use.

File Name

Enter a distinct file name for the fax cover letter files that the business uses. Do not include the file extension in the file name. You can create as many cover letter files as you want.

The dispatch programs join the cover letter file name that you specify on the applicable run control page with the selected cover letter file extension. The dispatch program then writes the combined information to the fax control file. The value to enter in this field, as well as what cover letter file extension to use, is mainly determined by the fax software that you use.

For example, with some fax software packages, you are unable to use just any document as a cover letter, but rather the software provides you with tools to create a set serialized cover letter managed by that software. In this case, you can use the serial number as the cover letter file name and leave the cover letter file extension blank.

Click to jump to parent topicDefining Inspection Procedures

To define inspection routings, use the Inspection Routing component (ROUTINGS).

Inspection routings are sets of inspection instructions for receiving users. You can assign inspection routings to specific items in the Item table. Receiving users see the inspection instructions when they receive those items. For example, if you often purchase an item made to precise specifications, inspection routings enable you to define procedures for verifying the acceptability of received quantities of that item.

You identify each routing with an inspection ID and define any number of instructions for it. For each instruction, you can also create any number of effective-dated inspection instructions.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Inspection Procedures

Page Name

Object Name

Navigation

Usage

Inspection Routing

ROUTING

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Inspection Routings, Inspection Routing

Specify procedures for receiving users to inspect items in the item table for acceptability.

Click to jump to top of pageClick to jump to parent topicSpecifying Inspection Procedures

Access the Inspection Routing page.

Batch Sequence

Batch Sequence

Designate the order in which inspection instructions should be performed. The system automatically increments the sequence numbers in the order that they are entered. You can override this sequence by entering a new number for any instruction and saving the changes. The system reorders the inspection instructions in sequential order the next time that you access the page.

Inspection Status

Run Time

Indicate the estimated time required for the inspection operation.

Operation Time Type

Specify the inspection quantity on which the runtime value is based. Values are:

Per Unit: Indicates that the inspection operation runtime is based on inspection of a single item.

Per Batch: Indicates that the inspection operation runtime is based on inspection of a batch of items, such as a representative sample from an entire shipment.

See Also

Inspecting Received Items

Click to jump to parent topicDefining Manufacturer IDs

To define manufacturers, use the Manufacturer component (MANUFACTURER).

This section discusses how to create manufacturer IDs.

PeopleSoft Purchasing can link items to multiple manufacturers by using the manufacturer ID and the manufacturer's item ID.

This optional feature is useful for items that you purchase that are produced by more than one manufacturer. If you choose to establish manufacturer IDs, you can assign them to items so that they appear as default values on purchasing transactions. Alternatively, you have to manually specify the manufacturer on the purchasing transaction.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Manufacturer IDs

Page Name

Object Name

Navigation

Usage

Manufacturer

MANUFACTURER

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Manufacturer

Create manufacturer IDs for the manufacturers of items that you purchase.

Click to jump to top of pageClick to jump to parent topicCreating Manufacturer IDs

Access the Manufacturer page.

Default UPN Type Code

Assign a default UPN type code. A manufacturer may use more than one type of UPN. Typical practice is for a manufacturer to use one type of UPN most of the time.

See Also

Using Universal Item Identifiers

Click to jump to parent topicEstablishing Model Relationships to Manufacturers

This section lists the page used to establish model relationships to manufacturers.

See Also

Defining Manufacturer IDs

Click to jump to top of pageClick to jump to parent topicPage Used to Establish Model Relationships to Manufacturers

Page Name

Object Name

Navigation

Usage

Manufacturer Model Relation

MFG_MODEL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Manufacturer Model Relation

Establish the relationship of models to manufacturers.

Click to jump to parent topicSetting Up Standard Comments

To set up standard comments and standard comment types, use the Standard Comments (STANDARD_COMMENTS) and Standard Comment Type (STD_COMMENT_TYPE) components.

This section discusses how to set up the standard comments.

You can record frequently made comments as standard comments, which you can conveniently add to purchasing transactions. To set up standard comments:

  1. Define comment type codes to identify the types of comments.

  2. Define standard comments for each comment type.

For example, you can define a standard comment type of SHP for specific shipping instructions, and then enter each of the standard shipping comments under that comment type. On the Purchase Order Comments page, you only need to enter SHP in the Std Comment Type (standard comment type) field, and then select the appropriate comment ID from the list of standard shipping comments.

You can use this feature to set up the organization's terms and conditions as a standard comment, so that they are available for selection on the Purchasing Definition - Business Unit Definition page. This terms and conditions comment can be printed upon dispatching the purchase order, when you select the Print BU Comments check box on the Dispatch Purchase Orders page.

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up Standard Comments

Page Name

Object Name

Navigation

Usage

Std Comm Type (standard comment type)

STD_COMM_TYPE_PO

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Standard Comment Type, Std Comm Type

Define standard comment types to use for organizing and searching for the standard comments that you attach to purchasing transactions.

Standard Comments

STD_COMMENTS_PO

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Standard Comments

Define frequently used comments.

You must have already defined standard comment types on the Std Comm Type page.

See Also

Using Standard Comments

Entering Purchase Order Header Comments

Receiving Shipments

Using Standard Comments

Click to jump to parent topicDefining Account Receivables Integration Options for Vendor Rebates

To define account receivables integration options for vendor rebates, use the Receivables Integration component (VRBT_AR_BU_OPTIONS).

This section discusses how to define account receivables integration options for vendor rebates.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Account Receivables Integration Options for Vendor Rebates

Page Name

Object Name

Navigation

Usage

AR Integration (account receivables integration)

VRBT_AR_BU_OPTIONS

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Receivables Integration, AR Integration

Define PeopleSoft Receivables integration options for the PeopleSoft Purchasing vendor rebate functionality. PeopleSoft Purchasing vendor rebate claims management functionality creates pending items for expected payment for a vendor rebate claim and sends those pending items to PeopleSoft Receivables. In addition, PeopleSoft Receivables sends payments received against those vendor rebate claims back to PeopleSoft Purchasing. These options assist in that integration processing.

Click to jump to top of pageClick to jump to parent topicDefining Account Receivables Integration Options for Vendor Rebates

Access the AR Integration page.

Before you access this page you must specify the claim type you are defining account receivables integration options for. You will want to select a Claim Type of Vendor Rebate if you are defining options for use with PeopleSoft Purchasing vendor rebates and Claimbacks if you are defining options for use with PeopleSoft Order Management claimbacks.

Group Type

Select the receivables group type. This group is a postable entity, a collection of pending items that are ready to post in PeopleSoft Receivables.

Origin ID

Select the receivables origin ID. The system uses the origin IDs to classify groups of pending items based on how they are created or brought into the system.

Credit Entry Type

Select the receivables credit entry type for check, direct debit, draft or EFT settlement method. An entry type categorizes the pending items and the system uses them to create or update items.

Debit Entry Type

Select the receivables debit entry type.

Credit Memo CR Entry Type (credit memo credit entry type)

Select the credit entry type for the credit memo settlement method.

Credit Memo Base Amt Reason (credit memo base amount reason)

Select the credit memo base amount entry reason code used by the system to identify the base amount for the credit memo settlement method.

Cash Base Amount Reason

Select the cash base amount reason code used by the system to identify the base amount for the check, direct debit, draft or EFT settlement method.

Credit Memo Vat Amount Reason (credit memo value added tax amount reason)

Select the credit memo VAT amount entry reason code used by the system to identify the VAT amount for the credit memo settlement method.

Cash VAT Amount Reason (cash value added tax amount reason)

Select the cash VAT amount reason code used by the system to identify the VAT amount for the check, direct debit, draft, or EFT settlement method.

VAT Transaction Type (value added tax transaction type)

Select the VAT Transaction Type used by the system when creating pending items if the PeopleSoft Receivables business unit is VAT enabled. The VAT Transaction Type should corresponds to a VAT Out of Scope value.

Note. VAT will be accounted for in PeopleSoft Payables. VAT fields are displayed if VAT is applicable for the business unit.

See Also

Setting Up Group Types and Group Origins

Setting Up Entry Types and Reasons

Click to jump to parent topicCreating Requisition Change Order Templates

To define the requisition change order template, use the Requisition Change Order Template component (CHNG_ORD_TMPLT_REQ).

You use the Requisition Change Order template to define which fields trigger a change order through the online requisition pages. The Change Order template is a system-delivered template.

Manage the Change Order template by defining which fields you allow to be changed for each record. The requisition uses all fields on the Change Order template to trigger a change order.

Click to jump to top of pageClick to jump to parent topicPage Used to Create Requisition Change Order Templates

Page Name

Object Name

Navigation

Usage

Req Chng Ord Template (requisition change order template)

CHNG_ORD_TMPLT_REQ

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Req Change Order Template, Req Chng Ord Template

Define requisition change order templates by adding or deleting fields on the requisition change order template.

Click to jump to top of pageClick to jump to parent topicDefining Requisition Change Order Templates

Access the Req Chng Ord Template page.

Record

Use the Record group box to define the change order template. The fields are part of the record.

Fields

Select a record name, and then use the group box to define or update the fields for the record. The record corresponds to the area of the requisition that, if changed, generates a change order. Options include:

REQ_HDR (requisition header): Select to work with the fields on the requisition header record.

REQ_LINE (requisition line item): Select to work with the fields on the requisition line item record.

REQ_LINE_SHIP (requisition line shipping schedule): Select to work with the fields on the requisition line shipping schedule.

Fields

Use the Fields group box to define the specific fields on the change order template. If any of these fields are changed on a requisition, the system generates a change order.

Field Name

Enter or update a field name, which indicates the field on the designated record that, if changed, prompts the system to generate a change order.

Label Type

Enter a field label type, which the system uses to determine how to display this field on the Change Ord Rqsts page.

To include a field on the change order template that appears only on a view, you must add that field to the page and render it visible, for it to be a selectable field on the template.

The text that appears when you view Get Label Text is what you see as the field name in the change history inquiry.

See Also

Creating Requisitions Online

Creating Purchase Orders Online

Click to jump to parent topicCreating Purchase Order Change Order Templates

To define purchase order change order templates, use the Purchase Order Change Order Template component (CHNG_ORD_TEMPLATE).

This section discusses how to define purchase order change order templates.

If you change a purchase order after you have dispatched it to a vendor, you need to send the vendor a change order. Because you don't send every field on a purchase order to the vendor, the only fields that are part of the change order are the ones that are on the dispatched purchase order. For example, if you change a quantity on a purchase order line, the vendor needs to be notified because the quantity is part of the dispatched purchase order. On the other hand, if you change a distribution account code, you do not need to notify the vendor because account codes are never dispatched to the vendor.

Use these change order templates to specify definitions of a change order. Specify which changed fields cause the system to generate and transmit a change order to the vendors.

PeopleSoft ships a predefined change order template with the system. You can use this template, modify it, or create your own.

You must have corresponding change order records for each type of purchase order record that you want to transmit. For example, there must be a header change record if you want to change the purchase order header, and there must be a line change record if you want to change the purchase order lines. PeopleSoft Purchasing provides change order records for headers, lines, and shipping records. These change order records correspond to the different records used by the purchase order dispatch process.

See Also

Dispatching and Printing Purchase Orders

Creating Purchase Orders Online

Click to jump to top of pageClick to jump to parent topicPage Used to Create Purchase Order Change Order Templates

Page Name

Object Name

Navigation

Usage

PO Chng Ord Template (purchase order change order template)

CHNG_ORD_TEMPLATE

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, PO Change Order Template, PO Chng Ord Template

Create and define templates that specify which purchase order fields, when changed after dispatch, cause the system to generate a change order.

Click to jump to top of pageClick to jump to parent topicDefining Purchase Order Change Order Templates

Access the PO Chng Ord Template page.

Record

Record

Select a record type, and then use the Fields group box to define the change order fields in the record type. The record type corresponds to the area of the purchase order that, if changed, generates a change order. Values are:

PO_HDR (purchase order header): Select to work with the fields on the purchase order header record.

PO_LINE (purchase order line item): Select to work with the fields on the purchase order line item record.

PO_LINE_SHIP (purchase order line shipping schedule): Select to work with the fields on the purchase order schedule.

Fields

Field Name

Indicates the field on the designated record that, if changed through online entry or a batch process, prompts the system to generate a change order.

Label Type

Select a label type. The system uses the label type to determine how this field appears on the Change Ord Rqsts page. Values include:

Custom: Indicates a field label that you specify. When you select Custom, an edit box appears. Enter the custom label for the field. This label appears on the Change Order Requests page.

Page: Indicates a field label taken from another page. When you select Page, the Page Name field becomes available for entry. Enter the page object name from which you want to take the field label. The label for the field name, as it is defined on the page that you entered, appears on the Change Order Requests page.

For example, if you select the BILL_LOCATION field and then select the Page Name value PO_HDR, the label that appears on the Change Order Request page is the BILL_LOCATION label from the purchase order header page.

Rec Long (record long): Indicates a field label taken from the long version of record field text defined for the field. This label appears on the Change Order Requests page.

Rec Short (record short): Indicates a field label taken from the short version of the record field text that is defined for the field. This label appears on the Change Order Requests page.

Get Label Text

Click to view field name labels for Page, Rec Long, and Rec Short label types.

Click to jump to parent topicCreating Change Map Templates

To define change map templates, use the Change Map Template component (CHNG_MAP_TEMPLATE).

This section discusses how to create change map templates.

When you dispatch a purchase order to a vendor, the vendor acknowledges receipt of that purchase order. Sometimes the acknowledgement includes information that requires you to change the purchase order; for example, the vendor may not have the wanted quantity of an item or may not be able to deliver the items at the purchase order price. If you are using EDX with the vendors, these acknowledgements may arrive electronically directly into the PeopleSoft Purchasing system.

When vendor acknowledgements arrive in the system by using EDX, you can run a multiprocess job (XML Inbound process) that enables you to extract purchase order data from vendor acknowledgements and stages it into the following temporary tables for different parts of purchase order transactions:

The Change Load process loads data from the previous EC tables. Based on the change map template, the process compares staged source record fields and field values (PO_HDR_EC, PO_LINE_EC, PO_LINE_SHIP_EC) with target system record fields and field values (PO_HDR, PO_LINE, PO_LINE_SHIP). If a difference exists, the Change Load process creates change requests (CHNG_RSQT, CHNG_RQST_DTL).

Based on the Change Order template, the Change Purchase Order process (PO_POCHNG) creates the necessary change orders from these change requests. The Change Purchase Order process takes the change order information and creates change history records (PO_CHNG_HDR, PO_CHNG_LINE, PO_CHNG_SHIP), and then updates target system records with the changes.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Change Map Templates

Page Name

Object Name

Navigation

Usage

Change Map Template

CHNG_MAP_TEMPLATE

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Change Request Mapping, Change Map Template

Create templates that are used to compare staged purchase order acknowledgement record fields and field values with target purchase order system record fields and field values. If a difference exists, change request records are created by the Change Load process.

Click to jump to top of pageClick to jump to parent topicCreating Change Map Templates

Access the Change Map Template page.

Source

Identifies the change request source for the template.

Record

Target Recname (target record group name)

Displays the target record group name. The target record is the system record that is updated with data from the source record. Individual target system record fields are updated with data from individual source record fields.

Fields

Source Recname (source record table name)

Enter the source record name. Values include:

PO_HDR_EC: EDX record for purchase order header data.

PO_LINE_EC: EDX record for purchase order line data.

PO_LINE_SHIP_EC: EDX record for purchase order schedule data.

Source Transaction Fieldname

Displays the source field name. This is an individual field in the source record that contains data to be transferred to a target system record.

Target Fieldname

Displays the target system field name. This is an individual field in the target system record to which the source data is transferred.

Click to jump to parent topicDefining Buyers

To define buyers, use the Buyer Setup component (BUYER_TBL).

This section discusses how to establish buyers and defaults.

The values that you enter for the buyer on this page appear by default on the purchasing transactions created by this buyer. If you do not define values for fields on this page, you need to manually enter this information when you create purchasing transactions.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Buyers

Page Name

Object Name

Navigation

Usage

Buyer Setup

BUYER_TBL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Buyer Setup

Establish users as buyers and define sets of purchase order defaults for each buyer.

Dashboard

PO_SPEND_BUYER

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Buyer Setup, Dashboard

Define what time frame the buyer wishes to view for the spend analysis graphs on the SRM Dashboard.

See Using the Supplier Relationship Management (SRM) Dashboard.

Click to jump to top of pageClick to jump to parent topicEstablishing Buyers and Defaults

Access the Buyer Setup page.

Buyer

Displays the user description that you entered on the User Profiles - ID page when you created the buyer's user ID. You can set up only established users as buyers.

Status

Select the status of the buyer. Values include Active and Inactive. If you select Inactive, the Substitute Buyer field becomes available for entry.

The Department SetID, ShipTo SetID, Location SetID, and PO Origin SetID fields work together when you establish department, ship to, location, and origin default information for buyers. After you select a setID for each of the defaults, the system enables you to select only the defaults associated with that setID.

Department

Select the default department for the buyer. The system uses this value as the department on all purchasing transaction distribution lines created by the buyer.

Ship To

Select the default ship to location for the buyer. The system uses this value as the ship to on all purchase order schedule lines created by the buyer.

Location

Select the default location for the buyer. The system uses this value as the location on all purchase order distribution lines created by the buyer. This is the internal final destination of the item once the vendor has delivered it to the organization.

Origin

Select the default origin for the buyer. The system uses this value as the origin on all purchase order headers created by a specified buyer.

Substitute Buyer

Displays the substitute buyer. This field becomes available for entry when the Status field is set to Inactive. For example, use this field when a buyer leaves the organization and you want to remove the buyer's name from the system, but don't want to manually change the buyer name in each of the control tables.

Supplying the substitute buyer name automatically changes references to the inactive buyer name to the new substitute buyer name. Before you save, the system prompts you to be sure that you want to change the buyer in these tables: PS_ITM_CAT_TBL, PS_ITM_CAT_BU, PS_PURCH_ITEM_ATTR, PS_PURCH_ITEM_BU, and PS_VENDOR_LOC.

Default PO Status

Open

Indicates that purchase orders that the buyer creates are initially set to Open status and must be approved by an authorized user. Approval rules set at the business unit level determine whether the status of the purchase order changes to Approved or Pending Approval.

Pending Approval/Approved

Indicates that purchaser orders that the buyer creates are set to Pending Approval or Approved status, depending on the approval rules set at the business unit level.

Override Procurement Card

This group only appears if the buyer can use a procurement card. Otherwise, this group box will be hidden.

Card Number

The procurement card number appears that you selected as the buyer default on either the Assign Proxies page under the Security menu or the Assign Proxies page under the Cardholder Profile - Card Data page. You can change the procurement card number to another procurement card number. Only the procurement cards that are valid for this buyer are available for selection.

Card Type

Displays the card type associated with the procurement card.

Expiration Date

Displays the expiration date for this procurement card.

Use Procurement Card as default payment method on Purchase Orders

Select this check box if you want to use the procurement card you select on this page as the default payment method when creating a purchase order.

Reporting Entity

Select the reporting entity to which this buyer will be assigned. The reporting entity determines which Purchasing Business Unit's purchase orders will be included in the spend analysis graphs. Additionally, the reporting entity specifies a calendar so that delivery schedules can be bucketed into the appropriate periods.

Prior Periods

Specify the number of periods prior to the current period that should appear on the spend analysis graphs

Future Periods

Specify the number of periods after the current period that should appear on the spend analysis graphs

See Also

Enterprise PeopleTools 8.48 PeopleBook: Security Administration

Establishing Procurement Card Security

Defining Cardholder Profile

Click to jump to parent topicDefining Buyer Manager Setup

To define buyer manager setup, use the Buyer Manager Setup component (PO_MANAGER_TBL).

This section discusses how to define buyer manager setup.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Buyer Manager Setup

Page Name

Object Name

Navigation

Usage

Define Buyers for a Manager

PO_MANAGER_TBL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Buyer Manager Setup, Define Buyers for a Manager

Define buyers that report to a manager for use by the manager spend analysis pagelets in the SRM dashboard. When the manager specified here logs in and views the manager pagelets, the data presented will be comprised of the purchase orders on which these buyers are specified.

See Maintaining Buyers for a Manager.

Click to jump to parent topicDefining Requesters

To define requesters, use the Requester Setup component (REQUESTOR_TBL). Use the REQUESTOR_TBL_CI component interface to load data into the tables for these components.

This section discusses how to establish requesters and defaults.

You can define default information for requesters and assign any number of item catalogs, including a default catalog, to each requester. This streamlines requisition data entry for each requester, because default information appears on requisitions automatically. You can then authorize established purchasing users to enter and process requisitions for all or specific requesters.

When you stage requisition data from any third-party application, you must set up requesters in the PeopleSoft system and in the third-party application for the enterprise integration point (EIP) to work as designed.

Click to jump to top of pageClick to jump to parent topicPages Used to Define Requesters

Page Name

Object Name

Navigation

Usage

Requester Setup

REQUESTOR_TBL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Requester Setup

Establish default information for requesters.

Click to jump to top of pageClick to jump to parent topicEstablishing Requesters and Defaults

Access the Requester Setup page.

Requester

Displays the name of the requester as well as the user description that you entered on the User Profile - ID page when you created the requester's user ID. Only established users can be set up as requesters.

Requisition Default Values

The ShipTo SetID, Location SetID, and PO Origin SetID, fields work together when you establish ship to, location, and origin default information for requesters. After you select a setID for each of the defaults, the system enables you to select only the defaults associated with that setID.

Ship To

Select the default ship to location for the requester. The system uses this value as the ship to location on all requisition schedule lines created by the requester.

Location

Select the default location for the requester. The system uses this value as the location on all requisition distribution lines created by the requester. This is the internal final destination of the item once the vendor has delivered it to the organization.

Origin

Select the default origin for the requester. The system uses this value as the origin on all requisition header lines created by the requester.

Currency

Displays the default currency associated with the requester.

Use Only Assigned Catalogs

Select to enable requesters to access only the catalogs relevant to their needs. Use the Catalog Information scroll area to define which catalogs are available to the requester.

Keep these guidelines in mind if the requesters are restricted to using certain catalogs:

  • On the Maintain Requisitions - Form page, only those item IDs and categories associated with the requester's assigned catalogs are valid.

  • On the Order By Catalog page, Category Search page, and Catalog Hierarchy page, only those catalogs assigned to the requester are available.

  • On the Item Search Criteria page, only those item IDs and categories associated with the requester's assigned catalogs are valid.

    In addition, the Search button retrieves only those items associated with the requester's assigned catalogs.

Consolidate with other Reqs (consolidate with other requisitions)

Select if you want requisitions created by the requester to be consolidated during the PO Calculations process (PO_POCALC). The process uses this setting to determine whether the schedule can be consolidated with items from other requisitions.

Price Can Be Changed on Order

Select to enable a buyer to change item prices requested by the requester. If you do not select this check box, you cannot alter item prices on requisitions.

Defaults Inventory BU (defaults inventory business unit)

Select to specify the default inventory business unit to be associated with the item in the requisition distribution. If you do not select this check box, the inventory business unit does not appear by default in the requisition distribution.

Department

Select the default department for the requester. The system uses this value as the department on all requisition distribution lines created by the requester.

Requisition Status

Open

Select to indicate that a requisition created by the requester remains in open status when saved. A requisition is not eligible to enter the approval process until an authorized user changes its status to Pending Approval.

Pending

Select to indicate that a requisition created by the requester is assigned a pending approval status and is eligible to enter the approval process when saved.

Override Procurement Card

This group only appears if the requester can use a procurement card. Otherwise, this group box will be hidden.

Card Number

The procurement card number appears that you selected as the requester default on either the Assign Proxies page under the Security menu or the Assign Proxies page under the Cardholder Profile - Card Data page. You can change the procurement card number to another procurement card number. Only the procurement cards that are valid for this requester are available for selection.

Card Type

Displays the card type associated with the procurement card.

Expiration Date

Displays the expiration date for this procurement card.

Use Procurement Card as default payment method on Requisitions

Select this check box if you want to use the procurement card you select on this page as the default payment method when creating a requisition.

Catalog Information

Default

Select to designate a default catalog for a requester. Optionally, you can assign any number of catalogs and designate one of them as the requester's default catalog.

When you select this option, the default catalog automatically populates the catalog on the Order by Catalog, Category Search, and View Hierarchy pages.

See Also

Viewing Catalog Category Hierarchies

Entering Requisition Header Information

Ordering Items by Catalog

Searching for Item Categories

Establishing Procurement Card Security

Defining Cardholder Profile

Click to jump to parent topicUsing Requisition Loader Defaults and Overrides

To define requisition loader default options, use the Requisition Loader Default component (REQ_LOADER_DFL).

This section discusses how to:

The Purchasing Requisition Loader Application Engine process (PO_REQLOAD) loads requisitions from various sources, such as other PeopleSoft applications or external sources in PeopleSoft Purchasing. Use the Requisition Loader Defaults - Req Loader Defaults page and Requisition Loader Defaults - Overrides and Options page to define default and overriding values for requisitions that the Purchasing Requisition Loader process loads from these sources.

When these requisitions arrive in PeopleSoft Purchasing, especially in the case of non-PeopleSoft sources, some of the requisition information might be missing. Entering values on the Requisition Loader Defaults - Req Loader Defaults page enables you to set default values that populate the appropriate fields on loaded requisitions. The values that you enter on the Requisition Loader Defaults - Req Loader Default page are used as defaults when the values are not already provided in the system.

In addition, some requisitions might enter PeopleSoft Purchasing with values that you want to change. Entering values on the Requisition Loader Defaults - Overrides and Options page enables you to override or replace existing values on loaded requisitions with values that you specify. You can also select options that affect the statuses of the requisitions and how the PeopleSoft Purchasing Requisition Loader process builds them.

See Also

Using the Requisition Loader

Click to jump to top of pageClick to jump to parent topicPages Used to Use Requisition Loader Defaults and Overrides

Page Name

Object Name

Navigation

Usage

Requisition Loader Defaults - Req Loader Defaults (requisition loader defaults - requisition loader defaults)

REQ_LOADER_DFL2

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Requisition Loader Defaults, Req Loader Defaults

Define default values for the Purchasing Requisition Loader process. When the process runs, the default values populate appropriate requisition fields for which there are no existing values in the system.

Asset Information

REQ_DFL_ASSET

Click the Asset Information link on the Requisition Loader Defaults - Req Loader Defaults page.

Enter asset information to appear by default in appropriate loaded transactions.

Note. The Asset Information link is not available for a PeopleSoft Maintenance Management (WM) system source.

Requisition Loader Defaults - Overrides and Options

REQ_LOADER_DFL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Requisition Loader Defaults, Overrides and Options

Define override options for the Purchasing Requisition Loader process. When the process runs, the override values replace the appropriate existing requisition values.

Click to jump to top of pageClick to jump to parent topicDefining Requisition Loader Defaults

Access the Requisition Loader Defaults - Req Loader Defaults page.

System Source and Requesting Loader Bus Unit (requesting loader business unit)

The system source and requesting loader business unit you entered to access the page appear.

Requisition Loader Defaults

Business Unit

Select the default PeopleSoft Purchasing business unit that will appear on the requisitions. If you want to use multiple business units for the same system source, you must set up a separate Requesting Loader Bus Unit (requesting loader business unit) for each business unit you want to use.

The GL Unit field that displays on this page is the one that is associated with the PeopleSoft Purchasing business unit that you select. The GL Unit field is not available for modification.

Requester

Select the name of the requester that will appear on the requisitions.

Origin

Select the origin default value that will appear on the requisitions.

Ship To

Select the default ship to business unit that will appear on the requisitions. The system will populate this field with the default value assigned to the requester if it isn't specified.

Price Can Be Changed on Order

Select this check box to enable the prices for items to be changed on the requisitions.

GL Unit(PeopleSoft General Ledger business unit)

The PeopleSoft General Ledger business unit appears by default from the PeopleSoft Purchasing business unit that you selected in the Business Unit field. This PeopleSoft General Ledger business unit will appear on the distribution information for the requisitions.

ChartFields

Select the different ChartFields that will appear as defaults on the requisitions.

Asset Information

Click this link to access the Asset Information page where you can enter asset information for the item.

Note. This link is not available for a PeopleSoft Maintenance Management (WM) system source.

Click to jump to top of pageClick to jump to parent topicDefining Requisition Loader Overrides and Options

Access the Requisition Loader Defaults - Overrides and Options page.

Requisition Loader Overrides

Use the Requisition Loader Overrides group box to set values that override the existing values on requisitions built by the PeopleSoft Purchasing Requisition Loader process.

Entry Event

Select a value to override any default entry event codes entered at the business unit level or on the Requisition Loader page. Entry events codes are used to generate supplemental accounting entries.

Enable Tolerances

Select this check box if you want to apply tolerances to the requisitions built by the Requisition Loader process.

% Unit Price Tolerance Over (percent unit price tolerance over)

Enter the base price tolerance on a percentage over of the suggested requisition price.

% Unit Price Tolerance - Under (percent unit price tolerance under)

Enter the base price tolerance on a percentage under of the suggested requisition price.

Requisition Loader Options

Consolidate with other Reqs

Select this check box to consolidate the loaded requisitions during the PO Calculations process (PO_POCALC). The process uses this setting to determine if the schedule can be consolidated with items from other requisitions.

Auto Load Indicator

Select this check box to indicate that you want requests from the selected loader business unit to be eligible for processing by the Purchasing Requisition Loader process.

This check box setting defines which business units and requests are available for processing in conjunction with the All Business Units and Range of Business Units run types on the Requisition Loader page.

If you do not select this check box, requests from this requesting loader business unit are not loaded.

Inventory Source Flag

Select this check box to indicate that you want any eligible requisition items sourced from PeopleSoft Inventory. Ineligible items include ad hoc items, non-inventory items, and open description items. This check box is unavailable for the requisition system sources for PeopleSoft Order Management (direct shipments).

ChartField Status

ChartField Status

Select the status to be used on requisitions. Values are:

  • By Combo Edits (by combination edits): When you run the Purchasing Requisition Loader process, these requisitions will be checked for valid ChartField combinations. If a requisition line has invalid ChartField combinations, the system will log an error message in the error log records defined in the POREQBATCH ChartField combination editing template.

    The system uses the POREQBATCH ChartField combination editing template when it performs the combination edits. This option appears only if Combo Editing is enabled for the business unit.

  • Recycled: Select to give all requisition ChartFields a status of Recycled. When you save the requisition or run the PO Calculations process (PO_POCALC), these requisitions will be checked for valid ChartField combinations. If a requisition line has invalid ChartField combinations, the system will generate an exception.

  • Valid: Select to give all requisition ChartFields a status of Valid. When you save the requisition or run the PO Calculations process (PO_POCALC), these ChartFields will pass through the system as valid. No combination edit errors will occur.

Requisition Status

Use the Requisition Status group box to transfer a status to the corresponding fields on the requisition.

Open

Select this option to give all requisitions a status of Open when they are loaded.

Pending

Select this option to give all requisitions a status of Pending when they are loaded.

Approved

Select this option to give all requisitions a status of Approved when they are loaded.

See Also

Using Entry Events

Establishing Purchasing Options

Understanding ChartField Combination Editing

Click to jump to parent topicUsing Purchase Order Loader Defaults and Overrides

To define Purchase Order Loader default options, use the Purchase Order Loader Defaults component (PO_LOADER_DFL).

This section discusses how to:

The PO Stage Load process (PO_POSTAGE) loads staging tables with entries from PeopleSoft Supply Planning and PeopleSoft Manufacturing for later purchase order creation. PeopleSoft Supply Planning and PeopleSoft Manufacturing do not have all the information required to create a purchase order. The PO Stage Load process also loads staging tables with entries from purchase order change order requests. Use this component to identify new lines and schedule defaults.

The PO Loader Defaults page enables you to set default values to populate fields on purchase orders loaded by the PO Stage Load process. If information is missing, the default values populate the appropriate ChartFields.

Some purchase orders might enter the purchasing application with values that you want to change. The PO Loader Defaults - Overrides and Options page enables you to override values on loaded purchase orders with the values that you specify. No matter what the ChartField value from the source is, the override value replaces it. You can also select options on this page that affect the status of the purchase orders and how the PO Calculations process (PO_POCALC) builds them.

PeopleSoft Maintenance Management can directly create purchase order staging data for the PO Calculations process to pick up and process. Use the system source Maintenance Management (WM), to define the business unit relationships. PO Loader defaults provide the mapping of a PeopleSoft Maintenance Management Business Unit to a PeopleSoft Purchasing Business Unit. PeopleSoft Maintenance Management does not use the overrides and defaults when creating the purchase order staging data.

PeopleSoft Order Management can directly create a purchase order from the Create/Update Order component. Use the system source OM Online Entry Panel (POM), to define the business unit relationships. PeopleSoft Order Management does not use the overrides and defaults when creating the purchase order.

Note. If you are loading staging tables from change requests, select PPO as the system source when you first enter the PO Loader Defaults component.

See Also

Using Purchase Order Sourcing

Click to jump to top of pageClick to jump to parent topicPages Used to Use Purchase Order Loader Defaults and Overrides

Page Name

Object Name

Navigation

Usage

PO Loader Defaults (purchase order loader defaults)

PO_LOADER_DFL2

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, PO Loader Defaults

Set default values for the PO Stage Load process. Default values populate empty purchase order fields when the process runs.

Asset Information

PO_DFL_ASSET

Click the Asset Information link on the PO Loader Defaults page.

Enter asset information to appear by default in appropriate loaded transactions.

Note. The Asset Information link is not available for a Maintenance Management (WM) system source.

PO Loader Defaults - Overrides and Options

PO_LOADER_DFL1

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, PO Loader Defaults, Overrides and Options

Define override options for the PO Stage Load process. These values replace existing purchase order field values when the process runs.

Click to jump to top of pageClick to jump to parent topicDefining Purchase Order Loader Defaults

Access the PO Loader Defaults page.

System Source and Loader Bus Unit (loader business unit)

The system source and loader business unit you entered to access the page appear.

PO Loader Defaults

Business Unit

Select the default PeopleSoft Purchasing business unit that will appear on the purchase orders. If you want to use multiple business units for the same system source, you must set up a separate Loader Bus Unit ( loader business unit) for each business unit you want to use.

The GL Unit field that displays on this page is the one that is associated with the PeopleSoft Purchasing business unit that you select. The GL Unit field is not available for modification.

Requester

Select the name of the requester that will appear on the purchase orders.

Origin

Select the origin default value that will appear on the purchase orders.

Ship To

Select the default ship to business unit that will appear on the purchase orders. The system will populate this field with the default value assigned to the requester if it isn't specified.

Price Can Be Changed on Order

Select this check box to enable the prices for items to be changed on the purchase orders.

GL Unit(PeopleSoft General Ledger business unit)

The PeopleSoft General Ledger business unit appears by default from the PeopleSoft Purchasing business unit that you selected in the Business Unit field. This PeopleSoft General Ledger business unit will appear on the distribution information for the purchase orders.

ChartFields

Select the different ChartFields that will appear as defaults on the purchase orders.

Asset Information

Click this link to access the Asset Information page where you can enter asset information for the item.

Note. This link is not available for a PeopleSoft Maintenance Management (WM) system source.

Click to jump to top of pageClick to jump to parent topicEntering Default Asset Information

Access the Asset Information page.

Note. This page is not available for a Maintenance Management (WM) system source.

When you consider the item on a distribution line to be an asset and plan to pass it on to the PeopleSoft Asset Management system through receiving, you must populate both the Business Unit (PeopleSoft Asset Management business unit) and Profile ID fields. When both fields contain values, the receiving business process treats the item as an asset and writes data to the PeopleSoft Asset Management staging tables. All fields entered here are passed to the PeopleSoft Asset Management system.

Business Unit

Select a PeopleSoft Asset Management business unit.

Cost Type

Select the cost type that is incurred with the purchase of the item. Values are: C (cost), G (grant reimbursements), M (margin), R (revaluation), P (scrap on asset), and S (sales of assets).

Capitalize

Select this check box if the cost of this item is capitalized. You must enter an asset management business unit to select this check box.

Click to jump to top of pageClick to jump to parent topicDefining Purchase Order Loader Overrides and Options

Access the PO Loader Defaults - Overrides and Options page.

PO Loader Overrides

Use the PO Loader Overrides group box to set values that override the existing values provided by PeopleSoft Supply Planning, PeopleSoft Manufacturing, as well as values that are introduced to the system using purchase order change order process. These values are later staged by the PO Stage Load process (PO_POSTAGE).

Note. PeopleSoft Maintenance Management does use these overrides and options when creating purchase order staging data.

Enable Tolerances

Select this check box to enable tolerances.

Buyer

Select a buyer who overrides the buyer associated with an item. When the purchase order is created, the override buyer appears in the corresponding field, instead of the buyer associated with the item.

% Price Tolerance Over (percent price tolerance over)

Enter the base price tolerance on a percentage over of the suggested purchase order price.

% Price Tolerance - Under (percent price tolerance under)

Enter the base price tolerance on a percentage under of the suggested purchase order price.

ChartField Status

ChartField Status

Select the ChartField status. Statuses are: Valid or Recycled.

Click to jump to parent topicDefining Contract Control Parameters

To define contract controls, use the Contract Control component (CNTRCT_CONTROL)

This section discusses how to set contract controls.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Contract Controls

Page Name

Object Name

Navigation

Usage

Set Controls - Contracts

CNTRCT_CONTROL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Set Controls-Contracts, Set Controls - Contracts

Set up the system to automatically assign ID numbers to each new contract and to define contract currency defaults.

Click to jump to top of pageClick to jump to parent topicSetting Contract Controls

Access the Set Controls - Contracts page.

Contract

Use Autonumbering

Select to have the system automatically assign sequential contract ID numbers. If you do not set up autonumbering, you are required to manually specify a unique ID whenever you create a new contract.

Last Contract ID

Displays the last contract number issued by the system.

Default Currency

Currency Code

Select the default currency code for contracts. The currency that you select is the default base currency for all contracts.

Rate Type

Enter a conversion rate type, which determines how the base currency is converted to other currencies.

Master Contract

Use Autonumbering

Select to have the system automatically assign sequential master contract ID numbers. If you do not set up autonumbering, you are required to manually specify a unique ID whenever you create a new master contract.

Last Master Contract ID

Displays the last master contract number issued by the system.

Vendor Rebates

Last Rebate ID

Displays the last rebate agreement number issued by the system.

Last Claim ID

Displays the last vendor rebate claim number issued by the system.

Amount Tolerance Over and Amount Tolerance Under

Enter the rebate agreement settlement tolerance amounts. These values will appear as defaults when defining a rebate agreement using the Rebate Agreement - Rebate Options page.

Percentage Tolerance Over and Percentage Tolerance Under

Enter the rebate agreement settlement tolerance percentages. These values will appear as defaults when defining a rebate agreement using the Rebate Agreement - Rebate Options page.

Click to jump to parent topicSetting Up Tax Vendor Product Codes Cross Reference

To set up the tax vendor product codes cross reference, use the SUT Tax Vendor Product Xref component (SUT_PRODUCT_XREF).

This section discusses the page used to set up tax vendor product codes cross reference.

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up Tax Vendor Product Codes Cross Reference

Page Name

Object Name

Navigation

Usage

Tax Vendor Product Codes Cross Reference

SUT_PRODUCT_XREF

Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Tax Vendor Product Code Xref, Tax Vendor Product Codes Cross Reference

Establish the tax vendor product codes cross reference for Taxware and Vertex third-party tax applications.

Click to jump to parent topicDefining Vendor Control Parameters

To set vendor control parameters, use the Set Controls - Vendor component (VENDOR_CONTROL).

This section discusses how to set vendor control parameters.

Each set of vendors that you define can be used for one or more PeopleSoft Payables business units, depending on the TableSet sharing setup. The parameters that you set at this level travel through the control hierarchy onto vouchers for any vendor belonging to this setID.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Vendor Control Parameters

Page Name

Object Name

Navigation

Usage

Vendor Set Control

VNDR_CNTRL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vendors, Set Controls-Vendor

Set vendor control parameters, including autonumbering, withholding, duplicate vendor checking, VAT applicability, and financial sanctions options for vendors belonging to the selected setID.

Click to jump to top of pageClick to jump to parent topicSetting Vendor Control Parameters

Access the Vendor Set Control page.

Autonumbering

Use Autonumbering

Select to autonumber vendor IDs when you enter vendors for the selected setID. When you save a new vendor, the system automatically assigns the next vendor ID based on the last vendor ID assigned in either the PeopleSoft Payables or PeopleSoft Purchasing system. When you use autonumbering, the system enters Next in the search record Vendor ID field when you add a new vendor.

Vendor Information Control

Display Withholding Option

Select 1099, Global, or Global and 1099. This determines how the withholding link on the Vendor Information - Location page is labelled.

Display VAT Flag (display value-added tax flag)

Designate whether to enable VAT for vendors in this setID.

Country

Select a default country for the vendors in this setID.

EFT/ACH Prenote Confirmation

Wait Days

Enter the number of days that the system waits to confirm a vendor prenote transaction after you send one to the bank for approval. A prenote transaction is a test transaction that enables a bank to verify that the routing information (transit number and bank account number) for an electronic funds transfer (EFT) or automated clearinghouse (ACH) payment is valid. Typically, the bank notifies you within a certain number of days only if something is wrong with the prenote transaction. Set the number of wait days to be close to this time span.

Duplicate Vendor Checking - Field Options

PeopleSoft Payables enables you to check for duplicate vendors in real-time, when users are entering new vendors in the Vendor Information component (VNDR_ID). Duplicate vendor checking options are set up by setID with the criteria specified here.

For each field option, select Do Not Check, Reject, or Warning. Duplicate vendor checking follows the following logic:

ID Type

To check for a duplicate identifier, select the identifier type, such as D&B Num (Dun & Bradstreet number).

VAT Registration (value-added tax registration)

Select to check for duplicate VAT registration IDs.

Vendor Name

Select to check for duplicate vendor names. Vendor names must match exactly to come up as duplicates.

Vendor Short Name

Select to check for duplicate vendor short names. Short names must match exactly to come up as duplicates.

(USA) Vendor Withholding TIN

Select to check for duplicate withholding tax identification numbers.

Withholding Name

Select to check for duplicate withholding names. Withholding names must match exactly to come up as duplicates.

Duplicate Vendor Checking - Processing Options

Inactive Vendors

Select one of these values:

Do Not Include: Excludes all inactive vendors when checking for an existing entry.

Include/Reject: Includes inactive vendors and then rejects the entry.

Include/Warning: Includes inactive vendors and then warns that there is a duplicate vendor.

Vendor CI Load(Vendor component interface load)

Select one of these values:

Check for Adds: Checks for new vendors loaded through the Vendor EIP.

Check for Adds and Changes: Checks for adds and changes loaded through the Vendor EIP.

Check for Changes: Checks for changes loaded through the Vendor EIP.

Do Not Check: Excludes vendors loaded through the Vendor EIP.

Check for Duplicates at Save

Select to check for duplicate vendors automatically when you save a vendor in the Vendor Information component. If you do not select this option, you can still check for duplicates by using the Check for Duplicates button on the Identifying Information page in the Vendor Information component.

Financial Sanctions Options

The Financial Sanctions Options group box is visible only if you have enabled financial sanctions at the installation level or the bank level for PeopleSoft Payables and PeopleSoft eSettlements on the Financial Sanctions Options page of the Installation Options component (INSTALLATION).

PeopleSoft provides validation of your vendors against financial sanctions lists (for example, the Specially Designated Nationals (SDN) list). The system updates the vendor's financial sanctions status on the Vendor Information component.

See Understanding Financial Sanctions Validation.

Inactive Vendors

Select Exclude or Include to exclude or include inactive vendors during the PeopleSoft Payables Financial Sanction Validation Application Engine process (AP_SDN_VAL).

Vendor CI Load

Select an option to validate or not validate vendors loaded through the Vendor EIP. This field functions for financial sanctions validation similarly to the field used in duplicate vendor checking.

Check for Adds: Checks for new vendors loaded through the Vendor EIP.

Check for Adds and Changes: Checks for adds and changes loaded through the Vendor EIP.

Check for Changes: Checks for changes loaded through the Vendor EIP.

Do Not Check: Excludes vendors loaded through the Vendor EIP.

SDN Validation at save

Select to validate vendors upon saving the Vendor Information component. If you do not select this option, you can still validate the vendor by using the Financial Sanctions edit button on the Identifying Information page in the Vendor Information component.

Note. This check box is not available if you have enabled financial sanctions at the bank level. You must run the PeopleSoft Payables Financial Sanction Validation process if you want to validate at the vendor level when you have enabled financial sanctions at the bank level.

See Also

Entering Electronic File Options

Duplicate Vendor Checking

Inactivating Vendors

Importing Vendors Using the Vendor EIP

Click to jump to parent topicDefining Vendor Pay Group Codes

To define vendor pay group codes, use the Vendor Pay Group Codes component (PAY_GROUP_CD).

In this section, we discuss how to create vendor pay group codes.

You can assign each vendor in the system to a vendor pay group. Pay groups are optional selection criteria for pay cycles. When you set up the pay cycle selection criteria, you can elect to use vendor pay groups. You can then select payment group codes to include in the pay cycle, and the system creates payments to all vendors assigned to those groups.

See Also

Specifying Pay Group and Netting Criteria

Click to jump to top of pageClick to jump to parent topicPage Used to Define Vendor Pay Group Codes

Page Name

Object Name

Navigation

Usage

Vendor Pay Group

VNDR_PAY_GROUP_CD

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vendors, Vendor Pay Group Codes

Set up pay groups for vendors.

Click to jump to parent topicDefining Vendor Conversation Keywords

To define vendor conversation keywords, use the Conversation Keywords component (KEYWORD_PNL).

In this section, we discuss how to define conversation keywords.

You can define keywords to categorize conversations that you have with vendors. Keywords might include price disputes, lead time inquiries, and so on. Conversation keywords enable you to record and track conversations that you have with the vendors.

The system uses the keywords to search the vendor conversation records when you try to resolve a particular problem. For example, on the Conversations page, you can record the key elements of a conversation regarding a price dispute. You could select the keywords Price and Dispute to use as search data. Later, you can search for all instances of those keywords to recall the record of the specific conversation.

See Also

Tracking Vendor Conversations

Click to jump to top of pageClick to jump to parent topicPage Used to Define Vendor Conversation Keywords

Page Name

Object Name

Navigation

Usage

Conversation Keywords

KEYWORD_VNDR

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vendors, Conversation Keywords

Define keywords to categorize conversations that you have with vendors. This page is optional.

Click to jump to parent topic(USA) Entering Vendor Government Certifications

To enter vendor government certifications, use the Government Certifications component (GOV_CERTIFICATION).

In the U.S., various government sources provide vendors with classification certifications. For example, a vendor might be classified as Small Business - Hispanic Woman Owned.

Organizations must report information about the classification of vendors with whom they do business, and are sometimes also required to report similar information to their customers.

For example, ABC Organization reports vendor classification information to the Departments of Labor and Commerce and also reports similar information to the Edsel Motor Company, one of its major customers. It is necessary for ABC Organization to generate appropriate reporting to remain compliant with government customers. In addition, the automotive industry expects ABC Organization to have a reporting system that identifies various spending activities by different ethnic group categories.

To enter government certifications, you define the sources of government certifications and then define the government certification classifications. Once you define the sources and classifications, apply this information to the vendors in the Vendor Information component.

See Also

Entering Identifying Information

Click to jump to top of pageClick to jump to parent topicPages Used to Enter Vendor Government Certifications

Page Name

Object Name

Navigation

Usage

Government Certifications - Sources

GOV_CERTSRC_TBL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vendors, Government Certifications, Sources

Define U.S. government sources from which you receive classifications of certification of vendors.

Government Certifications - Classifications

GOV_CLASS_TBL

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vendors, Government Certifications, Classifications

Define types of classifications of certification from U.S. government sources.

Click to jump to parent topicEstablishing Matching and Document Association Options

Matching is a flexible process that compares vouchers with purchase orders and receiving documents to ensure that you are paying for what you ordered and received. To run matching, you must have PeopleSoft Payables and PeopleSoft Purchasing installed on the same database.

To set up matching, use the following components:

This section discusses how to:

  1. View and update match rule types.

  2. View and update match rule definitions.

  3. View and update match rule workbench properties.

  4. View and update match rule workflow parameters.

  5. View and update match rule controls.

  6. View and update the document association group.

  7. View and update document association rules.

See Also

Managing Matches and Match Exceptions

Click to jump to top of pageClick to jump to parent topicPages Used to Establish Matching and Document Association Options

Page Name

Object Name

Navigation

Usage

Match Rule Type

AP_MTCH_RULE_TYPE

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vouchers, Match Rule Type, Match Rule Type

View and create match rule types. Match rule types are matching categories, such as data entry, informational, merchandise quantity, merchandise unit price, merchandise amount, and system. All match rules are associated with a match rule type.

Rule Definition

AP_MTCH_RULES

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vouchers, Match Rules, Rule Definition

View, clone, create and update match rules. Match rules control the way that the Matching Application Engine process (AP_MATCH) compares the voucher, purchase order, receiver, and inspection information.

Match Rules - Workbench

AP_MTCH_RULES2

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vouchers, Match Rules, Workbench

Select the label and fields to display on the Match Workbench.

Match Rules - Workflow

AP_MTCH_RULES3

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vouchers, Match Rules, Workflow

Override the worklist and email notification parameters and user lists defined at the match rule type level.

Match Rule Control

AP_MTCH_CNTRL_HDR

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vouchers, Match Rule Control, Match Rule Control

View and update the match rule controls. Match rule controls are sets of match rules applied against vouchers, purchase orders, and receivers during matching.

Document Association Group

AP_ASSTN_GRP

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vouchers, Document Association Group, Document Association Group

View the documents used in document association processing. You can include or exclude the delivered document associations.

Document Association Rules

AP_ASSOCIATION

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vouchers, Document Association Rules, Document Association Rules

Define how the Matching Application Engine process (AP_MATCH) automatically associates receivers to vouchers and purchase orders.

Document Association Criteria

AP_ASCALG_CRIT_SEC

Click the User Criteria link on the Document Association Rules page.

Select the voucher fields, the condition operands, and the receiver fields for the criteria you are adding.

Click to jump to top of pageClick to jump to parent topicViewing and Updating Match Rule Types

Access the Match Rule Type page.

Match rule types are matching categories. Every match rule is associated with a match rule type. The match rule type controls the actions allowed after the application of the rule in the Matching Application Engine process (AP_MATCH). They also provide default values for the workflow parameters defined on the rules. PeopleSoft delivers match rule types that include Data Entry, Merchandise - Amount, Merchandise - Quantity, Merchandise - Unit Price, Summary/Global Match Only, and System. To define additional match rule types, you must understand the complete matching process and the Matching process.

Header

Workflow Flag

Select to apply workflow to the rules that are associated to this match rule type. If you select the workflow flag, the Matching process generates worklist items for match exceptions. If you do not select the workflow flag, the system does not generate worklist items and the Send Email Notification field is not available.

Send Email Notification

Select to enable email notification. The Matching process notifies the defined users by email that there are match exceptions. This field is available if you select the Workflow Flag field.

Notification Reminder Days

Enter the number of days that the system waits before it sends another email notification for the match exceptions that have not been worked. This field is available if you select the Send Email Notification field.

User List Source

This group box is available if you select the Workflow Flag field.

Note. You need to set up users to receive worklist items or email notifications or both on the User Profiles - Workflow page before you can route match exceptions to them.

Role

Select to indicate that the list of users are based on roles. Enter the name in the Role Name field. All users with the specified role receives either a worklist item or an email notification or both, for match exceptions.

SQL Definition (structure query language definition)

Select to indicate that the list of users are based on a SQL definition. Enter the definition in the SQL Object Identifier field. The Matching process executes the SQL object to determine the user list.

Note. PeopleSoft delivers four SQL objects for Buyer, Purchase Order, Receiver, and Voucher (AP_MTCH_WF_BUYER_SQL, AP_MTCH_WF_PO_SQL, AP_MTCH_WF_RECEIVER_SQL, and AP_MTCH_WF_VOUCHER_SQL, respectively). If you add new SQL definitions, you should use the two bind parameters, BUSINESS_UNIT and VOUCHER_ID.

Query

Select to indicate that the list of users are based on a query. Enter the name in the Query Name field. The Matching process executes the query to determine the user list.

Note. To use a query, create a public query which selects the first column with a value equivalent to an operator ID (OPRID). If you want prompt values, use the fields available in the AP_VCHR_MTCH_VW.

Note. You can override match rule type workflow parameters at the match rule level.

Allowed Match Action

Action

Select a match action or actions to be taken after the rules associated with this type are applied. Valid action options for match rule controls include Debit Memo, Exception, and Match. Valid action options for the Match Workbench include Debit Memo and Override.

Note. If you select Debit Memo, you must select a debit memo category on the Rule Definition page for each match rule associated with this match rule type.

Note. The action or actions selected controls the actions allowed for the match rules associated with this match rule type.

Allow on Rule Control

Select to allow the match action on the Match Rule Control page for this match type. The Matching process automatically takes this action if the action is assigned to the rule.

Allow on Workbench

Select to allow the match action on the Match Exception Workbench Details page for the match rule that is associated to this match type.

See Also

Delivered Match Rule Types

Understanding the Matching Engine

Viewing and Updating Match Rule Controls

Managing Matches and Match Exceptions

Click to jump to top of pageClick to jump to parent topicViewing and Updating Match Rule Definitions

Access the Rule Definition page.

Match rules define how documents— vouchers, purchase orders, and receivers—are compared. PeopleSoft delivers the match rules that most organizations need. To define the additional valid match rules, you must understand the Matching process and its use of Model Record tables. It is also necessary to have an understanding of SQL.

Create Your Own Rule

The Create Your Own Rule group box only appears if you are adding a new match rule.

Copy From Match Rule Id and Copy

Click the Copy button to copy an existing match rule SQL statement specified in the Copy From Match Rule Id field.

Rule Properties

Match Rule Type

Select the match rule type for the match rule. The match rule type determines which actions are allowed when the rule is used and the workflow defaults. Options include Data Entry, Merchandise - Amount, Merchandise - Quantity, Merchandise - Unit Price, Summary/Global Match Only, and System.

Match Rule Level

Select the level that the rule is applicable. Options are:

Header Summary: The match rule is applied at the header level. The header summary record contains the voucher gross merchandise amount, total of purchase order schedule amounts, and total of receipt amounts that are associated to the specific purchase order schedule.

Line Summary: The match rule is applied at the line summary level. The line summary record contains the voucher line merchandise amount, purchase order schedule merchandise amount, and total of receipt amounts that are associated to the specific purchase order schedule.

Match Level Data Record

Displays the data record associated with this match rule level. There is a data record for every match rule level. These records contain the values used in the rules SQL definition.

Note. Use the values in the data record to create a custom match rule. You should first understand the values in the fields before creating the SQL where condition to ensure a valid match rule.

Match Rule SQL Object (match rule structure query language object)

Displays the SQL object associated with the match rule. The SQL object uses the fields contained in the match level data record. All delivered match rules are associated with a SQL object.

Edit SQL

Existing match rules only.

Click the link to view the SQL statement that the system executes for this match rule on the Match Rule SQL Criteria page.

Warning! Validate any changes made to the SQL statement to ensure proper syntax. This does not validate that the rule is going to perform as desired. Therefore, thoroughly test all match rules that you modify.

Create SQL

New match rules only.

Click to add the SQL statement that the system executes for this match rule on the Match Rule SQL Criteria page. SQL statements must begin with and to be properly executed. The system automatically creates a SQL object associated with this rule when you update the new SQL statement.

Warning! Validate any new SQL statements to ensure proper syntax. This does not validate that the rule is going to perform as desired. Therefore, thoroughly test all match rules that you create.

Use Tolerance at Rule Control

Select to include tolerance fields from the match rule control. Once you select this option, select either Amount or Percent to be used as a basis for the tolerance calculation. If you do not select this option, the Matching process will not use match rule control tolerances.

See Matching Tolerances.

Debit Memo Category

This option is available if the Debit Memo action is chosen at the match rule type level.

Select either Quantity or Unit Price. The system creates debit memo adjustment vouchers for merchandise - quantity and merchandise - unit price match rule types.

Note. The system requires a debit memo category if you allow Debit Memo as an action at the match rule control level or on the Match Workbench on the Match Rule Type page.

Message

Message Set Number and Message Number

Select a valid set and message number for the exception message that appears if this rule is not met during matching. Match exception messages are stored in the message catalog by set and message number.

View Message

Click the link to view the message that appears in the exception log in the event that this match rule is not met during matching.

Rule Applies To

The Rule Applies To group box only appears if the match rule level is Line Summary.

Association Name

Select the document association name that is applicable to this match rule. During the Matching process, the system applies this match rule only to those document association names you defined.

Options include VP (voucher and purchase order matching), VPR (voucher, purchase order, and receiver matching), and VR (voucher and receiver matching).

See Also

Delivered Match Rules

Click to jump to top of pageClick to jump to parent topicViewing and Updating Match Rule Workbench Properties

Access the Match Rules - Workbench page.

Workbench Match Rule Label

Displays the description of the rule that appears on the Matched Vouchers page, the Match Exception Workbench Details page, and the Match Overridden Workbench Details page. You can modify this field.

Display this match rule on the workbench only if matching generates an exception for this rule

Select to display the rule on the Match Exception Workbench Details page only if it is included in the exception record (AP_MTCH_EXCPTN).

The system automatically selects this field for system match rules.

Match Object

Select the match objects associated with this match rule that appears as columns on the Matched Vouchers page, the Match Exception Workbench Details page, and the Match Overridden Workbench Details page. Match object options include PO, Receiver, and Voucher.

Mapped To

Select the field from the header summary record (AP_VCHR_HDR_SUM) or the line summary record (AP_VCHR_LN_SUM).

Field Name

Displays the field name based on the Match Object field and the Mapped To field values.

Warning! The system uses the selected match objects and field names to display matching information on the Matched Vouchers page, the Match Exception Workbench Details page, and the Match Overridden Workbench Details page. If the mapping is incorrect, the matching information will not be accurate.

Click to jump to top of pageClick to jump to parent topicViewing and Updating Match Rule Workflow Parameters

Access the Match Rules - Workflow page.

You can override email notification parameters and user lists defined at the match rule type level. The workflow fields on this page are similar to the workflow fields on the Match Rule Type page.

See Viewing and Updating Match Rule Types.

Click to jump to top of pageClick to jump to parent topicViewing and Updating Match Rule Controls

Access the Match Rule Control page.

When you copy individual source documents to a voucher, the voucher inherits the source document header, line, and distribution information. When you copy multiple purchase orders or multiple receipts to a voucher, the voucher inherits the first instance of the source document's header information. As an example, if you copy multiple lines from different purchase orders to a voucher, the first purchase order's header information will be copied to the voucher.

Note. The accounting template from the purchase order is copied to the voucher similar to other header fields.

Structure match rules to meet the business needs through match rule controls. Match rule controls are sets of rules that the system applies against vouchers, purchase orders, and receivers. You can define a single control ID with all of the applicable match rules or multiple match rule controls, each with a subset of applicable match rules. Match rule controls are defined by SetID. The Matching process uses the match control defined on the purchase order header to determine which match rules to apply.

Define amount or percent tolerances to override exceptions generated by the match rules. If a match exception exists, and the voucher is within the tolerances, the Matching process automatically overrides the exception.

PeopleSoft delivers match rule controls that include Standard Match Rules Using Rules Tolerances, Standard Match Rules Using PO Tolerances, Standard, Debit Memo, and Basic. To define additional match rule controls, you must understand the Matching process.

Header

Description

Enter a short description for the match rule control. Use the long description box below the field to enter an expanded description of the match rule control.

Currency Code

Specify the currency code that is used to calculate the tolerance levels.

Match Rule Configuration

Effective Date

Enter the date that the match rules are valid. The Matching process applies these match rules to vouchers with a match due date of this date or later.

Delete Rules

Click to delete only the rules selected to be deleted on the Match Rules grid.

Clear Rules

Click to delete all match rules from the Match Rules grid.

Populate Rules

Click to populate the Match Rules grid with all the available match rules. This is required if you are adding a new match rule control so system match rules are automatically populated in the match rules table. You cannot delete or edit the system match rules.

Match Rules - Rules Tab

Delete

Select to mark the match rule for deletion. The match rule is deleted when you click the Delete button.

Click to move the current row up or down by one row. This action changes the matching processing logic sequence. It also changes the display order of the match rules on the Matched Vouchers page, the Match Exception Workbench Details page, and the Match Overridden Workbench Details page.

Note. The buttons are not available for system match rules. System match rules always appear first in the sequence.

Match Rule ID (match rule identification)

Displays the match rule associated with this match rule control. You can delete or add new match rules to the match rule control.

If Rule is True Take Action

Select the action to take during the Matching process when voucher lines are returned from executing the match rule SQL. The list of actions available for the match rule depends on its association to the match rule type and the match actions allowed. System match rules are display only. Possible actions include:

Match: When this action is selected voucher lines returned are matched.

Note. The system determines if there are any exceptions for the other voucher lines. If there is even a single exception for another voucher line, the system applies exception as the match action for the entire voucher.

Debit Memo: When this action is selected voucher lines returned are marked as debit memo applicable. The system allows this option if there is a mismatch in quantity or unit price. The system waits until all match rules are executed and no exceptions exist before it creates the debit memo adjustment voucher. If you override the exceptions, the system creates the debit memo during the next Matching process if no other exceptions exist.

Note. For the system to create debit memo adjustment vouchers for a vendor, you must first specify the debit memo options for vendor locations on the Debit Memo Options collapsible region on the Vendor Information - Payables Options page.

Exception: When this action is selected voucher lines returned are marked as exceptions. Generally, this action is specified for match rules that check for inequality between the voucher and the purchase order and receiver.

Continue to Next Rule

Select the action to determine how the Matching process continues. System match rules are display only. Actions include:

Always Continue: The Matching process applies the next match rule.

Continue if False: The Matching process applies the next match rule for voucher lines not returned by executing the match rule SQL.

Continue if True: The Matching process applies the next match rule for voucher lines if returned by executing the match rule SQL.

Match Rules - Tolerances Tab

Under Amount

Specify the tolerance amount to be used in the under tolerance calculation. This field is available if the Use Tolerance at Rule Control and Amount fields are selected on the Rule Definition page.

Over Amount

Specify the tolerance amount to be used in the over tolerance calculation. This field is available if the Use Tolerance at Rule Control and Amount fields are selected on the Rule Definition page.

% Under Amount

Specify the tolerance percent for the amount to be used in the under tolerance calculation. This field is available if the Use Tolerance at Rule Control and Percent fields are selected on the Rule Definition page.

% Over Amount

Specify the tolerance percent for the amount to be used in the over tolerance calculation. This field is available if the Use Tolerance at Rule Control and Percent fields are selected on the Rule Definition page.

See Also

Delivered Match Rule Controls

Click to jump to top of pageClick to jump to parent topicViewing and Updating the Document Association Group

Access the Document Association Group page.

PeopleSoft delivers three document associations that include VP (voucher and purchase order matching), VR (voucher and receiver matching), and VPR (voucher, purchase order, and receiver matching). When the Matching process performs the match association, it assigns the voucher to one of the three match association records based on the match association SQL selection criteria. For example, the system assigns a voucher that has an associated PO ID with receipt required to VPR.

Specify the document association group to use in the Matching process on the Installation Options - Payables page.

Association Name

Displays the document association group and the sequence for processing. Options include:

VP: The system associates vouchers and purchase orders that do not require receipts.

VR: The system associates vouchers and receivers (non purchase order receipts).

VPR: The system associates vouchers, purchase orders, and receivers.

You can include or exclude the delivered document associations that are not part of the business process.

See Also

Understanding the Matching Engine

Setting Up Payables Installation Options

Click to jump to top of pageClick to jump to parent topicViewing and Updating Document Association Rules

Access the Document Association Rules page.

As part of the Matching process, the document association process associates the appropriate purchase orders and receivers to the selected vouchers. The system associates the documents using the criteria specified on line 1. If no successful associations are found, the rules defined on line 2 apply, and so forth, until documents are associated.

Click to move the current row up or down by one row. This action changes the processing logic sequence for associating the documents.

Rule

Select a rule to apply when associating documents. Options include:

Equal: The system selects the lines if the specified field on the source document (voucher) line matches exactly with the specified field on the association document (receiver). Only one association document line can be associated with the source document line.

Equal Sum: The system selects the lines if the specified field on the source document line equals the sum of the specified field values on the associated document line or lines. One or more association document lines can be associated with the source document line.

Select All: If any association document lines exist, the system selects the lines without comparing any rule fields.

Select If One: If only one association document line exists, the system selects the line without comparing any rule fields.

Sum Up To: If any association document lines exist, the system creates a running total of the specified field values and selects as many association document lines as necessary to equal the source document line field. The system concatenates the receiver BU, receiver ID, receiver line number, and the receiver ship sequence number and determines the minimum value and associates that receiver line to the voucher line. This process continues until the voucher line is completely associated or there are no more receipts. This may also result in a partial match of an associated document line.

User Criteria: The system selects the lines based on the user criteria defined on the Document Association Criteria page.

Voucher

Select the voucher field to be used in document association processing. Options include Merch Amt (merchandise amount) and Quantity. You should only use Merch Amt for amount only purchase orders.

Receiver

Select the receiver field to be used in document association processing. Options include Merch Amt (merchandise amount), Qty Accept (quantity accepted), and Qty Recv (quantity received). You should only use Merch Amt for amount only purchase orders.

Amount Only

Select to apply the document association rule to amount only purchase orders, not regular purchase orders. Select Merch Amt (merchandise amount) for the Voucher and Receiver fields.

User Criteria

Click to access the Document Association Criteria page where you can enter a user-defined condition statement for the row. The Matching process uses the voucher and receiver values you define to select the receipts.

This link is in bold if user criteria exists.

See Also

Understanding the Matching Engine

Click to jump to parent topicSpecifying Voucher Build Criteria

To specify voucher build criteria, use the Voucher Build Criteria component (VCHR_BLD_DEFN).

This section provides an overview of how the Voucher Build process uses voucher build criteria to build voucher records from purchase orders and receivers, and discusses how to define voucher build criteria.

See Also

Processing Batch Vouchers

Click to jump to top of pageClick to jump to parent topicUnderstanding Voucher Build Criteria

When the Voucher Build process builds voucher records from purchase orders and receivers, it uses default processing logic to associate the voucher line information it has received with purchase orders and receivers. The process uses this association to help build the voucher from the receiver or purchase order data.

When you use the Quick Invoice Entry component (VCHR_QUICK_PNL) to enter basic voucher information for the Voucher Build process to build into voucher records, you can accept this default processing logic or specify a voucher build code that identifies special processing logic that you want the Voucher Build process to follow. These voucher build codes specify how the Voucher Build process finds matches between voucher line information and receivers or purchase orders. You define voucher build codes using the Voucher Build Criteria component.

See Also

Voucher Build Processing Logic for Associating Voucher Lines with Purchase Order and Receiver Lines

Click to jump to top of pageClick to jump to parent topicPages Used to Specify Voucher Build Criteria

Page Name

Object Name

Navigation

Usage

Voucher Build Code Definition

VCHR_BLD_DEFN

Set Up Financials/Supply Chain, Product Related, Procurement Options, Vouchers, Voucher Build Criteria, Voucher Build Code Definition

Define criteria that determine how the Voucher Build process creates voucher records from purchase orders and receivers.

Voucher PO User

VCHR_PO_USER

Select the User or View Only option in the User field for a purchase order criteria row on the Voucher Build Code Definition page, then click the User Criteria link in that row.

Enter SQL statements for the user criteria you are adding.

Override Session Default (purchase order)

VCHR_PO_CLAUSE

Click the Build Clause button in the purchase order criteria row on the Voucher Build Code Definition page.

View the complete SQL statement for a purchase order criteria row on the Voucher Build Code Definition page.

Voucher Receiver User

VCHR_RECV_USER

Select the User or View Only option in the User field for a receiver criteria row on the Voucher Build Code Definition page, then click the User Criteria link in that row.

Enter SQL statements for the user criteria you are adding.

Override Session Default (receiver)

VCHR_RECV_CLAUSE

Click the Build Clause button in the receiver criteria row on the Voucher Build Code Definition page.

View the complete SQL statement for a receiver criteria row on the Voucher Build Code Definition page.

Click to jump to top of pageClick to jump to parent topicDefining Voucher Build Criteria

Access the Voucher Build Code Definition page.

Note. The Voucher Build process first attempts to build the voucher using the receiver criteria you define. If the process does not find an association based upon the receiver information, then the logic proceeds to the purchase order criteria.

Note. The more specific the criteria you define, the better the system performs. If the voucher build criteria return multiple matches per voucher line, the Voucher Build process may select and build a voucher line record from the incorrect receiver or purchase order.

Purchase Order Criteria

The Voucher Build process uses the criteria that you define in this grid to find purchase orders for building voucher records. You can define multiple rows. The system looks for purchase orders using the criteria specified on the first line. If no purchase orders are found, the system uses the criteria defined on the second line, and so forth. You can use the up and down arrows in each row to change the line order.

A purchase order schedule can be associated with only one voucher line during a single Voucher Build process instance.

PO Line Opt (purchase order line option)

Define the criteria the system uses for finding purchase orders. The available options are:

  • None: The system skips this field.

  • PO BU: The system uses the purchase order business unit specified on the voucher line.

  • PO ID: The system uses the purchase order business unit and the PO ID specified on the voucher line.

  • PO Line: The system uses the purchase order business unit, PO ID, and the purchase order line number specified on the voucher line.

  • PO Sched: The system uses the purchase order business unit, PO ID, purchase order line number, and the purchase order schedule number.

Item Option

Define whether the system searches for purchase order schedules based on the item ID. The available options are:

Item ID: The system uses the item setID and item ID on the voucher line.

None: The system skips this field.

Qty Option (quantity option)

Define the criteria the system uses as a basis for finding purchase orders schedules. The available options are:

None: The quantity is not used as a basis for finding purchase orders.

PO Qty: The system uses the purchase order quantity and unit of measure.

User

To define a SQL statement for finding purchase orders, select User or View Only. The User Criteria link appears. Click this link to access the Voucher PO User page, where you can enter the SQL clause for the condition you are adding.

Select None if you do not want to add a user-defined SQL clause.

Click this button for any row to access the Override Session Default page, where you can view the complete SQL statement for that row, including any that you might have added.

Receiver Criteria

The Voucher Build process uses the criteria that you define in this grid to find receivers for building voucher records. You can define multiple rows. The system looks for receivers using the criteria specified on the first line. If no receivers are found, the system uses the criteria defined on the second line, and so forth. You can use the up and down arrows in each row to change the line order.

Receiver Reference

Define the criteria the system uses for finding receivers. The available options are:

BOL (voucher bill of lading): The bill of lading on the receiver header equals the bill of lading on voucher header.

Carrier ID: The carrier ID on the voucher header equals the carrier ID on receiver header.

Invoice: The Voucher invoice number equals the receiver line Packing Slip ID.

None: The system defaults to receiver line option.

PackSlip: The voucher packing slip field equals the receiver line Packing Slip ID.

PO Line Opt (purchase order line option)

Define the criteria the system uses for finding purchase orders. The available options are:

None:The system skips this field.

PO BU: The purchasing business unit on the voucher line equals the purchasing business unit on the receiver line.

PO ID: The purchasing business unit and the PO ID on the voucher line equals the purchasing business unit and PO ID on the receiver line.

PO Line: The purchasing business unit, PO ID, and the purchase order line number on the voucher line equals the purchasing business unit, PO ID, and the purchase order line number on the receiver line.

PO Sched: The purchasing business unit, PO ID, purchase order line number, and the purchase order schedule on the voucher line equals the purchasing business unit, PO ID, purchase order line number and the purchase order schedule number on the receiver line.

Recv Line Opt (receiver line option)

Define the criteria the system uses as a basis for finding receivers:

  • None: The system skips this field.

  • Recv BU: The system uses the receiver business unit on the voucher line.

  • Recv ID: The system uses the receiver business unit and the receiver ID on the voucher line.

  • Recv Sched: The system uses the receiver business unit, receiver ID and the receiver line number.

Item Option

Define whether the system searches for receivers based on the item ID. The available options are:

Item ID: The Item setID and the Item ID on the voucher line are used as a basis for finding receivers.

None: The system skips the Item ID field.

Qty Option (quantity option)

Define how the system finds receivers based upon quantities. The available options are:

Accepted: The accepted quantity on the receiver in the vendor's unit of measure.

None: The system skips this field.

Receipt: The quantity on the receiver in the vendor's unit of measure.

User

To define a SQL statement for finding receivers, select User or View Only. The User Criteria link appears. Click this link to access the Voucher Receiver User page, where you can enter the SQL clause for the condition you are adding.

Select None if you do not want to add a user-defined SQL clause.

Click the Build Criteria button for any row to access the Invoice Details page, where you can view the complete SQL statement for that row, including any that you might have added.

Click to jump to parent topicDefining Voucher Session Defaults

Session defaults are available for the Journal Voucher, Regular Voucher, Single Payment Voucher, and Template Voucher styles in the Voucher or Quick Invoice Entry components. These defaults override the defaults that the system applies using the PeopleSoft Payables control hierarchy. Users can select these predefined session defaults or create adhoc session defaults from the Voucher or Quick Invoice Entry components.

To define voucher session defaults, use the Session Defaults component (AP_SESSION_DEFAULT).

This section discusses how to enter session defaults.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Voucher Session Defaults

Page Name

Object Name

Navigation

Usage

Session Defaults

AP_VCHR_DFLT_PG

Set Up Financials/Supply Chain, Product Related, Procurement Options, Session Defaults

Enter voucher defaults for a predefined session default that the users can select from the Voucher or Quick Invoice Entry components. These defaults override the values that the system applies using the PeopleSoft Payables control hierarchy.

Click to jump to top of pageClick to jump to parent topicEntering Session Defaults

Access the Session Defaults page.

You can create session defaults for all users, user roles, or specific users. On the add search page, when you select Primary Permission List as the Session Default Type, you need to specify a primary permission list. When you select User ID, you need to specify a user ID.

Estimated No. of Invoice Lines (estimated number of invoice lines) and Estimated No. of Distribution Lines (estimated number of distribution lines)

Enter the number of invoice lines and distribution lines to appear as default on the voucher.

Active Flag

Select to use during voucher entry from the Voucher or Quick Invoice Entry components. This session default is not available if you do not select this check box.

Business Unit

Enter a PeopleSoft Payables business unit and rate type to appear as defaults for the voucher session.

Vendor Detail

Enter a vendor ID, address sequence number, vendor location, and currency code to appear as defaults for the voucher session.

Invoice Defaults

Enter an accounting date, origin, and control group ID to appear as defaults for the voucher session.

For Quick Invoice Only

The options in this group box are applicable to quick invoices only.

Terms

Enter the payment terms default for this session.

QI Template (quick invoice template)

Select the worksheet that is the default for this session. Options are:

  • Complete: Establish the Quick Invoice complete worksheet page as the default. On this page, you can copy purchase orders and receivers and specify more voucher details.

  • Simple: Establish the Quick Invoice simple worksheet page as the default. On this page, you can quickly enter basic voucher information.

Template

Enter the accounting entry template default for this session.

Build Code

Enter the voucher build code for the session.

PO Unit (purchase order business unit) and Recv Unit (receiver business unit)

Enter a default PO business unit or receiver business unit (or both). The Voucher Build process uses this information, along with appropriate PO or receiver information that you enter on the voucher lines, to locate the purchase order or receiver lines and build the voucher and distribution lines from them.

Note. For quick invoice entry, this functionality applies to the complete worksheet only.

Select how to display the following options on the Quick Invoice Entry component. Values are Display, Gray, and Hide for these options:

PO Options (purchase order options)

Controls display of all purchase order-related fields. This option only applies to quick invoices using the complete template.

Receiver Options (receiver options)

Controls display of all receiver-related fields. This option only applies to quick invoices using the complete template.

Non- Merchandise Charges

Select how to display the following options on the Voucher or Quick Invoice Entry components. Values are Display, Gray, and Hide for these options:

Misc Options (miscellaneous charge options)

Controls display of miscellaneous amount and miscellaneous charge code fields.

Frght Options (freight charge options)

Controls display of freight amount and freight charge code fields.

Sales Tax Opt (sales tax charge options)

Controls display of sales tax amount, sales tax charge code fields, tax exempt fields.

VAT Amt Opt (VAT amount options)

Controls display of VAT amount and VAT Apport CF (VAT apportionment ChartField) fields.

Distribution

Enter default general ledger and project ChartField values in this region.

Important! Chartfields that display here depend on how you configure options on the Standard Chartfield Configuration page.

See Completing the Standard ChartField Configuration Page.

Click to jump to parent topicDefining Document Tolerances

To define document tolerances, use the Document Tolerance Definition component (DOC_TOL_DEFN).

This section provides an overview of document tolerance checking setup and discusses how to define document tolerances.

Click to jump to top of pageClick to jump to parent topicUnderstanding Document Tolerance Checking Setup

The Document Tolerance Checking Application Engine process (FS_DOC_TOL) enables you to edit tolerances between predecessor documents and successor documents—that is, between requisitions and purchase orders in PeopleSoft Purchasing and between purchase orders and vouchers in PeopleSoft Payables—before you run the Commitment Control Budget Processor Application Engine process (FS_BP). The Document Tolerance Checking process validates that each distribution line amount on a document differs by no more than a predefined percentage (or fixed amount, depending on the setup) from the associated distribution line amount on its predecessor document.

To set up document tolerance checking:

  1. Enable document tolerance checking by selecting the Enable Document Tolerance option on the Installation Options - Overall page and entering the ChartField whose values you use for setting up document tolerances.

    The default ChartField is Fund Code.

  2. (Optional) Require documents be approved before running the Document Tolerance Checking process on them by selecting the Document Approval Required option on the Installation Options - Overall page.

  3. (Optional) Set up document tolerance exception override authorization for users on the Define User Preferences - Procurement - Document Tolerance Exceptions Override Authorizations page.

  4. Define document tolerances by setID and ChartField value on the Document Tolerance Definition page.

  5. Enable document tolerance checking for the general ledger business unit shared by the purchasing and accounts payables business units by selecting the Enable Document Tolerance option on the Procurement Controls - General Controls page.

See Also

Setting Installation Options for PeopleSoft Applications

Defining Document Tolerance Authorizations

Running Document Tolerances

Running Document Tolerances

Selecting General Controls

Click to jump to top of pageClick to jump to parent topicPage Used to Define Document Tolerances

Page Name

Object Name

Navigation

Usage

Document Tolerance Definition

DOC_TOL_DEFN

Set Up Financials/Supply Chain, Product Related, Procurement Options, Document Tolerance Definition, Document Tolerance Definition

Define document tolerances.

Click to jump to top of pageClick to jump to parent topicDefining Document Tolerances

Access the Document Tolerance Definition page.

Select a setID, ChartField, and ChartField value, and click the Get Tolerance Definition button to display the Tolerance Definition group box.

The tolerances to apply are:

When Encumbrance Exceeds Pre-encumbrance

Enter the percentage and amount that the Document Tolerance Checking process uses to determine if a purchase order that exceeds a requisition fails document tolerance checking.

When Expenditure Exceeds Encumbrance

Enter the percentage and amount that the Document Tolerance Checking process uses to determine if a voucher that exceeds a purchase order fails document tolerance checking.

Note. The system uses the lower value (either the percentage or amount) to calculate the tolerance. If you enter 0.00 in the Percent or Amount fields, the system calculates a zero tolerance, and the successor document must equal the predecessor document to pass document tolerance checking.