Contents x
    Transaction Detail Export
    • 24 Jan 2025
    • 2 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Transaction Detail Export

    • Updated on 24 Jan 2025
    • 2 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    The Transaction Detail Export displays the transaction history from a specified date range, which can be exported from R365. Users can choose to filter transactions by either transaction date or creation date and have the flexibility to include all transactions or select specific transactions for the report.

    Best Practice

    It is recommended that the date range is broken up into 6 month periods when downloading data to bypass any complications that may occur due to downloading large amounts of data at one time. 

    Navigation

    The Transaction Detail Export is found on the Financial tab of My Reports.

    1. Navigate to My Reports.

    2. At the top of the My Reports screen, select the Financial tab.

    3. Locate the Transaction Detail Export report.

    4. Select Customize to adjust the report parameters before running the report.
      - or -
      Select Run to run the report with the default report parameters.

    Report Parameters

    Parameter

    Description

    1

    Master Date

    Filters the report based on the selected parameter: Transaction date or creation date.

    2

    Start

    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.

    3

    End

    Last 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.

    4

    Filter By

    Filter options for the report:

    5

    Filter

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

    6

    Sum by Trx

    Yes: Transactions will be summed and displayed as one line on the report.

    No: Transactions will not be summed and the detail lines from each transaction will be displayed individually on the report.

    7

    Show Unapproved

    When yes is selected, unapproved transactions will be included in the report.

    8

    Include Stat Accounts

    Yes: Statistical accounts will be included in the report.

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

    9

    Transaction Type

    The selected transaction types that will be included on the report.

    10

    View options

    This section provides options to select, save, edit, or delete a report view.

    11

    Run

    Generates the report. Click the down arrow to the right of the Run button to export, email, or print the report.

    Report Layout

    Column

    Description

    Trx Date

    The date of the transaction.

    Trx Type

    The transaction type (AP invoice, journal entry, bank expense, etc.).

    Trx Number

    The identifying transaction number.

    Trx Company

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

    Acct Name

    The GL account name that is tied to the transaction.

    Acct Number

    The GL Account number that is tied to the transaction.

    Debit

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

    Credit

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

    Location

    The location associated with the transaction.

    Comment

    The comment or quantity per each amount in the transaction details.

    Created on Date

    The date the transaction was created in R365.

    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?
    What's Next