ML195 – Ledger Translation Calculation
- System
- Multi-Ledger (ML)
- Type
- Batch program
- Updates
- 13 tables
- References
- 65 tables
ML195 (Ledger Translation Calculation) is a Lawson Multi-Ledger batch program. It updates ADDRDATA, CKPOINT, CUACCTAU, CUCODESAU, CUCONVAU, CURELATAU, CUTABLEAU, CUTRNSLAU and 5 more and references ACDETAILAU, ACHEADERAU, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU and 57 more.
About ML195
Run Ledger Translation Calculation (ML195) to translate one company's base currency balance to the base currency of another company for reporting and consolidation. **Processing Effect Information is translated based on the From Company parameters. If the company base currencies are different, the account balances are translated to the consolidation company's base currency, based on the translation rates defined for the currency relationship, translation code, and period applicable to the translation. GL195 also lets you consolidate units. If the To Company uses zone balancing, offset transactions are generated in your transaction gain and loss accounts. Offset transactions are the amount difference between the exchange rate amount and the translation rate amount. Company zone accounts are defined on Interzone Relationships (GL30.1). This program processes the account balance actual amount in the From Company and creates transactions in the To Company. The Translation Level field determines the consolidated level at which the From Company translates to the To Company. If you run this program for a range of periods, the resulting journal entries are created for the last period in the range, or to the current period if the last period is closed. The journal entries have a "CT" source code and a Released status. You must post these journal entries before you close the accounting period for the consolidation period.
Updated files (13)
| 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 |
| GLMASTER | General Ledger Account Master | IF |
| GLMASTERAU | Account Master Audit | IF |
| GLNAMESAU | General Ledger Names Audit | IF |
| GLSYSTEMAU | GL Company Audit | IF |
Referenced files (65)
| 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 |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCOMPREL | GL Organization Relationships | 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 |
| MLAMOUNTS | Multi-Book Ledger Amounts | ML |
| MLCALMAP | Multi-Book Ledger Calendar Map | ML |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| MLCONSOL | Multi Book Ledger Consolidated | ML |
| MLLEDGER | Multi Book Ledger | ML |
| MLUNITS | ML Units | 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 |
| TRCODES | Translation Codes | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (17)
ACAC, ACTA, API4, GLCT, IFAC, IFAU, IFCU, IFLU, IFOB, IFSC, IFSG, IFUP, MLCC, MLFC, MLIT, SLSE, SLSU