GL40.1 – Journal Entry
- System
- General Ledger (GL)
- Type
- Online screen — form 40
- Updates
- 69 tables
- References
- 81 tables
GL40.1 (Journal Entry) is a Lawson General Ledger online screen (form 40, subform 1). It updates ACCOMMIT, ACDETAILAU, ACHEADERAU, ACMXVAL, ACTRANS, ADAMOUNTSX, ADDRDATA, AUMXVALUAU and 61 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 73 more.
About GL40.1
Use Journal Entry (GL40.1) to define and release journal entries. Each journal entry must have at least one transaction line. There are two types of journal entries: Normal and Intercompany. A Normal journal entry lets you manually define the debits and credits for one company while an Intercompany journal entry lets you create a journal entry between different companies. You can also use an intercompany journal entry to define one transaction line. **Processing Effect When you release an entry, the system automatically logs your user ID and creates balancing entries according to the relationship defined inIntercompany Relationships (GL25.1). The entire journal entry process consists of defining the journal entry, editing, releasing, posting, and if necessary, closing the period. **Troubleshooting BUDGET EDIT ERRORS You may receive an unexpected budget edit error, even after setting the Budget Edit field to No for the accounting unit, account combination on Account Options (GL20.3). If you have a Budget Edit Group defined on FB11, the system ignores the Budget Edit field onGL20.3. If you do not want one of your accounting unit, account combinations to edit, you must remove the accounting unit, account from the budget edit group on FB11.
More information: SPLIT DISTRIBUTIONS You can also create a split distribution to distribute a transaction line amount over several periods. For example, if you pay rent or services in advance for one year, you can use the split distributionfeature to post part of the prepaid amount from your prepaid expense account to the actual expense account for each period. When you define a split distribution, the system distributes the transaction line amount evenly to each period you select in GL38.1. You can then adjust the scheduled amounts. To define arecurring entry, choose the More button and then the Recurring button; or use Recurring Journal (GL70.1). A UTOMATIC REPORT CURRENCY BALANCING For automatic report currency balancing to take place the Auto Reverse field must be set to Yes on AdditionalInformation (GL40.4) and on Define Journal (GL40.2). VERIFYING JOURNAL ENTRIES BEFORE POSTING After you release a journal entry, there are several programs available to verify information is correct before posting. Use Journal Analysis (GL41.1) or Journal Control (GL45.1) to view journal entries, Journal Entry Log (GL42.1) to view errors, orTransaction Analysis (GL90.1) to view transaction totals. If you include user analysis values, use Error Transaction Edit (SL40.1) to view errors and StrategicLedger Transaction Analysis (SL90.1) to view user analysis totals. QUICK POSTING You can also Quick Post a Normal journal entry to simulate posting a journal entry using GL45.1. This updates account balances. Thechanges only appear in General Ledger and Report Writer reports. If needed, you can back out and change the quick-posted journal entry to correct errors before posting or just run GL190 to post the journal entry. BACKPOSTING You can backpost a journal entry to create additional entries in a prior period. This lets you correct past entries, reclassify a previous entry, or correct a financial statement. To allow backposting, the period must be closed with a Limited Close status and then reopened. ATTACHMENTS Use the Attachment feature to define additional comments or URL to link the journal entry to a document (for example, Word) or E-mail the file. USER ANALYSIS Use the Define (F6) feature in the User Analysis field to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction.
Updated files (69)
| 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 |
| 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 |
Referenced files (81)
| 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 |
| 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