GL40.7 – Totals
- System
- General Ledger (GL)
- Type
- Online screen — form 40
- Updates
- 68 tables
- References
- 79 tables
GL40.7 (Totals) is a Lawson General Ledger online screen (form 40, subform 7). It updates ACCOMMIT, ACDETAILAU, ACHEADERAU, ACMXVAL, ACTRANS, ADAMOUNTSX, ADDRDATA, AUMXVALUAU and 60 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 71 more.
About GL40.7
Use Totals (GL40.7) to view totals for the journal entry and to determine if you need to make transaction line adjustments to eliminate differences between transaction amounts and base currency amounts or between debit amounts and credit amounts. This subform displays the: - total debit and credit journal entry amount and the difference between thetwo, - total debit and credit journal entry units and the difference between thetwo, - total positive and negative detail auto reversing amount and the differencebetween the two, - total positive and negative adjustment amount and the difference betweenthe two, - total positive and negative base currency amount and the difference betweenthe two. - total positive and negative report currency amounts and the differencebetween the two.
Updated files (68)
| 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 |
| 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 (79)
| 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 |
| 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