Astral Reports

The most user friendly Excel Reporting tool for Dynamics 365 Business Central

  • Effortlessly integrates with Excel - Harness the dimensional analysis already in Dynamics 365 Business Central within Excel.
  • Save time when creating reports - Astral Reports gives you access to pre-built reports that harness over 170 predefined functions.
  • Easily link to Business Central - Easily pull data from Business Central to populate reports.

Powerful yet effortless reporting

Astral Reports for Business Central is a simple to use yet powerful Excel based reporting tool, created specifically to extract data from Microsoft Dynamics 365 Business Central. Now you have the ability to report from 'any table' and 'any field', straight out-of-the-box. Even custom ones.

The functions have been designed specifically for 'high level reports', such as Balance Sheet, Profit & Loss or Management Accounts. These are typically summary level reports that do not require vast amounts of transactional data to be extracted from the system. The functions utilise the 'Flowfield' technology within Dynamics 365 Business Central, and as such, each function is tuned to retrieve data from the system in an efficient manner. They do not attempt to perform complex queries using inefficient keys, and will therefore not place a large burden on the performance of the database server.

Once installed the functions will be visible in three places. Firstly a new 'Astral Reports' Menu Ribbon will appear on the toolbar, secondly, a new function category 'Astral Reports' will appear in the Insert Function wizard, and finally, the cell Right-Click menu will contain two additional options.

Course curriculum

  • 1

    Astral Reports for Business Central

    • Profit & Loss by Department

    • Additional Reporting Currency

    • Using Drilldown Function

    • Trial Balance

    • Creating A Chart Of Accounts Report

    • Creating A Connection To Business Central

    • First Of Next Month

For more information on Astral Reports visit: