|
|
GL167 - Balance Interface
**Form Purpose
Run Balance Interface (GL167) to import the balance interface file for use in
the Lawson system.
**Processing Effect
During the conversion process, all records are edited for errors. When a
record is moved from the General Ledger Balance Interface (GLMASTREL)
(UNIX/Windows) or (DBGLGMR) (iSeries) file to the General Ledger Amounts
(GLAMOUNTS) (UNIX/Windows) or (DBGLGAM) (iSeries) file, the interface file is
deleted, unless errors are found. Non-base currency balances of all types
(transaction, amount, report currency 1 or report currency 2) are moved to the
CUAMOUNT (UNIX/Windows) or DBGLCAM (iSeries) file.
Once the program is run successfully in update mode, all periods, up to (but
not including) the last period, that contain account balance amounts, will be
changed to a Limited Closed status.
**Troubleshooting
Use GL67.1 to correct errors and rerun this program.
**More Information
Run Balance Interface Listing (GL267) to list data in the General Ledger
Balance Interface file before running GL167.
Updated Files
ADDRDATA -
CKPOINT - Used for restart capability.
CUAMOUNT - Updates currency account balances.
CUAMOUNTX - Updated daily report currency account balances.
CUCONTROL -
FBFUNDAMT -
GLAMOUNTS - This file is updated with posting account period balances.
GLAMOUNTSX - The General Ledger Amounts-Daily file contains daily account
balances by accounting unit, account, and subaccount for the
date specified.
GLCODES - Used by common library; not referenced in this program.
GLCONSOL - This file is updated with consolidation account balances.
GLCONTROL - This file is updated with a journal entry to support account
balances.
GLMASTER - This file is used to validate a posting account. This file is
updated if dynamic account generation is used.
GLMASTREL - This file supplies the program with posting account balances.
Records will be deleted from this file when they are converted.
GLSRCCODE - Used by common library; not referenced in this program.
GLSYSTEM - This file is updated with the period close flags.
GLTRANS - This file is updated with posting account transactions to
support converted account balances.
GLUNITS - This file is updated with posting account unit balances.
GLUNITSX - The General Ledger Units - Daily file contains debit and
credit unit balance information by accounting unit, account,
and subaccount for the date specified.
ULPOST - This file stores the last posting date and time.
Referenced Files
CUCODES - Used to validate a currency code.
CUCONV -
CURELAT -
FBDETAIL -
FBFUNDDTL -
FBHEADER -
GLACCTREL - Used to validate account relationships.
GLADDRESS - Used by common library; not referenced in this program.
GLCGCPY -
GLCHART - Used to validate the chart name and determine the
undistributed retained earnings account.
GLCHARTDTL - Used to validate detail accounts.
GLCOMPREL - Used to validate organization relationships.
GLCPYGRP -
GLESACCT -
GLNAMES - Used to validate accounting units.
GLZONE - Used to validate zones.
INSTCTRYCD -
SYSTEMCODE -
WFSETUP -
INVOKED Programs
IFAC
ACAC
ACCL
ACTA
API4
IFCU
IFOB
IFSG
IFLU
IFAU
SLSE
SLSU
|
