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. 



Navigation


To navigate to the GL Account Detail with Legal Entity Report, click 'My Reports' in the Accounting Module and select 'Financial' in the top header. 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

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

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

9) Run Button - Runs the report



Report Columns



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

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

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