BC-GL-RT5 GL Transaction Details

Applies to

• Product version: Velixo NX
• ERP: Dynamics 365 Business Central
• Functional area: Financials, Other
• Plan: All
• Template type: Production Report template

TABLE OF CONTENTS

• Applies to
• Description
• Coverage
• Typical audience
• Features
• Preview
• Download this template
• Documentation
  • Filters
  • General Ledger Transaction Details report
• User Guide
  • Using the report
• Version History

Description

The BC-GL-RT5 GL Transaction Details report is a comprehensive financial document that provides detailed information on General Ledger transactions within a specific period. The report is essential for auditing, financial analysis, and ensuring accuracy of financial records, which user can use to trace individual transactions and verify validity and correctness.

Coverage

This workbook includes the following sample reports:

• GL Transaction Details: the GL Transaction Details report contains all the transactions extracted from Dynamics 365 Business Central
• Options: the template's settings sheet that is use for data validation lists and various lookups and configurations
• Information: the information sheet of the report, used for storing useful details about the reports such as: code, version, article link, to keep track of the origin of the report

Typical audience

The typical users of this type of report are Finance professionals: Accountants, CFOs, Controllers 

Features

The following features are used by this report. To use this report, please ensure that your Velixo license includes all of them, (or contact Support or Sales):

• List functions
• Query functions

Preview

Download this template

Template will be available for download soon

💡Having trouble downloading the file?

Simply right-click on the link and select Save Link As

Documentation

The BC-GL-RT5 GL Transaction Details report offers a detailed breakdown of all transactions within the General Ledger, including dates, account numbers, descriptions, amounts, and reference numbers. Its user-friendly interface ensures effortless execution, providing comprehensive insights into the financial activities and status of each account with minimal effort.

Filters

Located in the upper left of the sheet, the filters include:

• From & To account: the account code or range of codes to pull relevant transaction details
• From & To date: the date filter to enable user to select a specific time frame for which to view the transaction details
• Dimensions: lists all dimensions present in Dynamics 365 Business Central instance

These filters are seamlessly linked to the data on the Options tab.

Note: The dimension list updates dynamically based on the number of dimensions configured in your instance. However, the template can process a maximum of 10 dimensions per company. If your instance includes more than 10 dimensions, please contact Velixo Support for assistance.

General Ledger Transaction Details report

The report is created to gather all important basic information for a GL detailed report. It is organized in a table and includes the following key details:

• Account number
• Posting date
• Document number
• Type
• Entry number
• Description
• Dimensions
• Debits and Credits
• Total amount

User Guide

Using the report

Now that we've covered the report overview, let's dive into a step-by-step guide on effectively utilizing the report.

• Set the Connection name on the Options sheet: crucial for all processes, set the Connection Name on the Options sheet by updating cell A2. Ensure it matches the name used during Velixo application login.

• Update the Options Sheet: As the foundation for filters on the GL Transaction Details report sheet, keep the Options sheet up to date. It should always and automatically capture the latest dimensions and structures from your Dynamics 365 Business Central instance.

• Choose Desired Filters: after updating the Options sheet, select desired filters for the report:
  • From & To account
  • From & To date
  • Dimensions

• Automatic Report Update: selecting any filter will automatically update report balances. Begin analyzing the report with the latest data.

Version History