This chapter contains the topic:
From Contract Billing Processing (G52), enter 29
From Contract Billing System Setup (G5241), choose Table Information
From Table Information (G4843), choose Account Derivation Table (P48196)
Whenever you create journals for revenue recognition or billing, the system must follow instructions that you set up in the account derivation rules. If you want the system to create journals only under certain conditions, you can specify condition codes for reallocation rules that you define on Account Derivation Table.
For example, if you want the costs for a job to go to one account and the revenue for the job to go to another account, but only when the home business unit for the related workfile transactions does not equal the job, you can set up a condition.
You use the Condition Code Revisions form to set up and revise the codes that you apply to your reallocation rules. These codes define the conditions that transactions must meet before the system can create the resulting journal entries specified by the account derivation rules.
When you use condition codes, the system requires additional processing time to test each condition before creating the resulting journal entries.
You use logical operators, retrieval references, and specific values to define the conditions that make up a condition code. Logical operators include and, or, equal, not equal, and so on. Retrieval references direct the system to specific variable information stored in system tables, such as data items. If you set up a condition code with multiple conditions, you use an and/or statement.
For example, you might define a condition as "Job equal to 5001." Equal is the logical operator. The retrieval reference directs the system to the data dictionary item for Job. Finally, 5001 is a specific value that refers the system to a specific job in the system. If you assigned a condition code that included this condition to a reallocation rule, the rule would only apply to transactions that included Job 5001 in the account information.
Set up the names for your condition codes on the user defined codes table 48/CC
On Account Derivation Table
Figure 37-1 Account Derivation Table (Condition Code Names) screen
Complete the following fields to locate a specific reallocation rule:
Table Type
Key Type
Table Key
Effective Dates
Choose Condition Code Definition (F13).
Figure 37-2 Condition Code Revisions screen
On Condition Code Revisions (P4871), complete the following field to locate a condition code:
Condition Code
Complete the following field to define more than one condition for the code:
And/Or Selection (AO)
Complete the following fields to define the conditions:
Value One
Relationship (Df Rl)
Comparison Value Two
Sequence Number (optional)
Field | Explanation |
---|---|
Condition Code (CNDC) | A descriptive name for a condition code. The code represents a set of logical tests of the relationships between specified values. You enter the values and their relationships to test on the Condition Code Revision form.
When you use a condition code, all of the specified relationships for that code must exist before the system will create the resulting transactions for the table entry. |
And/Or (AO) | A code that determines whether compound data selection logic is based on an A = AND condition or an O = OR condition. |
Value One (CMV1) | The information entered in this field will determine the first value in a comparison of two values. This field must contain a Retrieval Reference Number, preceded by an ampersand (&). The retrieved value will then be compared to the value specified in Comparison Value 2 to determine if the relationship entered in the Relationship field is satisfied. |
Relationship (VALS) | A code that identifies the operands in Boolean logic. You can specify any of the following:
EQ – Equal to LT – Less than LE – Less than or equal to GT – Greater than GE – Greater than or equal to NE – Not equal to NL – Not less than NG – Not greater than |
Comparison Value Two (CMV2) | This field represents the second of two values that will be compared. You can enter a specific value to be used in the comparison, or you can enter a Retrieval Reference Number, preceded by an ampersand (&). This value will be compared to the value referenced in the Value One field to determine if the relationship specified in the Relationship field is satisfied. |
Topic | Description |
---|---|
Retrieval references | You must specify a retrieval reference in the Value One field for each condition you define on the Condition Code Revisions form. Use only the retrieval references associated with variable information in system tables. Special retrieval references, such as Add, Total, and Page, do not apply to conditions. |
Comparison values | You can specify a retrieval reference or a specific value in the Comparison Value Two field to define a condition.
Note: If you specify a value in the Comparison Value Two field, you must enter the value using the same format that is used to store the information in the table you specify for the Value One field. |
Sequencing conditions | The system applies conditions to transactions in the order that the conditions appear on the Condition Code Revisions form. You can use the Sequence Number field to resequence the order in which the conditions apply to transactions. When you resequence conditions, the system redisplays the conditions in the appropriate order. Conditions for which you do not assign a sequence number appear before sequenced conditions in the order that they were entered on the form. |
See Also:
Section 38.2, "Defining Retrieval References" for more information about retrieval references,
Appendix D, "Retrieval Reference Codes" for more information about defining retrieval reference codes.