Entering and Reviewing Valid ChartField Combinations
These topics provide overviews of combination codes, valid combination loading, and speed types. It also discusses combination codes.
A combination code is a key that defines a combination of ChartFields. When you run processes to post transactions to the general ledger, the combination code identifies the ChartFields to include in each transaction.
A valid combination code is a combination of ChartFields that are valid in general ledger. Store valid combination codes in the Valid Combination table (VALID_COMBO_TBL) to be used by the ChartField combination validation process.
Note: If you are not using valid combination codes and want to be able to enter any combination of ChartFields on the transaction pages, do not populate the Combination Code table. The system populates the ChartField Transaction table (ACCT_CD_TABLE) with the ChartField combinations you use so you can track and reuse them.
There are three ways to enter valid combination codes into the Valid Combination table. The method you use depends primarily on which General Ledger (GL) system and version you use.
Importing from the Financials Database
If you integrate with PeopleSoft Financials 8.0 or later, you can import the valid ChartField combinations from the Financials database and keep them up-to-date using Integration Broker.
To import valid combinations from Financials:
Publish combination data information from Financials (FSCM) to CS using the HR_ACCT_CD_LOAD Integration Broker service operation.
When CS receives this service operation, the handler arranges the data in the correct layout and populates the GL_ACCT_CD_TBL.
Run the Load Combination Code SQR process (BUD003) to populate the Valid Combination table.
Flat File Loading
If you integrate with a financials system that does not have Integration Broker capability, you can use the Inbound Flat File process to load and maintain the Valid Combination table (VALID_COMBO_TBL).
To populate valid combination codes using the Inbound Flat File process:
Create a flat file that contains valid combination data in the layout format specified by GL_ACCT_CD_TBL.
Initiate the Inbound Flat File process to publish this combination data using the HR_ACCT_CD_LOAD service operation.
When the service operation is received, the handler arranges the data in the correct layout and populates the GL_ACCT_CD_TBL.
Run the Load Combination Code SQR process (BUD003) to populate the Valid Combination table.
Manual Loading
If you do not integrate with PeopleSoft Financials, you can enter valid ChartField combinations directly into the Combination Code Table page. This page is not available for manual data entry if the GL indicator is selected on the Installation table.
See PeopleSoft FSCM: Resource Management.
Speed types are shortcut keys for frequently used combinations of ChartFields. Using speed types can minimize keying, greatly increase journal efficiency, and reduce errors.
If you integrate with PeopleSoft Financials 8.0 or later, you can use the HR_CHARTFLD_COMBO_SYNC service operation to keep the Speed Type table up-to-date. Any change made to the Speed Type table in the Financials database triggers the Integration Broker update to CS.
|
Page Name |
Definition Name |
Navigation |
Usage |
|---|---|---|---|
|
Load Combination Code Table |
RUNCTL_FILEPATH |
|
Run the Load Combination Code process (BUD003) to load the Combination Code table with ChartField combinations already imported into the GL_ACCT_CD_TBL through the HR_ACCT_CD_LOAD service operation. |
|
Combination Code Table |
VALID_COMBO_TBL |
|
Review all combination codes imported into CS and loaded by the Load Combination Code process (BUD003). Manually define and review valid combinations of ChartField values if you do not import them. |
|
Combination Code Report |
PRCSRUNCNTL |
|
Run the Combination Code report (PAY760) to report the contents of the Valid Combination table (VALID_COMBO_TBL). |
|
SpeedTypes |
HMCF_SPEEDTYPE |
|
Review the Speed Type table maintained from PeopleSoft Financials. |
Access the Load Combination Code Table page ().
|
Field or Control |
Definition |
|---|---|
| As of Date |
Enter the as of date for the ChartField combinations you are importing from PeopleSoft General Ledger. |
| Interface with GL Release |
Select the PeopleSoft Financials release to use when the Load Combination Code process runs. |
| Inactivate Accounts Not Downloaded |
When this option is selected, the system deactivates combinations for which it does not find matches in the current fiscal year. When this option is blank, old combinations remain active for the current fiscal year. |
Access the Combination Code Table page ().
Image: Combination Code Table page
This example illustrates the fields and controls on the Combination Code Table page. You can find definitions for the fields and controls later on this page.
You cannot change the ChartField values for combination codes imported from Financials, but you can change the description and make it active or inactive.
|
Field or Control |
Definition |
|---|---|
| GL Combination Code (general ledger combination code) |
Enter this code on the CS pages to use this combination of ChartFields in a transaction. The system generates the combination code sequentially based on the Last Combination Code Assigned field on the Installation table under these conditions:
|
| Valid Value |
You can select this check box when you enter the ChartField combination for the first time for the setID. Select this check box if the ChartField combination is valid. If the combination already exists with the same setID, this check box is selected based on the value of the preexisting combination and cannot be edited. |
| ChartField Detail |
If you are manually setting up combination codes, enter the ChartField value for each ChartField that applies to this ChartField combination. Only the ChartFields that are active on the Standard ChartField Configuration page appear on this page |