Note: Only Users with the Full Access or Accounting Manager Primary User Role will be able to access Financial reports.



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 Operations 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