Astral Reports - V5

Welcome to Online Help

If you still can't find what you're looking for on this help page, please feel free to email us on info@astral365.com

Astral Reports For Business Central is a simple to use Business Central Reporting tool that utilises the power of excel to build powerful dynamic reports based on live data.

Read More Watch Video

The Astral Reports installation program will attempt to install functions into a directory, learn more on what a Codeunit and Web Service is, along with importing Codeunits, Setting up the Web Service and Testing the Connection.

Read More Watch Video

Finding your licence file will give you information on the product, software version and of course all details to you license form.

Read More Watch Video

Astral Reports For Business Central has been designed using the 'ENG' language code. It has been designed so that the end user can localise the text if desired.

Read More Watch Video

The Options form allows the user to configure Astral Reports for Language, Authentication type, Data set age and Business Central service URL.

Read More Watch Video

How to find your login details, the icons and how to test the connection to the Business Central service.

Read More Watch Video

Guidance on how to use Design Mode.

Read More Watch Video

Using the 'Get Table' function in the ribbon allows you draw into your report any set of Dimension values you wish to populate from any Dimension code.

Read More Watch Video

Using the Dimension Set ID Filter & Amount in Excel with Astral Reports.

Read More Watch Video

Using the Dimension Set Budget Amount in Excel with Astral Reports.

Read More Watch Video

Finding the recalculate icon on the Astral Reports ribbon and learning how to recalculate the Business Central functions on the work sheet.

Read More Watch Video

Learn how to let others view your reports without the other users having Astral Reports installed on their PC.

Read More Watch Video

Sometimes, a chart of accounts might contain many account codes, but only certain account codes are relevant to certain departments/projects. Learn how to hide contents in a row.

Read More Watch Video

The 'Get Table' macro will quickly populate the current column with a list from Business Central. Learn how to run this macro.

Read More Watch Video

The Generic Function has been included to provide access to every field within every table. If your reseller has added additional fields or entirely new tables, Astral Reports For Business Central can report on these fields.

Read More Watch Video

Business Central filters can be supplied to the functions via the formula parameters. The normal Business Central rules apply to these filters.

Read More Watch Video

If you experience any issues within your Astral Reports, come here to find troubleshooting options that should solve any issue you may have.

Read More Watch Video

Astral Reports provides the capability of creating complex reports for multiple companies on one report. The Get tables function allows the user to create criteria keys or complex reports without having to manually type each parameter.

Read More Watch Video

The Drilldown function allows you to understand the entries that make up a particular ledger.

Read More Watch Video

How to retrieve Additional Reporting Currency for more than one company within the database.

Read More Watch Video

This function will return the first day of the next month for the date supplied to the parameter. Learn about hints and what the parameters are.

Read More Watch Video

How to adjust dates in Excel using Astral Reports.

Read More Watch Video

Example Reports

Please contact us with any issues, we are here to help!

Videos

The Installation Process

P&L by Department

Trial Balance

First Of Next Month

Using Drilldown

Creating A Chart Of Accounts

Creating A Connection For SaaS

Additional Reporting Currency

Using Design Mode

Chart of Accounts with Dimension

Adjust Date

Dimension Set ID Filter & Amount

Dimension Set Budget Amount

Learn how to use Business Central

Learning videos brought to you by Dynamics 365 University - online learning for Microsoft Dynamics 365 Business Central

Visit Dynamics 365 University