MENU
    GL Account Detail with Legal Entity
    • 24 Oct 2024
    • 3 Minutes to read
    • Dark
    • PDF

    GL Account Detail with Legal Entity

    • Dark
    • PDF

    Article summary

    The GL Account Detail with Legal Entity Report runs the system for all General Ledger account details so that the balance of an account can be reconciled over a date range. 

    Users who have access to this report have the ability to email, export, or print this report directly from the reporting window. Click here to learn how to send, export, or print reports.


    To navigate to the GL Account Detail with Legal Entity Report, click 'My Reports' under 'Reports' in the left pane and select 'Financial' in the top header of the reporting window. Once opened, a listing of reports will be shown. 

    Find 'GL Account Detail with Legal Entity' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.


    Report Parameters

    1. Filter By - A listing of all Location categories

    2. Filter - A listing of all Locations within the selected Location category

    3. Start Date - The beginning date of this report

      R365 Best Practice
      Due to the large volume of data in the GL Account Detail with Legal Entity report, it is recommended to run this report in quarterly segments to prevent timeouts and ensure successful exporting of data.

      Users can also use the OData connector for flexible data extraction and reporting.

    4. End Date - The end date of this report

    5. Unapproved - This will either show or hide Unapproved transactions

    6. GL Account(s) - A listing of all GL Accounts

    7. Subtotal by Period - This will allow the option to display the GL Account totals by Period

    8. Include Beginning Balance - This will either show or hide the beginning balance for each GL Account on the report

      For the P&L Accounts, the beginning balance will be set to $0.00 at the start of a Fiscal Year

    9. Subtotal By - This will either subtotal Transactions by Location or list Transactions in chronological order

    10. Transaction Type - The Transaction Types that can be included on the report

    11. Include Stat Accounts - This will either include or exclude Statistical Accounts from the report 

    12. Hide Zero Balances - This will either show or hide zero balances in the report

    13. Exclude GL W/Out Activity - This will either include or exclude GL Accounts in the report that do not have any activity for the date range selected

    14. Group By - This will group the report's details by Location, Account, or neither

    15. Run Button - Runs the report

    Click here to learn more about Report Views and their added functionality.


    Report Columns

    1. GL Account Number - The uniquely-created number affiliated with the GL Account

      Statistical Accounts will be included in the report if selected in the Report Parameters

    2. GL Account Name - The name of the GL Account

      Statistical Accounts will be included in the report if selected in the Report Parameters

    3. Date - The date of the transaction

    4. Legal Entity Name - The name of the Legal Entity that is tied to the Location

    5. Location Number - The uniquely-created number of the Location affiliated with the transaction

    6. Location Name - The name of the Location affiliated with the transaction

    7. Status - This is the status of the transaction (Approved or Unapproved)

    8. Type - The type of transaction (Journal Entry, AP Invoice, ect.)

    9. Document Number - The R365 assigned number listed on the transaction

    10. Vendor Customer - The Vendor or Customer name that connects to the AP or AR transaction, respectively

    11. Line Comment - The comment from the detail line of a transaction

    12. Header Comment - The comment from the header of the transaction

    13. Net Change - The amount of the detail line. Debits are displayed as 0.00 while Credits are displayed as (0.00)

    14. Running Total - A sum of the detail lines grouped by GL Account Number

    When a Retained Earnings account is included in the report, the value of the account from within the selected date range will appear as a line item similar to other accounts. 


    Email, Export, or Print the Report

    This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.


    Was this article helpful?