GL Account Detail

1

Account

A listing of all GL Accounts. Users can select one or multiple accounts to include in the report.

2

Parent

This Account Only: When selected, child accounts will not be included in the report.

Include Subaccounts: When selected, child accounts will be included in the report.

3

Filter By

Filter options for the report:

• Location

• Legal Entity

• Location Group

• Location Reporting Category

4

Filter

A list of filter options, determined by the 'Filter By' category selected (#3).

5

Start Date

First date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates.

R365 Best Practice

Due to the large volume of data in the GL Account Detail 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.

6

End Date

7

Show Unapproved

Yes: Unapproved transactions will be included in the report.

No: Unapproved transactions will not be included in the report.

8

Calendar

Displays GL Account details based on the selected calendar: Fiscal or Operational.

Learn more about Fiscal Years.

9

Sum by Transaction

Yes: Transactions will be summed and displayed as one line on the report. When selected, the header comment of the transaction will be displayed instead item/line comments.

No: Transactions will not be summed and each line item from each transaction will be displayed individually on the report. When selected, the report will use the setting selected for the ‘Show Comment or Item’ (#17) to determine what details to display.

10

Subtotal By

Location: Transactions will be displayed and subtotaled in groups by location.

Company: Transactions will be displayed and subtotaled in groups by company (vendor and/or customer).

None: Transactions will not be grouped or subtotaled.

11

Show Comment / Location / #

Abbreviates or shows the full name for each field.

12

Balance

The Typical option will show a positive balance, while the DR (+)/ CR (-) will show the true balance.

13

Include Stat Accounts

Yes: Statistical accounts will be included in the report.

No: Statistical accounts will not be included in the report.

14

Exclude GL W/Out Activity

Yes: GL accounts without activity will not be included in the report.

No: GL Accounts without activity will be included in the report.

15

Hide Zero Balances

Yes: GL accounts with a 0.00 balance will not be displayed.

No: GL accounts with a 0.00 balance will be displayed.

16

Calculate to 4 Decimals

Yes: The debit, credit, and balance columns will be calculated to four decimal points.

No: The debit, credit, and balance columns will be calculated to two decimal points.

17

Show Comment Or Item

When Sum by Transaction - No (#9) is selected, this setting is used to determine whether to display the detail line item or detail line comment.

18

View Options

19

Run

Date

The GL date of the transaction.

Type

The type of transaction.

Ref. Number

The identifying number of the transaction. Users can click the hyperlink to open the transaction in a new tab.

Company

The name of the vendor or customer associated with the transaction.

Location

The location associated with the transaction.

Comment/Item

The comment or item associated with the transaction.

When sum by transaction is set to yes, the header comment of the transaction will be displayed in this column.

When sum by transaction is set to no, the detail line item or comment will be displayed in this column.

Debit

The amount posted to the selected GL account as a debit.

Credit

The amount posted to the selected GL account as a credit.

Balance

The running total of the selected GL account based on the debit and credit entries within the specified reporting period. The balance reflects the account’s financial position at a given point in time, considering its starting balance and subsequent transactions.

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.