Defining general ledger references
Define general ledger reference information for your defined general ledger processes. Define references for each potential group value within a feed process.
To define general ledger references:
- Select Administration > Databridge > GL References.
- Click New Record.
-
Specify this information:
- GL Process Definition
- Specify the general ledger process definition code for which to define general ledger references, e.g., DS Issues.
- Status
- Specify NEW as the status for the feed reference group. Because the journal import processes all new status records and updates Status if an error occurs, all general ledger references must start with a status of new.
- Scheduling Group Value
- Specify the value identifying the general ledger process
group.
Note: Create only one entry for each transaction type. If you selected the column TRL_RTYPE for Scheduling Group Value when defining the general ledger process, you must select I (Issuance), STTK (Stocktakes), etc., when defining the general ledger references.
- Journal Entry Category
- Specify a unique value identifying the ERP journal entry category for the feed reference group, e.g., DS ISSUES. See your organization's financial manager for the correct value.
- Journal Entry Source
- Specify the value identifying the ERP journal entry source for the feed reference group, e.g., INFOR. See your organization's financial manager for the correct value.
- Set of Books ID
- Specify the code identifying the ERP general ledger set of
books for the feed reference group, e.g., 1. See your organization's
financial manager for the correct code. If you use multiple sets of
books, there must be a relationship between the process definition
and the reference group that classifies the correct set of
transactions.
Note: The combination of GL Process Definition, Scheduling Group Value, Journal Entry Category, Journal Entry Source, and Set of Books ID represent the primary key that uniquely identifies the feed reference set for the selected column.
- Financial User ID
- Specify the ERP user ID for the process group, e.g., ERP-USER.
- Currency
- Specify the code identifying the currency for this feed reference group, e.g., USD.
- Actual Flag
- Select one of the following options as the type of ERP batch for this process group:
Option Description Actual Indicates that the values for the batch for this process group are the actual values. Budget Indicates that the values for the batch for this process group are the budgeted values. Encumbrance Indicates that the values for the batch for this group are dependent values. - Click Save Record.
Parent topic: Managing general ledger information
Related topics