|
|
GL70.1 - Recurring Journal
**Form Purpose
Use Recurring Journal (GL70.1) to define and release recurring journal
entries. A recurring journal is a journal entry that occurs more than once,
such as a journal entry for a monthly rent payment, quarterly payroll tax, or
semiannual real estate tax. There are two different types of recurring journal
entries. 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. The entire journal entry process
consists of defining the journal entry, editing, releasing, posting, and if
necessary, closing the period.
**Processing Effect
When you release a journal entry, the journal entry becomes available for
posting to the General Ledger.
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 form tab in Company (GL10.1) are routed to the
ProcessFlow system for approval. These journal entries must be approved before
they become available for posting.
**More Information
After you release the journal entry, there are several programs available to
verify information is correct before posting. Use Recurring Journal Control
(GL75.1) to view journal entries, Transaction Analysis (GL90.1) to view
transaction totals, Account Analysis (GL95.1) to view account information, and
Split Distribution Report (GL238) to create a report that includes recurring
journal entry data that were split distributions. If you included User
Analysis values, use Error Transaction Edit (SL40.1) to view errors or
Strategic Ledger Transaction Analysis (SL90.1) to view user analysis totals.
After you release the recurring journal entry:
- Run Recurring Journal Edit Listing (GL270) to print a detailed listing of
each recurring journal entry for accuracy.
- Run Recurring Journal Interface (GL170) to transfer all recurring journal
entries for posting in the General Ledger system OR use Recurring Journal
Control (GL75) to transfer specific recurring journal entries.
- Run Journal Posting (GL190) to update and summarize company account
balances.
- Run Recurring Journal Closing (GL179) to close the recurring journal
system.
Updated Files
ADDRDATA -
GLCOMMIT -
GLCOMMITX -
JBKSEQNBR -
JBOOKHDR - Used to update the journal book used flag.
RJBRIDGE - Used to validate the interface origin.
RJCONTROL - This file is updated with the last recurring transaction line
number.
RJENCUMB -
RJMXVALUE - This file is updated with a recurring transaction attribute
value.
RJSCHEDULE -
RJTRANS - This file stores the recurring transactions maintained by this
program.
Referenced Files
ACACCTCAT -
ACACCTCATX -
ACACTGRP -
ACACTIVITY -
ACBUDHDR -
ACCAL -
ACCATGRP -
ACCATGRPX -
ACCATSUM -
ACCATSUMX -
ACCOMMIT -
ACTRANS -
CUCONV - Used to validate exchange rates.
CURELAT - Used to validate currency relationships.
FBDETAIL -
FBFUNDAMT -
FBFUNDDTL -
FBHEADER -
GLADDRESS - Used by common library; not referenced in this program.
GLAMOUNTS -
GLCHART - Used by common library; not referenced in this program.
GLCHARTDTL - Used to retrieve account description.
GLCHARTSUM -
GLINTCO - Used to validate intercompany and interzone relationships.
GLMASTER - Used to validate account.
GLNAMES - Used by common library; not referenced in this program.
GLSCCAT - Used to access a source code's associated transaction
attributes.
GLSRCCODE - Used to validate a source code.
GLSYSTEM - Used to validate companies.
GLTRANS -
GLZONE - Used to validate zones.
INSTCTRYCD -
JBKOPCODE - Used to validate a journal book/operator relationship.
JBKSYSCODE - Used to validate a journal book/system code relationship.
MXCATDEF - Used to validate attributes.
MXOBJCAT - Used to validate object type/attribute relationship.
MXVALIDATE - Used to validate a transaction attribute value.
SYSTEMCODE -
GL70.2 - Define Recurring Journal
**Form Purpose
Use Define Recurring Journal (GL70.2) to create and maintain recurring
journal entry header information. Header information applies to all
transaction lines for the recurring journal.
Updated Files
ADDRDATA -
GLCOMMIT -
GLCOMMITX -
JBKSEQNBR -
JBOOKHDR - This file is updated with a journal book used flag.
RJBRIDGE - Used to validate the interface origin.
RJCONTROL - This file stores the recurring journal entry definition
maintained by this program.
RJENCUMB -
RJMXVALUE - This file is updated with deleted transaction attribute
records associated with a deleted recurring journal.
RJSCHEDULE - This file is accessed for interfaced recurring journal entries
to determine the amount to be journalized. The schedule status
is updated by this program.
RJTRANS - This file is updated with deleted records associated with a
deleted recurring journal.
Referenced Files
ACACCTCAT -
ACACCTCATX -
ACACTGRP -
ACACTIVITY -
ACBUDHDR -
ACCAL -
ACCATGRP -
ACCATGRPX -
ACCATSUM -
ACCATSUMX -
ACCOMMIT -
ACTRANS -
CUCONV - Used to validate exchange rates.
CURELAT - Used to validate currency relationships.
FBDETAIL -
FBFUNDAMT -
FBFUNDDTL -
FBHEADER -
GLADDRESS - Used by common library; not referenced in this program.
GLAMOUNTS -
GLCHART - Used by common library; not referenced in this program.
GLCHARTDTL - Used to retrieve account description.
GLCHARTSUM -
GLINTCO - Used to validate zones and intercompany relationships.
GLMASTER - Used to validate posting accounts.
GLNAMES - Used to validate accounting units.
GLSCCAT - Used to validate a source code's transaction attributes.
GLSRCCODE - Used to validate source codes.
GLSYSTEM - Used to validate companies.
GLTRANS -
GLZONE - Used to validate zones.
INSTCTRYCD -
JBKOPCODE - Used to validate a journal book/operator relationship.
JBKSYSCODE - Used to validate a journal book/system code relationship.
MXCATDEF - Used to validate an attribute.
MXOBJCAT - Used to validate an object type/attribute relationship.
MXVALIDATE - Used to validate a transaction attribute value.
SYSTEMCODE -
GL70.3 - Amounts Only
**Form Purpose
Use Amounts Only (GL70.3) to define new recurring journal amounts or units
for each transaction line.
Use this subform when you select the auto zero option when defining your
recurring journal entry.
**Processing Effect
Each time the recurring journal is interfaced to the General Ledger, the
accounts remain but the amounts or units will zero out. Before you can process
the recurring journal entry again, you must add a new amount or units value to
each transaction line.
Updated Files
ADDRDATA -
GLCOMMIT -
GLCOMMITX -
JBKSEQNBR -
JBOOKHDR -
RJBRIDGE - Used to validate their origin of the recurring journal.
RJCONTROL - This file is updated with the recurring entry control amount.
RJENCUMB -
RJMXVALUE - This file is updated with the recurring transaction attribute
value.
RJSCHEDULE -
RJTRANS - This file is updated with the new transaction amounts
maintained by this program.
Referenced Files
ACACCTCAT -
ACACCTCATX -
ACACTGRP -
ACACTIVITY -
ACBUDHDR -
ACCAL -
ACCATGRP -
ACCATGRPX -
ACCATSUM -
ACCATSUMX -
ACCOMMIT -
ACTRANS -
CUCONV - Used to validate exchange rates.
CURELAT - Used to validate currency relationships.
FBDETAIL -
FBFUNDAMT -
FBFUNDDTL -
FBHEADER -
GLADDRESS - Used by common library; not referenced in this program.
GLAMOUNTS -
GLCHART - Used by common library; not referenced in this program.
GLCHARTDTL - Used to retrieve account description.
GLCHARTSUM -
GLINTCO - Used to validate zones and intercompany relationships.
GLMASTER - Used to validate accounts.
GLNAMES - Used to validate accounting units.
GLSCCAT - Used to validate a source code's transaction attributes.
GLSRCCODE - Used to validate a source code.
GLSYSTEM - Used to validate companies.
GLTRANS -
GLZONE - Used to validate zones.
INSTCTRYCD -
JBKOPCODE -
JBKSYSCODE -
MXCATDEF - Used to validate attributes.
MXOBJCAT - Used to validate object type/attribute relationships.
MXVALIDATE - Used to validate a recurring transaction attribute value.
SYSTEMCODE -
GL70.5 - Filter
**Form Purpose
Use Filter (GL70.5) to view totals for a different posting company or zone.
Updated Files
ADDRDATA -
GLCOMMIT -
GLCOMMITX -
JBKSEQNBR -
RJBRIDGE -
RJCONTROL - This file is updated with the last recurring journal comment
line number.
RJENCUMB -
RJSCHEDULE -
RJTRANS - Primary file maintained by this program.
Referenced Files
ACACCTCAT -
ACACCTCATX -
ACACTGRP -
ACACTIVITY -
ACBUDHDR -
ACCAL -
ACCATGRP -
ACCATGRPX -
ACCATSUM -
ACCATSUMX -
ACCOMMIT -
ACTRANS -
CUCONV -
CURELAT - Used to validate currency relationships.
FBDETAIL -
FBFUNDAMT -
FBFUNDDTL -
FBHEADER -
GLADDRESS - Used to validate address information.
GLAMOUNTS -
GLCHART -
GLCHARTDTL -
GLCHARTSUM -
GLMASTER - Used to validate accounts.
GLNAMES - Used to validate accounting units.
GLSYSTEM - Used to validate companies.
GLTRANS -
GLZONE - Used to validate zones.
INSTCTRYCD -
RJMXVALUE -
SYSTEMCODE -
GL70.6 - Recurring Copy
**Form Purpose
Use Recurring Copy (GL70.6) to create a new recurring journal by copying an
existing one and making changes.
Important If the Description Default field of the original recurring journal
entry is J (Journal Header), the new description entered on this form will
default to all the copied lines. If the Description Default field of the
original recurring journal entry is P (Prior Transaction Line), the new
description will be used only for the header; the new detail line descriptions
will be copied from the original detail line descriptions.
Updated Files
ADDRDATA -
GLCOMMIT -
GLCOMMITX -
JBKSEQNBR -
RJBRIDGE -
RJCONTROL - Used to validate journal header information.
RJENCUMB -
RJMXVALUE -
RJSCHEDULE -
RJTRANS - Used to validate transaction detail.
Referenced Files
ACACCTCAT -
ACACCTCATX -
ACACTGRP -
ACACTIVITY -
ACBUDHDR -
ACCAL -
ACCATGRP -
ACCATGRPX -
ACCATSUM -
ACCATSUMX -
ACCOMMIT -
ACTRANS -
CUCONV - Used to validate exchange rates.
CURELAT - Used to validate currency relationships.
FBDETAIL -
FBFUNDAMT -
FBFUNDDTL -
FBHEADER -
GLADDRESS - Used by common library; not referenced in this program.
GLAMOUNTS -
GLCHART - Used by common library; not referenced in this program.
GLCHARTDTL - Used to retrieve account description.
GLCHARTSUM -
GLINTCO - Used by common library; not referenced in this program.
GLMASTER - Used to validate posting accounts.
GLNAMES - Used by common library; not referenced in this program.
GLSCCAT -
GLSRCCODE -
GLSYSTEM - Used to validate companies.
GLTRANS -
GLZONE - Used by common library; not referenced in this program.
INSTCTRYCD -
MXCATDEF -
MXOBJCAT -
MXVALIDATE -
SYSTEMCODE -
INVOKED Programs
ACCL
ACTA
GLCC
IFAC
ACAC
API4
IFCU
IFOB
IFSG
IFLU
IFAU
SLSE
SLSU
IFSC
|
