|
|
IC130 - General Ledger Interface
**Form Purpose
Run General Ledger Interface (IC130) to update the General Ledger File with
inventory transactions processed in the Inventory Control (IC), Purchase Order
(PO), Requisitions (RQ), and Warehouse (WH) applications. This form produces
three reports, the General Ledger Transaction Register, General Ledger Posting
Report, and the General Ledger Summary Posting Report.
**Processing Effect
The General Ledger Transaction Register provides an audit trail of all
inventory transactions, such as issues, receipts, and transfers created in IC,
as well as the inventory transactions created by purchase order receipts and
adjustments and inspection rejections.
The General Ledger Posting Report lists the general ledger transactions
created as a result of these transactions and prints in company, posting date,
document type, accounting unit, and account number sequence.
The General Ledger Summary Posting Report summarizes totals for the company,
accounting unit(s) and general ledger account(s) and lists general ledger
transaction in company, intercompany, accounting unit, and posting date
sequence.
This form requires you to print reports in report or update mode and specify
a post through date. If you print in report mode you can review general ledger
transactions before they are updated to the general ledger interface file.
Otherwise, you can update the general ledger file immediately.
This form only posts transactions with a general ledger posting date less
than or equal to the specified post through date. The general ledger posting
date indicates which general ledger period to post transactions. If the
posting date is earlier than the current general ledger period, transactions
backpost if the appropriate general ledger period is open. Otherwise,
transactions post to the current general ledger period. If the posting date is
later than the current general ledger period, transactions remain on the
general ledger file until the appropriate general ledger period becomes
current.
For Retail Financial Reporting
As records are processed in IC130, they are checked against the MAFRXEXP
table to determine if that record needs to be processed for Retail Financial
Reporting. If it does, the PULL-FOR-FR-FL (UNIX/Windows) or PLFRFL (iSeries)
field on MMDIST (UNIX/Windows) or DBPOMMD (iSeries) is set to Y. Only type PO
and PT records are processed for Retail Financial Reporting. Then run Build IC
Financial Reporting File (IC131) to extract these records for use in your
non-Lawson retail system.
Updated Files
ADDRDATA -
CKPOINT - This file is used in the event of a program or system failure
to enable a batch update program to continue from where it left
off.
ICCOMPANY - Used to validate the company number.
ICHISTORY - The Transaction History file contains the history of an item's
inventory transactions summarized by transaction type and
period or year.
ICTRANS - Contains all the inventory transactions entered in the
Inventory Control system.
ITEMLOC - The Item Location file contains the dynamic information for an
inventoried item at a stock location.
MMDIST - This record holds an account number and possibly an activity
code intended for a general ledger distribution of an inventory
item.
MMUAVAL -
SYSTEMCODE - This file contains system code information used for remote
site processing.
Referenced Files
AMASSET - Used to validate the asset numbers maintained in the Asset
Management system.
AMTEMPLATE - Used to validate the asset template numbers maintained in the
Asset Management system.
APCOMPANY -
APVENGROUP -
BUYER -
CUCONV - This file maintains rate tables for each defined currency
relationship.
CURELAT -
GLADDRESS - This file contains the name, address, and communication
numbers for the company and needed accounting units.
GLCHART - This file contains chart and system account information in the
General Ledger system.
GLCODES -
GLINTCO - This file contains interzone and intercompany relationships.
GLSYSTEM - This file contains company information used primarily by the
General Ledger system, but is also referenced by Lawson
subsystems.
ICBIN -
ICCATEGORY -
ICLOCATION - Used to validate the inventory location.
INSTCTRYCD -
ITEMMAST - The Item Master file stores static information about each item
such as description, classes, units of measure, and weight.
ITEMSRC -
MACOMPANY -
MAFRXREF -
POLINE -
PORECADJLN -
PORECLINE -
PORETURNHD -
PORETURNLN -
PURCHORDER -
REQLINE -
INVOKED Programs
API4
ACAC
ACCL
ACTA
IFCU
IFAC
IFAU
IFOB
IFSG
SLSE
SLSU
IFLU
IFFC
IFGT
GLCC
IFRS
IFSC
SLSB
SLSS
IFJR
POIF
API3
POIG
POIM
SLFD
|
