Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GL40


GL40.1 - Journal Entry


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 in
Intercompany
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 on
GL20.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 distribution
feature
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 a
recurring
entry, choose the More button and then the Recurring button; or use Recurring
Journal (GL70.1).
AUTOMATIC REPORT CURRENCY BALANCING For automatic report currency balancing
to take place the Auto Reverse field must be set to Yes on Additional
Information
(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, or
Transaction
Analysis (GL90.1) to view transaction totals. If you include user analysis
values, use Error Transaction Edit (SL40.1) to view errors and Strategic
Ledger
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. The
changes
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

    ACMXVAL    -

    ACTRANS    -

    ADAMOUNTSX -

    ADDRDATA   -

    CUAMOUNT   -

    CUAMOUNTX  -

    CUCONTROL  -

    FBFUNDAMT  -

    GLAMOUNTS  -

    GLAMOUNTSX -

    GLCONSOL   -

    GLCONTROL  -

    GLJELOG    -

    GLMASTER   -

    GLSEGBLOCK -

    GLSYSTEM   -

    GLTRANS    -

    GLUNITS    -

    GLUNITSX   -

    GTMXVALUE  -

    JBKSEQNBR  -

    JBOOKHDR   -

    MXOBJCAT   -

    RJBRIDGE   -

    RJCONTROL  -

    RJSCHEDULE -

    SLMXVALUE  -

    SLTRANDTL  -

    SLTRANS    -

    SLTRANSERR -

    SYSTEMCODE -


Referenced Files

    ACACCTCAT  -

    ACACCTCATX -

    ACACTGRP   -

    ACACTIVITY -

    ACBUDHDR   -

    ACCAL      -

    ACCALX     -

    ACCATGRP   -

    ACCATGRPX  -

    ACCATSUM   -

    ACCATSUMX  -

    ACCOMMIT   -

    CUCONV     -

    CURELAT    -

    FBDETAIL   -

    FBFUNDDTL  -

    FBHEADER   -

    GLADDRESS  -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCODES    -

    GLCOMMIT   -

    GLESACCT   -

    GLINTCO    -

    GLNAMES    -

    GLSRCCODE  -

    GLZONE     -

    INSTCTRYCD -

    JBKOPCODE  -

    JBKSYSCODE -

    MXVALIDATE -

    WFSETUP    -


GL40.2 - Define Journal



Use Define Journal (GL40.2) to define and maintain journal entry header
information.
If you select user analysis values in the journal entry header for a
company, those values default in each transaction line. If you define a Normal
journal entry type and select an account number that has a user analysis
relation
attached in GL40.1, the user analysis value combination you select in GL40.2
must be defined for that relation.





Updated Files

    ACMXVAL    -

    ACTRANS    -

    ADAMOUNTSX -

    ADDRDATA   -

    CUAMOUNT   -

    CUAMOUNTX  -

    CUCONTROL  -

    FBFUNDAMT  -

    GLAMOUNTS  -

    GLAMOUNTSX -

    GLCONSOL   -

    GLCONTROL  -

    GLJELOG    -

    GLMASTER   -

    GLSEGBLOCK -

    GLSYSJE    -

    GLSYSTEM   -

    GLTRANS    -

    GLUNITS    -

    GLUNITSX   -

    GTMXVALUE  -

    JBKSEQNBR  -

    JBOOKHDR   -

    MXOBJCAT   -

    RJBRIDGE   -

    RJCONTROL  -

    RJSCHEDULE -

    SLMXVALUE  -

    SLTRANDTL  -

    SLTRANS    -

    SLTRANSERR -

    SYSTEMCODE -


Referenced Files

    ACACCTCAT  -

    ACACCTCATX -

    ACACTGRP   -

    ACACTIVITY -

    ACBUDHDR   -

    ACCAL      -

    ACCALX     -

    ACCATGRP   -

    ACCATGRPX  -

    ACCATSUM   -

    ACCATSUMX  -

    ACCOMMIT   -

    CUCODES    -

    CUCONV     -

    CURELAT    -

    FBDETAIL   -

    FBFUNDDTL  -

    FBHEADER   -

    GLADDRESS  -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCODES    -

    GLCOMMIT   -

    GLESACCT   -

    GLHOLDCODE -

    GLINTCO    -

    GLNAMES    -

    GLSRCCODE  -

    GLZONE     -

    INSTCTRYCD -

    JBKOPCODE  -

    JBKSYSCODE -

    MXVALIDATE -

    WFSETUP    -


GL40.3 - Speed Entry



    Use Speed Entry (GL40.3) to define multiple journal entry transaction
lines at once. You can define up to 12 detail lines.




Updated Files

    ACMXVAL    -

    ACTRANS    -

    ADAMOUNTSX -

    ADDRDATA   -

    CUAMOUNT   -

    CUAMOUNTX  -

    CUCONTROL  -

    FBFUNDAMT  -

    GLAMOUNTS  -

    GLAMOUNTSX -

    GLCONSOL   -

    GLCONTROL  -

    GLJELOG    -

    GLMASTER   -

    GLSEGBLOCK -

    GLSYSTEM   -

    GLTRANS    -

    GLUNITS    -

    GLUNITSX   -

    GTMXVALUE  -

    JBKSEQNBR  -

    MXOBJCAT   -

    RJBRIDGE   -

    RJCONTROL  -

    RJSCHEDULE -

    SLMXVALUE  -

    SLTRANDTL  -

    SLTRANS    -

    SLTRANSERR -

    SYSTEMCODE -


Referenced Files

    ACACCTCAT  -

    ACACCTCATX -

    ACACTGRP   -

    ACACTIVITY -

    ACBUDHDR   -

    ACCAL      -

    ACCALX     -

    ACCATGRP   -

    ACCATGRPX  -

    ACCATSUM   -

    ACCATSUMX  -

    ACCOMMIT   -

    CUCONV     -

    CURELAT    -

    FBDETAIL   -

    FBFUNDDTL  -

    FBHEADER   -

    GLADDRESS  -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCODES    -

    GLCOMMIT   -

    GLESACCT   -

    GLINTCO    -

    GLNAMES    -

    GLSRCCODE  -

    GLZONE     -

    INSTCTRYCD -

    MXVALIDATE -

    WFSETUP    -


GL40.4 - Additional Information



Use Additional Information (GL40.4) to define additional detail for
each transaction line, override the default information from the journal entry
header, and view the transaction, base, account, and to company currency
information.
You can make currency adjustments to keep the entry in balance.



**More Information

This subform contains the following form tabs to define additional journal
entry information.
Use the Main form tab to assign additional information for the transactions,
including an activity, reference, units, and source code. Within this form
tab you can choose the Recurring button to open Recurring Journal Interface
(GL38.1). Use this subform to process a split distribution for a journal
entry,
such as a journal entry for a monthly rent payment, quarterly payroll tax,
or semiannual real estate tax.
For automatic report currency balancing to take place the Auto Reverse
field must be set to Yes on Additional Information (GL40.4) and on Define
Journal (GL40.2).
Use the Attributes form tab to assign up to three transaction attribute
values in the journal entry. The transaction attributes you can select values
from are defined by source code in Source Code (GL05.1).
Use the Amounts form tab to define transaction currency and amount
information,
including the base, transaction, account, and report currencies.





Updated Files

    ADDRDATA   -


Referenced Files

    GLADDRESS  -

    GLCHART    -

    GLSRCCODE  -

    GLSYSTEM   -

    INSTCTRYCD -


GL40.5 - Filter



    Use Other Totals (GL40.5) to view totals for a different currency,
posting company, or zone.




Updated Files

    ADDRDATA   -


Referenced Files

    GLADDRESS  -

    GLCHART    -

    GLCONTROL  -

    GLSYSTEM   -

    GLTRANS    -

    INSTCTRYCD -


GL40.6 - Journal Copy



Use Journal Copy (GL40.6) to create a new journal entry by copying an
existing one and making changes.





Updated Files

    ADDRDATA   -

    CUCONTROL  -

    GLCONTROL  -

    GLJELOG    -

    GLSEGBLOCK -

    GLSYSJE    -

    GLTRANS    -

    GTMXVALUE  -

    JBKSEQNBR  -

    JBOOKHDR   -

    MXOBJCAT   -

    SLMXVALUE  -

    SLTRANDTL  -

    SLTRANS    -

    SLTRANSERR -


Referenced Files

    CUCONV     -

    CURELAT    -

    GLADDRESS  -

    GLCHART    -

    GLCODES    -

    GLINTCO    -

    GLSYSTEM   -

    GLZONE     -

    INSTCTRYCD -

    JBKOPCODE  -

    JBKSYSCODE -


GL40.7 - Totals



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 the two,


- total debit and credit journal entry units and the difference
between the two,


- total positive and negative detail auto reversing amount and
the difference between the two,


- total positive and negative adjustment amount and the difference
between the two,


- total positive and negative base currency amount and the difference
between the two.


- total positive and negative report currency amounts and the
difference between the two.






Updated Files

    ACMXVAL    -

    ACTRANS    -

    ADAMOUNTSX -

    ADDRDATA   -

    CUAMOUNT   -

    CUAMOUNTX  -

    CUCONTROL  -

    FBFUNDAMT  -

    GLAMOUNTS  -

    GLAMOUNTSX -

    GLCONSOL   -

    GLCONTROL  -

    GLJELOG    -

    GLMASTER   -

    GLSEGBLOCK -

    GLSYSTEM   -

    GLTRANS    -

    GLUNITS    -

    GLUNITSX   -

    GTMXVALUE  -

    JBKSEQNBR  -

    MXOBJCAT   -

    RJBRIDGE   -

    RJCONTROL  -

    RJSCHEDULE -

    SLMXVALUE  -

    SLTRANDTL  -

    SLTRANS    -

    SLTRANSERR -

    SYSTEMCODE -


Referenced Files

    ACACCTCAT  -

    ACACCTCATX -

    ACACTGRP   -

    ACACTIVITY -

    ACBUDHDR   -

    ACCAL      -

    ACCALX     -

    ACCATGRP   -

    ACCATGRPX  -

    ACCATSUM   -

    ACCATSUMX  -

    ACCOMMIT   -

    CUCONV     -

    CURELAT    -

    FBDETAIL   -

    FBFUNDDTL  -

    FBHEADER   -

    GLADDRESS  -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCODES    -

    GLCOMMIT   -

    GLESACCT   -

    GLINTCO    -

    GLNAMES    -

    GLSRCCODE  -

    GLZONE     -

    INSTCTRYCD -

    MXVALIDATE -

    WFSETUP    -


GL40.8 - Journal Entry



Use Journal Entry (GL40.8) to define journal entry transaction lines
one at a time. When you add a new journal entry, you must define header
information
in Define Journal (GL40.2).





Updated Files

    ACMXVAL    -

    ACTRANS    -

    ADAMOUNTSX -

    ADDRDATA   -

    CUAMOUNT   -

    CUAMOUNTX  -

    CUCONTROL  -

    FBFUNDAMT  -

    GLAMOUNTS  -

    GLAMOUNTSX -

    GLCONSOL   -

    GLCONTROL  -

    GLJELOG    -

    GLMASTER   -

    GLSEGBLOCK -

    GLSYSTEM   -

    GLTRANS    -

    GLUNITS    -

    GLUNITSX   -

    GTMXVALUE  -

    JBKSEQNBR  -

    JBOOKHDR   -

    MXOBJCAT   -

    RJBRIDGE   -

    RJCONTROL  -

    RJSCHEDULE -

    SLMXVALUE  -

    SLTRANDTL  -

    SLTRANS    -

    SLTRANSERR -

    SYSTEMCODE -


Referenced Files

    ACACCTCAT  -

    ACACCTCATX -

    ACACTGRP   -

    ACACTIVITY -

    ACBUDHDR   -

    ACCAL      -

    ACCALX     -

    ACCATGRP   -

    ACCATGRPX  -

    ACCATSUM   -

    ACCATSUMX  -

    ACCOMMIT   -

    CUCONV     -

    CURELAT    -

    FBDETAIL   -

    FBFUNDDTL  -

    FBHEADER   -

    GLADDRESS  -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCODES    -

    GLCOMMIT   -

    GLESACCT   -

    GLINTCO    -

    GLNAMES    -

    GLSRCCODE  -

    GLZONE     -

    INSTCTRYCD -

    JBKOPCODE  -

    JBKSYSCODE -

    MXVALIDATE -

    WFSETUP    -


INVOKED Programs

    ACTA
    GLCC
    IFAC
    ACAC
    API4
    IFCU
    IFOB
    IFSG
    IFLU
    IFUP
    SLSE
    SLSU
    IFFC
    IFGT
    IFAU
    IFRS
    IFSC
    SLSB
    SLSS
    SLFD