Setting Up Summarization Templates

Summarization Template Page

PC_SUM_TEMPLATE

Define summarization rules for feeder integration applications, the Pricing process, and the Variance Pricing process.

Expenses

PC_EX_TO_PC

General Ledger

PC_GL_TO_PC

Third Party Loader

PC_INTF_GEN and PC_INTFEDIT

Pricing Engine

PC_PRICING

Variance Pricing

PC_VAR_PRICE

Time and Labor

PC_TL_TO_PC

Payables / Purchasing

PC_AP_TO_PC, PC_PO_TO_PC, and PC_POADJUST

Project Reporting Tables

PC_SUM_PR

Product Code

Select a product code that identifies to which the template applies. For example, Expenses, General Ledger, Payables / Purchasing, Pricing Engine, Project Reporting Tables, Third Party Loader, Time and Labor, or Variance Pricing.

Process Order

Enter a number that determines the order in which the template is processed when multiple templates are defined for a product code. The process order does not have to be consecutive and you can leave gaps in the process order. For example, you can enter 10, 20, and 30 as the process order for a product code. Leaving gaps in the process order enables you to insert templates between existing templates at a later time.

Default

Select to indicate that the template is the default template. The default template is applied to all detail rows that do not match any of the existing templates for the product code.

It is not required to have a default template for a product code. If you do not define a default template, then any data that does not match the criteria of an existing template is not summarized. For example, if you have a template for business unit US001 and no default template is defined, then data for business units US002 and US003 is not summarized.

Custom SQL

The Custom SQL option was removed in Update Image 46. Existing templates will continue to function but cannot be adjusted. New templates cannot use the Custom SQL option.

Copy From Project (group box)

Use this group box to populate the Summarization Fields group box from an existing summarization template. When you click the Copy button, existing data in the Summarization Fields group box are deleted and replaced with the data being copied.

Field Name

Add non-required fields to include in the summarization selection process.

When creating a template, the system automatically populates all required field names. Required fields names are display only and cannot be deleted.

For Microsoft SQL and Sybase database platforms, you can only have a maximum of 32 fields, which includes the required and non-required fields.

Date Summarization Level and Rollup Date to Use

Enter a date type that determines how dates are to be rolled up by the summarization process. These fields are only displayed for date fields.

The rollup date that you use can impact effective dating. When setting up a date field, make sure that the effective date of your rate plan or rate set are valid with the roll up date. For example, when creating a pricing summarization template, you select Start of Period in the Rollup Date to Use field. This indicates that the summarized rows are assigned an accounting or transaction date of the start of the period, such as January 1, 2010 (01/01/2010). You should verify that the rate plan or rate set that you are using has an effective date of January 1, 2010, or earlier, for all transactions to be summarized.