Define combinations of one or more entities, fields, and corresponding user-defined fields to populate values for a segment of a GL accounting code.
-
Select Administration > Setup > GL Accounting Setup.
-
Click New Record.
-
Select the Organization for the entity, and then specify this information:
Segment Entity - Select the entity for which to populate value combinations for segments and source fields. Some entity options include:
-
Requisitions
-
Work Orders
-
Booked Hours
-
Purchase Orders
-
CU Estimates
-
Compatible Units of CU Estimates
Segment - Select the segment of the account code o be populated based on the selected source field(s) and segment value field(s).
-
-
Specify this GL Accounting Setup Details information:
Level 1 Source Field - Specify the level 1 source field.
This field defines the primary field to be considered when populating values on the Account Detail tab for a record of the segment entity.
For example, a GL accounting setup record for account code Segment 01 having Level 1 Source Field defined as CU Estimates - Organization would indicate that the organization of a CU estimate record is used to determine the value to be populated for Segment 01 in the account detail record.
Level 1 Segment Value - Specify the level 1 segment value.
The optional Level 1 Segment Value defines the specific field from the Level 1 Source Field record that contains the value to be populated into the account detail record.
Continuing the above example, a GL Accounting Setup record for account code Segment 01 having Level 1 Source Field defined as CU Estimates - Organization as well as Level 1 Segment Value defined as User Defined Field 03 would indicate that the value of User Defined Field from the corresponding Organization of the CU Estimate would be populated for Segment 01 in the account detail record.
Level 2 Source Field - Specify the level 2 source field.
The optional Level 2 Source Field defines a secondary field to be considered when populating values on the Account Detail tab for a record of the segment entity; if no value is specified in the Level 1 Source Field on a segment entity record for which account detail is to be populated.
For example, if the GL accounting setup record for the Requisition lines entity specified Level 1 Source Field as Requisition line – Part, it might also be useful to define the Level 2 Source Field as Requisition line – Trade, since requisition lines can specify either a part or a trade.
Level 2 Segment Value - Specify the level 2 segment value.
This field defines the specific field from the Level 2 Source Field record that contains the value to be populated into the account detail record.
Level 3 Source Field - Specify the level 3 source field.
The optional Level 3 Source Field defines a third field to be considered when populating values on the Account Detail tab for a record of the segment entity; if no value is specified in the Level 1 Source Field or in the Level 2 Source Field on a segment entity record for which account detail is to be populated.
Level 3 Segment Value - Specify the level 3 segment value.
This field defines the specific field from the Level 3 Source Field record that contains the value to be populated into the account detail record.
-
Click Save Record.