ML167 – Ledger Balance Interface
- System
- Multi-Ledger (ML)
- Type
- Batch program
- Updates
- 25 tables
- References
- 62 tables
ML167 (Ledger Balance Interface) is a Lawson Multi-Ledger batch program. It updates ADDRDATA, CKPOINT, CUACCTAU, CUCODESAU, CUCONVAU, CURELATAU, CUTABLEAU, CUTRNSLAU and 17 more and references ACDETAILAU, ACHEADERAU, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU and 54 more.
About ML167
For UNIX/Windows platforms: Run Ledger Balance Interface (ML167) to interface the Multi-Book Ledger Balance Interface file (MLMASTREL) to the Multi-Book Ledger application. MLMASTREL holds period account balances imported from a non-Lawson file. During the interface process, all records are edited for errors. Error-free records are moved to the Multi-Book Ledger Amounts (MLAMOUNTS) file and the Multi-Book Ledger Consolidation (MLCONSOL) file. ML167 causes all periods that have balance amounts, up to (but not including) the last period, to be changed to a Limited Closed status. For System i platforms: Run Ledger Balance Interface (ML167) to interface the Multi-Book Ledger Balance Interface file (DBMLMMR) to the Multi-Book Ledger application. DBMLMMR holds period account balances imported from a non-Lawson file. During the interface process, all records are edited for errors. Error-free records are moved to the Multi-Book Ledger Amounts (DBMLMLA) file and the Multi-Book Ledger Consolidation (DBMLMCN) file. ML167 causes all periods that have balance amounts, up to (but not including) the last period, to be changed to a Limited Closed status. **Troubleshooting If errors exist, use ML67.1 to correct the errors and run ML167 again.
Updated files (25)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUACCTAU | CU Account Audit | IF |
| CUCODESAU | Currency Codes Audit | IF |
| CUCONVAU | Currency Exchange Rate Audit | IF |
| CURELATAU | Currency Relation Audit | IF |
| CUTABLEAU | Currency Table Audit | IF |
| CUTRNSLAU | Currency Translation Audit | IF |
| GLCHTDTLAU | Chart Detail Audit | IF |
| GLCODES | General Ledger Codes | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLMASTERAU | Account Master Audit | IF |
| GLNAMESAU | General Ledger Names Audit | IF |
| GLSRCCODE | General Ledger Source Code | IF |
| GLSYSTEMAU | GL Company Audit | IF |
| MLAMOUNTS | Multi-Book Ledger Amounts | ML |
| MLCALMAP | Multi-Book Ledger Calendar Map | ML |
| MLCONSOL | Multi Book Ledger Consolidated | ML |
| MLCONTROL | Multi Book Ledger Control | ML |
| MLCUAMOUNT | ML Ledger Currency Amount | ML |
| MLCUCNTRL | Ml Ledger Currency Control | ML |
| MLMASTREL | ML Balance Interface | ML |
| MLTRANS | ML Transactions | ML |
| MLULPOST | ML Post Acct Unit Total | ML |
| MLUNITS | ML Units | ML |
Referenced files (62)
| Table | Description | System |
|---|---|---|
| ACDETAILAU | CA Alloc Code Detail Audit | GL |
| ACHEADERAU | CA Alloc Code Definition Audit | GL |
| AMACCTAU | Asset Account Audit | AM |
| AMACCTGPAU | Asset Account Group Audit | AM |
| AMASTTYPAU | Asset Type Audit | AM |
| AMAUGRPAU | AM Accounting Unit Group Audit | AM |
| AMDICT2 | No description in the Lawson data dictionary | AM |
| AMDIVISNAU | AM Division Audit | AM |
| AMSYSOPTAU | No description in the Lawson data dictionary | AM |
| AUMXVALUAU | AU Attribute Value Audit | IF |
| AUMXVLDTAU | AU Attribute Value Edate Audit | IF |
| CAALOCGPAU | Allocation Group Audit | GL |
| CADETAILAU | Allocation Detail Audit | GL |
| CAHEADERAU | Allocation Header Audit | GL |
| CUACCT | Currency Gain and Loss Account | IF |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| CUTABLE | Currency Table | IF |
| CUTRANSL | Currency Translation | IF |
| FBADJCODAU | Budget Adjustment Code Audit | GL |
| FBCNTRLAU | Budget Journal Control Audit | GL |
| FBDETAILAU | Budget Detail Audit | GL |
| FBFNDHDRAU | Budget Edit Group Audit | GL |
| FBHEADERAU | Budget Header Audit | GL |
| FBHSTHDRAU | Budget Version Audit | GL |
| FBINTBUAU | Budget Interbudget Rel Audit | GL |
| FBSPREADAU | Budget Spread Code Audit | GL |
| FBTRANSAU | Budget Transactions Audit | GL |
| GLACCTREL | GL Account Relationships | IF |
| GLACMXVLAU | GL Acct Attribute Value Audit | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLAUTMXVAU | GL AU Attribute Template Audit | GL |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCOMPREL | GL Organization Relationships | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLESACCT | General Ledger Error Suspense | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLZONE | General Ledger Zone | GL |
| GTMXVALUAU | JE Attribute Value Audit | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MACAPDTL | Invoice Distrib Conversion | MA |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| MLLEDGER | Multi Book Ledger | ML |
| MXCATDEFAU | Attribute Definition Audit | IF |
| MXELEMNTAU | Attribute Element Audit | IF |
| MXLSTDTLAU | Attribute List Detail Audit | IF |
| MXLSTHDRAU | Attribute List Header Audit | IF |
| MXOBJCATAU | Attribute Object Audit | IF |
| MXTMPDTLAU | Attribute Template Dtl Audit | IF |
| MXTMPHDRAU | Attribute Template Hdr Audit | IF |
| MXTPEFDTAU | Attr Template EDate Dtl Audit | IF |
| MXTPHEDTAU | Attr Template EDate Hdr Audit | IF |
| MXVALIDAU | Attribute Validation Audit | IF |
| MXVEWDTLAU | Attribute View Detail Audit | IF |
| MXVEWHDRAU | Attribute View Header Audit | IF |
| RJMXVALUAU | Recurring JE Attr Value Audit | IF |
| SYSTEMCODE | System Code | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (12)
ACAC, ACTA, API4, IFAC, IFAU, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU