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:

  1. Select Administration > Databridge > GL References.
  2. Click New Record.
  3. 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.
  4. Click Save Record.
Related topics