ML196 – Ledger Report Currency Translation
- System
- Multi-Ledger (ML)
- Type
- Batch program
- Updates
- 17 tables
- References
- 64 tables
ML196 (Ledger Report Currency Translation) is a Lawson Multi-Ledger batch program. It updates ADDRDATA, CKPOINT, CUACCTAU, CUCODESAU, CUCONVAU, CURELATAU, CUTABLEAU, CUTRNSLAU and 9 more and references ACDETAILAU, ACHEADERAU, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU and 56 more.
About ML196
Run Ledger Report Currency Translation (ML196) to translate the company base currency balances to report currency balances. This program compares the ending and period base currency amounts with the report currency amounts. If there are differences between the two amounts, report currency translation updates the balances for the report currencies. For example, if the translation rate increases from 5 to 8 percent, the base currency amount is multiplied by 3 (the percentage change) to update thereport currency amount. The system creates a journal entry to record theadjustments. **Processing Effect The company base currency is translated using the translation table rate defined in CU20.1 (Currency Table Translation Rates) and the translation code defined on CU05.1 (Translation Code). The Rate Type you select for the translation code in CU05.1 affects how the base currency and report currency amounts are translated. If youselected Ending or Historical, the year-to-date amounts are updated. If you selected Average, the amount for the period you select in this form is updated. If your 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 in GL30.1 (Interzone Relationships).
Updated files (17)
| 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 |
| MLCONTROL | Multi Book Ledger Control | ML |
| MLCUCNTRL | Ml Ledger Currency Control | ML |
| MLSYSJE | ML Company Journal Entry | ML |
| MLTRANS | ML Transactions | ML |
Referenced files (64)
| 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 |
| 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 |
| 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 |
| MLAMOUNTS | Multi-Book Ledger Amounts | ML |
| MLCALMAP | Multi-Book Ledger Calendar Map | ML |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| MLCUAMOUNT | ML Ledger Currency Amount | 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 |
| TRCODES | Translation Codes | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (11)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU