GL65.1 - Transaction Interface Maintenance Use GL65.1 (Transaction Interface Maintenance) to display and maintain journal entry data you are converting from a non-Lawson environment (a spreadsheet for example) to the Lawson General Ledger system. This form is used to verify your information transferred to the Lawson system correctly. To transfer the non-Lawson file to the target machine, use a transfer utility program (such as the winptxfr or ftp command). When you transfer the non-Lawson file, you rename the file for use in the Lawson system. For example, if you are transferring from Excel, use winptxfr -u filename c:\\Data\\Excel\\excelfilename where filename represents the Lawson file. To view the information in this form, use an Import command, such as (importdb productline GLTRANSREL filename) load the transactions file into the GLTRANSREL (General Ledger Transaction Interface) file, where filename is the name you assigned when you transferred the file to the Lawson system. After you run the Import command, use the Next or Previous form actions to display your data. You must associate the transaction information in this form with an Organization and Account Code. The organization code identifies the Lawson company and accounting unit where the converted transaction information is stored. The account code identifies the Lawson account and subaccount where converted transaction information is stored. Use GL08.1 (Organization Relationship) to define the organization code and GL09.1 (Account Relationship) to define the account code. Run GL165 (Transaction Interface) to load the journal entry transaction information from this form into GL45.1 (Journal Control). Run GL265 (Transaction Interface Listing) to list transaction records before running GL165. Updated Files GLTRANSREL - This file stores the interfaced journal transactions maintained by this program. JBOOKHDR - Used to validate a journal book. Referenced Files CUCONV - Used to validate exchange rates. CURELAT - Used to validate currency relationships. GLACCTREL - Used to validate account 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. GLCOMPREL - Used to validate organization relationships. GLINTCO - Used to validate intercompany relationships. GLSRCCODE - Used to validate source codes. GLSYSTEM - Used to validate companies. 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 attribute/object type relationship. MXVALIDATE - Used to validate an attribute value. GL65.3 - Report Currency Entry Use GL65.3 (Report Currency Entry) to include report currency amounts with the transaction. If a report currency name and code does not appear on this form, use GL10.1 (Company) to define the report currency codes for the company you are converting transactions to. Updated Files None. Referenced Files GLADDRESS - Used to update general ledger address information. GLCHART - This file is updated for chart of accounts. GLSYSTEM - This file updates company information. INVOKED Programs IFAC ACAC IFCR IFSG IFCU IFAU SLSE SLSU IFCC IFSC |