GL40.1 - Journal Entry Use GL40.1 (Journal Entry) 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. When you release an entry, the system automatically creates balancing entries according to the relationship defined in GL25.1 (Intercompany Relationships). The entire journal entry process consists of defining the journal entry, editing, releasing, posting, and if necessary, closing the period. After you release a journal entry, there are several programs available to verify information is correct before posting. Use GL41.1 (Journal Analysis) or GL45.1 (Journal Control) to view journal entries, GL42.1 (Journal Entry Log) to display errors, or GL90.1 (Transaction Analysis) to view transaction totals. If you include user analysis values, use SL40.1 (Error Transaction Edit) to display errors and SL90.1 (Strategic Ledger Transaction Analysis) to view user analysis totals. 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. If you use a Workflow 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 GL10.1 (Company) are routed to the Workflow system for approval. These journal entries must be approved before they become available for posting. 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. 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. Use the Define (F6) feature in the Usr 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. * Choose the New JE button to define journal entry header information, including the company, fiscal year, period, journal entry number, and a description of the journal entry. * Choose the Speed Entry button to define multiple transaction lines. * Choose the Single Line button to define one transaction line at a time. * Choose the Rpt Curr Entry button to open the Report Currency Entry subform. Use this subform to define a journal entry that only includes report currency amounts or to override report currency transaction amounts. * Choose the Totals button to display totals for the journal entry. Use this subform to determine whether you need to make transaction line adjustments to eliminate differences between transaction amounts and base currency amounts or between debit amounts and credit amounts. * Choose the More button to define additional information for a transaction line or override the default information from the journal entry header. You can run GL240 (Journal Edit Listing) to create a detailed listing of all journal entry transaction information before posting. Updated Files CUCONTROL - This file is used to store transaction currency amounts. GLCOMMENT - This file is updated with changed line information. GLCONTROL - This file is updated with the last journal entry line number used. GLSYSTEM - This file is updated with the GL40 releasing flag. GLTRANS - This file stores the journal entry transactions maintained by this program. GTMXVALUE - This file stores the transaction attribute values maintained by this program. JBOOKHDR - This file is updated with a journal book used flag. MXOBJCAT - This file is updated with an attribute usage count. RJBRIDGE - This file is updated for a transaction line associated with an interfaced recurring journal. RJCONTROL - This file is updated for a transaction line associated with an interfaced recurring journal. RJSCHEDULE - This file is updated for transaction lines associated with an interfaced recurring journal. SYSTEMCODE - This file is updated by a common routine this program will not access. Referenced Files CUCONV - Used to access currency exchange rates. CURELAT - Used to validate currency relationships. GLADDRESS - Used by common library; not referenced in this program. GLCHART - Used to validate the undistributed retained earnings account. GLCODES - Used to validate system codes. GLINTCO - Used to validate intercompany relationships. GLNAMES - Used to validate accounting units. GLSRCCODE - Used to validate source codes. GLZONE - Used to validate zones. JBKOPCODE - Used to validate journal book/operator relationships. JBKSYSCODE - Used to validate journal book/system code relationship. MXVALIDATE - Used to validate transaction attribute values. WFSETUP - GL40.2 - Define Journal Use GL40.2 (Define Journal) 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. Use the Attachment feature do define additional comments or URL to link the journal entry to a document (for example, Word) or E-mail the file. Use the Main form tab to define required information for the journal entry, including information that defaults on transaction lines. You can choose the Copy button to create a new journal entry by copying an existing one. Use the Dates, Currency form tab to define dates associated with the journal entry, including a posting date, and to define currency information for a nonbase currency journal entry. 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 GL05.1 (Source Code). Updated Files CUCONTROL - This file is used to store transaction currency amounts. GLCOMMENT - This file is updated with deleted comment records for deleted journal entry. GLCONTROL - This file stores journal entries maintained by this program. GLJELOG - This file stores a journal entry log for records created by this program. GLSYSJE - Used to access and update the last journal entry number assigned. GLSYSTEM - Used to validate companies. GLTRANS - This file is updated with deleted journal transactions when a journal entry is deleted. GTMXVALUE - This file is updated with deleted transaction attribute records when a journal entry is deleted. JBKSEQNBR - Used to keep track of the next available journal book sequence number. JBOOKHDR - This file is updated with a journal book used flag. MXOBJCAT - This file is updated with an attribute usage count. RJBRIDGE - This file is updated with an originating document released flag. RJCONTROL - This file is updated with a deleted recurring journal when the journal entry is deleted. RJSCHEDULE - This file is updated with deleted interfaced recurring schedule records when a journal entry is deleted. SYSTEMCODE - This file is updated with the last remote site transaction object identification. Referenced Files CUCODES - Used to validate currency codes. CUCONV - Used to validate exchange rates. CURELAT - Used to validate currency relationships. GLADDRESS - Used by common library; not referenced in this program. GLCHART - Used by common library; not referenced in this program. GLCODES - Used to validate system codes. GLHOLDCODE - Used to validate a hold code. GLINTCO - Used to validate intercompany relationships. GLNAMES - Used to validate accounting units. GLSRCCODE - Used to validate source codes. GLZONE - Used to validate zones. JBKOPCODE - Used to validate the journal book/operator relationship. JBKSYSCODE - Used to validate the journal book/system code relationship. MXVALIDATE - Used to validate a journal entry attribute value. WFSETUP - GL40.3 - Speed Entry Use GL40.3 (Speed Entry) to define multiple journal entry transaction lines at once. You can define up to 12 detail lines. Choose the More button to define additional detail for a transaction line. Updated Files CUCONTROL - This file is used to store transaction currency amounts. GLCOMMENT - Used by common library; not referenced in this program. GLCONTROL - This file is updated with a journal entry's last transaction sequence number. GLSYSTEM - Used to validate companies. GLTRANS - This file is updated with journal entry transactions added by this program. GTMXVALUE - This file is updated with journal entry transaction attributes added by this program. MXOBJCAT - This file is updated with an attribute usage count. RJBRIDGE - This file is updated with an interfaced recurring journal maintained by this program. RJCONTROL - This file is updated with an interfaced recurring journal maintained by this program. RJSCHEDULE - This file is updated with an interfaced recurring journal schedule maintained by this program. SYSTEMCODE - This file is updated with a last remote site transaction object identification. Referenced Files CUCONV - Used to validate exchange rates. CURELAT - Used to validate currency relationships. GLADDRESS - Used by common library; not referenced in this program. GLCHART - Used by common library; not referenced in this program. GLINTCO - Used to validate intercompany relationships. GLNAMES - Used to validate accounting units. GLSRCCODE - Used to validate source codes. GLZONE - Used to validate zones. MXVALIDATE - Used to validate attribute values. WFSETUP - GL40.4 - Additional Information Use GL40.4 (Additional Information) 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. 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 GL38.1 (Recurring Journal Interface). 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. 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 GL05.1 (Source Code). Use the Amounts form tab to define transaction currency and amount information, including the base, transaction, account, and report currencies. Updated Files None. Referenced Files GLADDRESS - Used to validate address information. GLCHART - Used to validate the chart of accounts. GLSRCCODE - Used to validate source codes. GLSYSTEM - Used to validate companies. GL40.5 - Comments Use GL40.5 (Comments) to define additional comments for the journal entry. Updated Files GLCOMMENT - This file stores journal entry comments maintained by this program. GLCONTROL - This file is updated with a journal entry's last comment sequence line number. Referenced Files GLADDRESS - Used by common library; not referenced in this program. GLCHART - Used by common library; not referenced in this program. GLSYSTEM - Used to validate companies. GL40.6 - Filter Use GL40.6 (Filer) to display totals for a different currency, posting company, or zone. Updated Files None. Referenced Files GLADDRESS - Used by common library; not referenced in this program. GLCHART - Used by common library; not referenced in this program. GLCONTROL - Used to validate journal entries. GLSYSTEM - Used to validate companies. GLTRANS - Used to access journal entry transaction information. GL40.7 - Journal Copy Use GL40.7 (Journal Copy) to create a new journal entry by copying an existing one and making changes. Choose the Totals button to display totals for the journal entry. Use this subform to determine whether you need to make transaction line adjustments to eliminate differences between transaction amounts and base currency amounts or between debit amounts and credit amounts. Updated Files CUCONTROL - This file is used to store transaction currency amounts. GLCOMMENT - This file stores copied journal entry comment records. GLCONTROL - This file stores the copied journal entry record. GLJELOG - This file stores the journal entry creation audit record. GLSYSJE - This file is updated with the last journal entry number. GLTRANS - This file stores the copied journal entry transaction records. GTMXVALUE - This file stores the copied journal entry transaction attribute value records. JBKSEQNBR - This file is updated with the last transaction posting sequence number. JBOOKHDR - This file is updated with a journal book used flag. MXOBJCAT - This file is updated with an attribute usage count. Referenced Files CUCONV - Used to validate exchange rates. CURELAT - Used to validate currency relationships. GLADDRESS - Used by common library; not referenced in this program. GLCHART - Used by common library; not referenced in this program. GLCODES - Used to validate system codes. GLSYSTEM - Used to validate companies. GLZONE - Used to validate zones. JBKOPCODE - Used to validate journal book/operator relationships. JBKSYSCODE - Used to validate journal book/system code relationships. GL40.8 - Totals Use GL40.8 (Totals) to display totals for the journal entry. Use this subform to determine whether you need to make transaction line adjustments to eliminate differences between transaction amounts and base currency amounts or between debit amounts and credit amounts. If you selected the auto-balancing option for your company currency transactions, select OK to automatically create auto-balancing adjusting entries in the auto-balancing system account. This subform displays the: a) total debit and credit journal entry amount and the difference between the two, b) total debit and credit journal entry units and the difference between the two, c) total positive and negative detail auto reversing amount and the difference between the two, d) total positive and negative base currency amount and the difference between the two. e) total positive and negative report currency amounts and the difference between the two. Choose the Filter button to display totals for a different currency, posting company, or zone. Updated Files CUCONTROL - This file is used to store transaction currency amounts. GLCOMMENT - Used to validate journal entry comments. GLCONTROL - This file is updated with a journal entry processed status. Error journal entry records are created. GLSYSTEM - Used to update company information. GLTRANS - Used to update transactions. GTMXVALUE - This file is updated with auto reversing journal entry transaction attribute values. MXOBJCAT - This file is updated with an attribute usage count. RJBRIDGE - Used to validate the origin of the recurring journal entry. This file is updated with journalized amount totals. RJCONTROL - Used to access recurring journals to be journalized. The last period processed is updated. 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. SYSTEMCODE - This file is updated with the last remote site transaction object identification number. Referenced Files CUCONV - Used to access a currency exchange rate. CURELAT - Used to validate currency relationships. GLADDRESS - Used to validate general ledger address information. GLCHART - Used to validate the existence of a chart of accounts. GLINTCO - Used to validate zone and intercompany relationships. GLNAMES - Used to validate the existence of accounting units. GLSRCCODE - Used to validate source codes. GLZONE - Used to validate zones. MXVALIDATE - Used to validate an attribute's value. WFSETUP - GL40.9 - Journal Entry Line Use GL40.9 (Journal Entry Line) to define journal entry transaction lines one at a time. When you add a new journal entry, you must define header information in GL40.2 (Define Journal). Use the Main form tab to define required information for the journal entry, including information that defaults on transaction lines. Choose the Recurring button to open GL38.1 (Recurring Journal Interface). 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. 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 GL05.1 (Source Code). Use the Amounts form tab define journal entry amount information such as transaction currency, base amounts, account amounts, and the company you are posting information to. Updated Files CUCONTROL - This file is used to store transaction currency amounts. GLCOMMENT - This file is updated with journal transaction change comment records. GLCONTROL - This file is updated with the last journal entry transaction line number. GLSYSTEM - This file is updated with GL40 releasing flag. GLTRANS - This file stores the journal entry transactions maintained by this program. GTMXVALUE - This file stores the journal entry transaction attribute values maintained by this program. JBOOKHDR - This file is updated with a journal book used flag. MXOBJCAT - This file is updated with an attribute usage count. RJBRIDGE - This file is updated with a interfaced recurring journal maintained by this program. RJCONTROL - This file is updated with an interfaced recurring journal maintained by this program. RJSCHEDULE - This file is updated with an interfaced recurring journal schedule maintained by this program. SYSTEMCODE - This file is updated with the last remote site transaction object identification. Referenced Files CUCONV - Used to access currency exchange rates. CURELAT - Used to validate currency relationships. GLADDRESS - Used by common library; not referenced in this program. GLCHART - Used by common library; not referenced in this program. GLCODES - Used to validate a system code. GLINTCO - Used to validate a intercompany relationship. GLNAMES - Used to validate an accounting unit. GLSRCCODE - Used to validate a source code. GLZONE - Used to validate a zone. JBKOPCODE - Used to validate a journal book/operator relationship. JBKSYSCODE - Used to validate a journal book/system code relationship. MXVALIDATE - Used to validate a transaction attribute value. WFSETUP - INVOKED Programs IFAC ACAC IFCR IFSG IFCU IFAU SLSE SLSU IFCC IFFC IFGT IFOB IFRS IFSC SLSB SLTV SLFD SLSS |