SRCEXREF General Ledger Source Cross Reference Report

Source Cross Reference Report

Application Overview

 The Source Cross Reference Report details all transactions for a specified period by source code.

 Under each source, the G/L account number, description, transaction date, debit and/or credit amount, and reference are listed for each trans­action.

 Source codes are used to allow easy reference to original journals, registers, etc.

 Example:

 All automatic reversing transactions will be under source code Accrue.  The Source Cross Reference Report will detail all transactions under this code.  This will allow you to easily verify that all entries are properly reversed in the subsequent period.

 All compressed transactions will be under source code COMP (unless the option to compress by source within date, or source within period, was selected for an account, in which case the original sources will be retained).

 If journal history totals are not being used, transactions that were entered automatically using the Interface From Other Packages application will have a source code depending upon the originating package:  ARIN (Accounts Receivable), APIN (Accounts Payable), PRIN (Payroll), JCIN (Job Costing), IMIN (Inventory Maintenance), ADIN and (Assets & Depreciation).

 If journal history totals are being used, the original source journal code will be maintained from each posting and list all transactions under each posting journal.

 Transactions for Balance Sheet accounts resulting from running the Year‑End Procedure application will have the source code

BBF (for balance brought forward).


Run Instructions

 Select Source Cross Reference from the pull down G/L Reports window.  The following screen will then be displayed:

 

 

Source Cross Reference Report Entry Screen

 The following options are available:

    • Select the desired mode from the Source Cross Reference menu bar
    • Enter the data requested on the screen

     To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

     

    Entry Field Descriptions

     

    Name

    Type and Description

    1.  Starting Date

    A date in the standard date format.  Press the RETURN key to default the starting date to that of the starting date of the current period as defined in the Accounting Period File.

    2.  Ending Date

    A date in the standard date format.  Press the RETURN key to default to the ending date of the current period.

    3.  Starting Source

    10 alphanumeric characters.  Enter the starting range of sources to be included, or press F1 to default to All sources.

    4.  Ending Source

    10 alphanumeric characters.  Enter the ending range of sources to be included in the report.

    5.  Print Sources With                   Descriptions Only?

    Y or N.  If you enter Y, the report will display only those sources that have a corresponding description. 

    If you enter N, the report displays sources regardless of whether they have a corresponding description.

     

     

     

     

    Source Cross Reference Report

      

    General Ledger

    1. GLMENU General Ledger Package Overview
    2. My General Ledger Interface with Other Package Is Out of Balance
    3. Can Journal Ledger Be Imported to General Ledger?
    4. Is There a Way to Pull All Manual GL Entries Out of Elliott?
    5. How to Print a Wider Financial Statement
    6. General Journal Transaction Out Of Balance After Interface with AR
    7. How to Archive GL Data Before Year-End Closing Procedure
    8. GL Year-End Closing Checklist
    9. Do I Need to Kick My Users Out When Interfacing with Other Packages in GL?
    10. General Journal Transaction In Balance But Not Able to Post
    11. Net Income from Profit & Loss Statement Does Not Match Balance Sheet
    12. Feature - G/L Interface from Other Package Customer/Vendor/Employee Number/Name Default
    13. Error During GL Interface from Other Package and Journal Transaction Is Lost
    14. COMPRESS General Ledger Processing Compress General Ledger TRX File
    15. GLBUDMNT General Ledger Budget File Maintenance
    16. GLCMPMNT General Ledger Comparative File Maintenance
    17. GLCONSOL General Ledger Company Consolidation
    18. GLCTLMNT General Ledger G/L Setup
    19. GLDSTMNT General Ledger Distribution Code File Maintenance
    20. GLENTMNT General Ledger Financial Entity File Maintenance
    21. GLJNLLST General Ledger Journal History Report
    22. GLPRDMNT General Ledger Accounting Period File Maintenance
    23. GLPRDSCN General Ledger Period Account Balance Report
    24. GLRATSCN General Ledger Financial Ratio Report
    25. GLRECALC General Ledger Recalculate Account Balances
    26. GLRECENT General Ledger Recurring Journal Trx Processing
    27. GLSRCMNT General Ledger Source File Maintenance
    28. GLTRIALB General Ledger Trial Balance Report
    29. GLWRKSHT General Ledger Print General Ledger Worksheet
    30. INTERFAC General Ledger Interface From Other Packages
    31. TEXTMNT General Ledger Statement Text File Maintenance
    32. SRCEXREF General Ledger Source Cross Reference Report
    33. YEAREND General Ledger Year-End Procedure
    34. GLACTMNU General Ledger G/L Account File
    35. GNJINLENT General Ledger General Journal Trx Processing
    36. My Net Income (BSNI) at Balance Sheet Does Not Equal My Net Income on the P&L Statement
    37. Budget File Maintenance Questions & Answers
    38. LAYMNU General Ledger Statement Layout File Maintenance 1
    39. LAYMNU General Ledger Statement Layout File Maintenance 2
    40. LAYMNU General Ledger Statement Layout File Maintenance 3
    41. LAYMNU General Ledger Statement Layout File Maintenance 4
    42. LAYMNU General Ledger Statement Layout File Maintenance 5
    43. LAYMNU General Ledger Statement Layout File Maintenance 6
    44. LAYMNU General Ledger Statement Layout File Maintenance 7
    45. LAYMNU General Ledger Statement Layout File Maintenance: Index
    46. STMNTMNU Select and Print Financial Statements 1
    47. STMNTMNU Select and Print Financial Statements 2
    48. STMNTMNU Select and Print Financial Statements 3
    49. STMNTMNU Select and Print Financial Statements 4
    50. STMNTMNU Select and Print Financial Statements: Index
    51. Job Code Adjustment through GL Journal Entries

    Feedback and Knowledge Base