Transferring balances and transactions from other application servers

Note: You will not be able to drill back to subsystem data that does not get transferred to the target application server.

You can consolidate financial information for a General Ledger company that processes General Ledger transactions on more than one application server by transferring balances and transaction data. This process creates summarized balance information on the target application server for each posting account for a fiscal year. Use this procedure to transfer period balance data or transaction data.

Note: Balances come from the General Ledger Consolidation (GLCONSOL (for UNIX/Windows) DBGLGCN (for IBMi)) file. Transaction data comes from the Currency (CUAMOUNT (for UNIX/Windows) DBGLCAM (for IBMi)) file, General Ledger Units (GLUNITS (for UNIX/Windows) DBGLGLU (for IBMi)) file, or both.
  1. Run Consolidation Unload (GL141) to create a work file of the data that you want to transfer. Use these guidelines to specify the field values:
    Company

    Specify or select the company number that you are consolidating financial information for.

    Company Group

    Specify or select the company group that you are consolidating financial information for. A Company Group is an optional parameter that lets you run batch programs for a group of companies instead of just one company at a time. A company group represents one or more General Ledger companies. Company groups are set up in GL11.1.

    Periods

    You can consolidate financial information in a specific period range. Specify or select the beginning and ending period.

    Fiscal Year

    Specify any fiscal year that you want to transfer transactions or balances from.

    Interface Option

    Select whether to transfer balances or transactions.

    Type

    Select whether the balances or transactions are processed as Amounts only, Units only, or Both.

    Consolidate Level

    Select the consolidation level to use to capture balances. For example, if level 2 is selected, all levels lower than level 2 will be rolled up into the level 2 summary accounting unit. If there is a posting accounting unit above the level selected, it will not be included and a whole company will not be captured.

    If you choose to summarize data using GLCONSOL and you have non-base transaction amounts, then these values will not be maintained. The transaction amount and the transaction currency will default to the base amount and base currency. If the data contains transaction currency amounts, then you need to use the level 5 posting option to maintain the integrity of the amounts.

    Accounting Unit

    If you are consolidating at the company level, then you must select the accounting unit where you want to store information. This is the posting accounting unit in the destination.

  2. The program creates this work file:

    For UNIX:

    $LAWDIR/ productline/work/gl141D/gl141D

    For Windows:

    %LAWDIR%\ productline\work\gl141D\gl141D

    For IBMi:

    LAWDIR / productline/work/gl141D/gl141D

    Note: The program always assigns the same work file name. Ensure that you process work files created by previous GL141 runs before running the program again.
  3. Move the work file to the target application server.

Follow-up tasks

  • Interface the data to the General Ledger application. Use the basic procedure for interfacing data, incorporating the specific programs and files designated for interfacing balances or transactions. See Interfacing data into General Ledger.