GL45.1 – Journal Control
- System
- General Ledger (GL)
- Type
- Online screen — form 45
- Updates
- 71 tables
- References
- 82 tables
GL45.1 (Journal Control) is a Lawson General Ledger online screen (form 45, subform 1). It updates ACCOMMIT, ACDETAILAU, ACHEADERAU, ACMXVAL, ACTRANS, ADAMOUNTSX, ADDRDATA, AUMXVALUAU and 63 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 74 more.
About GL45.1
Use Journal Control (GL45.1) to view and maintain the status of journal entries from all Lawson Software systems. From this form, you can release, unrelease, change, delete, backout, and quick post journal entries. You can also define control transaction totals for a journal entry. The control totals must match the system totals before you can release the journal entry. NOTE Use N (Unrelease without AC) in the Function Code field to unrelease the journal entry that has activity information without affecting the related activity transaction. If the changes your are about to make to the GL journal entry must be made to the activity, you must manually change the activity entries in Project Accounting (AC). Use Journal Entry (AC Only) (AC40.1) to make the changes to the activity transactions. **Processing Effect If you use a ProcessFlow system for approving journal entries, journal entries that are greater than or equal to the approval amount defined for the company on the Journals tab in Company (GL10.1) are routed to the ProcessFlow system for approval. These journal entries must be approved before they will be displayed on this form and before they become available for posting. If you remove a hold code, your ID is stored in GLCONTROL.HOLD-REM-OPER,
Updated files (71)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACDETAILAU | CA Alloc Code Detail Audit | GL |
| ACHEADERAU | CA Alloc Code Definition Audit | GL |
| ACMXVAL | AC Trans Attribute Values | AC |
| ACTRANS | Activity Transaction | AC |
| ADAMOUNTSX | Daily GL Amounts for ADB | AD |
| ADDRDATA | Address Code | IF |
| 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 |
| CUACCTAU | CU Account Audit | IF |
| CUAMOUNT | Currency Amount | GL |
| CUAMOUNTX | Currency Amount-Daily | GL |
| CUCODESAU | Currency Codes Audit | IF |
| CUCONTROL | Currency Control | GL |
| CUCONVAU | Currency Exchange Rate Audit | IF |
| CURELATAU | Currency Relation Audit | IF |
| CUTABLEAU | Currency Table Audit | IF |
| CUTRNSLAU | Currency Translation Audit | IF |
| FBBATRANS | No description in the Lawson data dictionary | GL |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| GLACMXVLAU | GL Acct Attribute Value Audit | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLAMOUNTSX | General Ledger Amounts Daily | GL |
| GLAUTMXVAU | GL AU Attribute Template Audit | GL |
| GLCHTDTLAU | Chart Detail Audit | IF |
| GLCNTRLAU | Journal Control Audit | GL |
| GLCONSOL | General Ledger Consolidation | GL |
| GLCONTROL | General Ledger Control | GL |
| GLJELOG | Journal Entry Log | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLMASTERAU | Account Master Audit | IF |
| GLNAMESAU | General Ledger Names Audit | IF |
| GLSEGBLOCK | General Ledger Segment Block | GL |
| GLSYSJE | GL Company Journal Entry | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLSYSTEMAU | GL Company Audit | IF |
| GLTRANS | General Ledger Transactions | GL |
| GLUNITS | General Ledger Units | GL |
| GLUNITSX | General Ledger Units-Daily | GL |
| GTMXVALUAU | JE Attribute Value Audit | IF |
| GTMXVALUE | Attribute Template Value | IF |
| JBKSEQNBR | Journal Book Sequence Number | GL |
| JBOOKHDR | Journal Book Header | IF |
| MXCATDEFAU | Attribute Definition Audit | IF |
| MXELEMNTAU | Attribute Element Audit | IF |
| MXLSTDTLAU | Attribute List Detail Audit | IF |
| MXLSTHDRAU | Attribute List Header Audit | IF |
| MXOBJCAT | Attribute Object | 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 |
| RJBRIDGE | Recurring Journal Bridge | IF |
| RJCNTRLAU | Recurring Journal Ctrl Audit | GL |
| RJCONTROL | Recurring Journal Control | GL |
| RJMXVALUAU | Recurring JE Attr Value Audit | IF |
| RJSCHEDULE | Recurring Journal Schedule | IF |
| SLMXVALUE | PL Attribute Value | SL |
| SLTRANDTL | No description in the Lawson data dictionary | SL |
| SLTRANS | PL Transaction | SL |
| SLTRANSERR | PL Transaction Error | SL |
| SYSTEMCODE | System Code | IF |
| ULPOST | This file is used to store the last posting date and time. | IF |
Referenced files (82)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCOMMIT | Activity Commitments | AC |
| ACCONSOL | Activity Consolidation | AC |
| ACDETAIL | Cost Allocation Detail | GL |
| ACHEADER | Cost Allocation Header | GL |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| 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 |
| AUMXVALDT | This file is used to store the effective date values for attribute unit attributes. | IF |
| AUMXVALUE | Acct Unit Attribute Value | IF |
| CAALLOCGRP | Allocation Group | GL |
| CADETAIL | Allocation Detail | GL |
| CAHEADER | Allocation Header | 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 |
| FBFUNDDTL | Budget Fund Detail | 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 |
| GLACCMXVAL | GL Account Attribute Value | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLAUTMPMXV | GL AU Attribute Template | GL |
| GLCBOD | No description in the Lawson data dictionary | GL |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLCOMMIT | GL Commitments | GL |
| GLESACCT | General Ledger Error Suspense | IF |
| GLHOLDCODE | General Ledger Hold Code | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLNAMES | General Ledger Names | IF |
| GLSRCCODE | General Ledger Source Code | IF |
| GLZONE | General Ledger Zone | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JBKOPCODE | Journal Book Operator Code | IF |
| JBKSYSCODE | Journal Book System | IF |
| MACAPDTL | Invoice Distrib Conversion | MA |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXLISTHDR | Attribute List Header | IF |
| MXTMPLDTL | Attribute Template Detail | IF |
| MXTMPLEFDT | Attr Template Effective Date | IF |
| MXTMPLHDR | Attribute Template Header | IF |
| MXTMPLHEDT | Attr Template Header Detail | IF |
| MXVALIDATE | Attribute Validation | IF |
| MXVIEWDTL | Attribute View Detail | IF |
| MXVIEWHDR | Attribute View Header | IF |
| RJMXVALUE | Recurring Journal Matrix Value | IF |
| RWGRPDET | Report Writer Group Detail | GL |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (20)
ACAC, ACTA, API4, GLCC, IFAC, IFAU, IFCU, IFFC, IFGT, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU