CU20.1 – Currency Table Translation Rates
- System
- General Ledger Setup (IF)
- Type
- Online screen — form 20
- Updates
- 11 tables
- References
- 62 tables
CU20.1 (Currency Table Translation Rates) is a Lawson General Ledger Setup online screen (form 20, subform 1). It updates CUACCTAU, CUCODESAU, CUCONVAU, CURELATAU, CUTABLEAU, CUTRANSL, CUTRNSLAU, GLCHTDTLAU and 3 more and references ACDETAILAU, ACHEADERAU, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU and 54 more.
About CU20.1
Use Currency Table Translation Rates (CU20.1) to define and maintain translation rates for a currency relationship and translation code in acurrency table.
More information: Translation rates are used to translate the balances of one company's base currency to the base currency of another company for reporting andconsolidation. This process is commonly performed once per period, after individual companies complete period closing. Translation rates defined on this form are used for all companies associated with the currency table. You can use CU20.3 (Company Translation Rates) to define overriding translation rates for a specific company. To define and maintain translation rates for multiple currency relationships and translation codes for a currency table for a period, choose the Period button to open the Currency Table Period Rate Entry subform. You must select Yes in the Currency Translation field in the Currency form tab on GL10.1 (Company) to translate rates for a company. NOTE If the currency relationship displays as triangulated (as is the case for Euro-bound currencies), you cannot assign a translation rate to that relationship. Instead, you must assign a translation rate between each of the currencies and the triangulation currency (in this case, the Euro). To define a currency relationship as triangulated, use CU02.1 (CurrencyRelationship).
Updated files (11)
| Table | Description | System |
|---|---|---|
| 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 |
| CUTRANSL | Currency Translation | IF |
| CUTRNSLAU | Currency Translation Audit | IF |
| GLCHTDTLAU | Chart Detail Audit | IF |
| GLMASTERAU | Account Master Audit | IF |
| GLNAMESAU | General Ledger Names Audit | IF |
| GLSYSTEMAU | GL Company Audit | IF |
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 |
| FBADJCODAU | Budget Adjustment Code Audit | GL |
| FBCNTRLAU | Budget Journal Control Audit | GL |
| FBDETAIL | Budget Detail | GL |
| FBDETAILAU | Budget Detail Audit | GL |
| FBFNDHDRAU | Budget Edit Group Audit | GL |
| FBHEADER | Budget Header | 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 |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLAUTMXVAU | GL AU Attribute Template Audit | GL |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCONTROL | General Ledger Control | GL |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSBOD | No description in the Lawson data dictionary | GL |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GLTRANSREL | GL Transaction Conversion | GL |
| GLUNITS | General Ledger Units | GL |
| GTMXVALUAU | JE Attribute Value Audit | IF |
| MACAPDTL | Invoice Distrib Conversion | MA |
| 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 |