To set up combination editing, use the following components:. This section provides an overview of combination editing setup and discusses how to:. Define the ChartField combination editing template. Define combinations of ChartFields to edit. Define the combinations for editing ChartField values.
Link combination rules in a combination group. Associate combination editing groups to ledger groups. This page is accessed from the Build Combination Data Request page. Click the Process Groups link for the business unit and then the specific process group link. ChartField Combination Editing Template. Define combination definition template to tell the combination editing process which tables and fields to process and how to process them.
Ledger Template - Field Definitions. Link a ChartField combination editing template for the applicable application to a ledger template for combination ChartField editing during journal edit; it is also required for ChartField validation during journal edit whether you are using combination editing or not. ChartField Combination Editing Definition. Define the combination of ChartFields to edit. Define the combination rule by specifying the SetID, naming the combination rule, and specifying the combination definition and effective dates that are for the rule.
Define the anchor ChartField and nonanchor ChartField values to include in the rule. ChartField Combination Editing Group. Link combination combination definition together combination definition a combination group.
Link a process group to ledger groups. Assign a transaction source by process group if you want to limit combination edit processing for efficiency. Combo Edit Transaction Source.
Define the name of the transaction source that is associated with a given process group. Combo Edit Transaction Source display only. To set up the combination editing process, complete the following setup steps:. Enable combination editing in the applications, for example Accounts Payable and Billing. Select or define the ChartField combination definition editing template that is specific to the application combination definition performing background combination editing.
Link the combination edit template to the applicable ledger template for People Soft General Ledger. Set up combination combination definition that specify two or more ChartFields that combination definition want to edit in combination for a business unit and ledger group. Define combination rules 1 and 2 that link ChartField combination values for journal entries.
These rules determine the combinations of ChartField values that pass the Journal Editing process. Whether to edit for valid or invalid combinations, after analyzing which is more efficient in the circumstances.
Whether to define ChartField values as specific values or as a range of values using PeopleSoft tree-based criteria. Which rules, and how many, to define for each ledger group.
An unlimited number of rules is possible, but the more rules there are, the slower the process. This is especially true when you have required ChartFields in the combination rules. You must update the rules whenever the accounting control requirements change.
Define combination definition editing combination definition. Associate combination definition combination rules with a combination group definition. Include combination editing rules that belong to each group.
The system uses these related combinations for validating journal entries during the journal edit process. Tie a combination group to a ledger group on the Ledgers for a Unit — Journal Edit page.
Decide whether to assign a transaction source to combination definition combination group or not. Assigning a specific transaction source to the process group can avoid unnecessary processing of data. Build a user-defined data table if it fills your needs. Run the Journal Edit process to generate selector tables dynamically and validate ChartField combinations.
Use the Retain Detail Values options to create a permanent table of combination ChartField Values from the master selector table. Maintain the system by changing combination rules and regenerating the tables as necessary. ChartField Combination Editing Template page. This example illustrates the fields and controls on the Combination definition Combination Editing Template page. You combination definition find definitions for the fields and controls later on this page.
This is a delivered template that is used in the background combination editing as well as the journal edit process. PeopleSoft delivers several templates for its applications that define the record names, field names, and combination definition status values that are to be used in combination editing. You do not need to change the delivered templates for the various PeopleSoft application or create new templates unless you customize the system. Combination definition name of the record that contains the ChartField combinations journal lines that the combination editing process edits.
The name of the record that contains the journal header of the accounting line entries that the combination editing process edits. This field is optional and you can leave it blank.
The name of the record that stores the error messages for individual lines of combinations for the combination combination definition error-checking process.
Designates the application to which the template applies. The field name that the system uses for the transaction date. The field name that the system uses for the General Ledger business unit. The field name that the application uses for the foreign currency code. The name of the field in which the status of the combination line is recorded. The combination editing process updates the lines with the status of each transaction by using the combination definition that are combination definition.
Indicates that the transaction failed due to an error. Indicates that the transaction is processing not currently used. Indicates a valid or passed transaction. Supply the value that the application uses to represent the corresponding status code for the combination, such as 0 for valid, or an 1 for invalid.
Ledger Template - Field Definitions page. This example illustrates the fields and controls on the Combination definition Template - Combination definition Definitions page. For PeopleSoft applications that use the background combination editing process, you must link the combination edit template for the application to a ledger template on the Ledger Template - Combination definition Definition page.
The Journal Edit process uses the specified combination edit template for ChartField validation during journal editing. Select the templates that are applicable to the ledger combination definition from the combination definition list box.
The Journal Edit process combination definition this template for ChartField validation. The Journal Edit process fails if this field is blank. ChartField Combination Editing Definition page. This example illustrates the fields and controls on the ChartField Combination Editing Definition page.
Specify the ChartFields that you want in the combination. The first ChartField that you enter is selected by default as the anchor ChartField. Combination definition anchor ChartField drives the combination edit rule. The system automatically designates the combination definition ChartField that you list as the anchor ChartField. When you run the Combination Editing process, the system first searches for the combination definition ChartField that you define in the combination definition and then matches combination definition other nonanchor ChartFields in the combination.
The anchor ChartField drives combination definition combination rule dealing with ChartField values that you define in the next correlation strategy and binary options. This example combination definition the fields and controls on the Rule Definition page. Specify the effective date range that determines the time frame in which the rule is valid.
During journal editing, the program, by using journal date as its criteria, applies only valid combination rules to combinations that fall within this range. Select this option to specify an open-ended combination definition for effective date to. Identifies which ChartFields are included in this combination rule.
You can modify this as long as no combination rules are based on this definition. Enter an effective date for prompting detail ChartField values and PeopleSoft trees that are dated on or prior to this date. Because there is a range of dates rather than an effective date on the page, you might want to enter ChartFields from any time period within the range.
You can specify the date from which to prompt for these ChartFields, but the default is to the current date. When you define a rule for the first time, the system displays the nonanchor ChartFields. Select this check box for nonanchor ChartFields to specify that any nonblank valid value is required. When you select this check box, the system restricts you from entering values or tree nodes in the rule for the related nonanchor ChartField. Selecting this check box provides an easy way for you to require a valid value for a ChartField without having to define each valid value in the rule.
Using a blank tree node or level, you can accomplish much the same thing by defining a combination with a blank ChartField value as combination definition Invalid Combination on the ChartField Combination Group page. This example illustrates the fields and controls on the ChartField Combinations page.
If you select the Value Required check box on the Rule Definition page, this page is automatically populated.