Advanced Account Schedules

E Foqus Canada Inc.

Supercharge account schedules with values from any module. Build KPIs directly in account schedules.

With Advanced Account Schedules for Microsoft Dynamics 365 Business Central it’s possible to use values from any module in the system.

Quite often, the biggest shortcoming of the account schedule module is the lack of non-G/L numbers. Getting AR, AP, inventory, even jobs or warehousing. Business Central is filled with all the raw data to build great reports, it only a matter of locating it. Advanced Account Schedules is designed to be able to pull any number or value out of any module and directly into the account schedule, making it possible to create a one-click KPI report, or prepare everything for Excel or PowerBI without having to juggle with multiple data sources.

Draft data is also available in Advanced Account Schedules, making it possible to use quotes, order and even information from journals can be used.

You can select single values or calculate sums and count records in a dataset.


You define an Indicator. The indicator has a Method and table and filters.

Advanced Account Schedules support the following indicator methods:

  • Lookup – Find any single value
  • Sum – Sum all records within a filter of records
  • Count – Count all records within a filter of records
  • Min and Max – The border values within a filter of records
  • Average – Calculate the mean value of all records in a filter
  • Custom – Allow a developer to create custom indicators

Examples of indicators that can be created with Advanced Account Schedules:

  • Number of invoices in a period
  • Mean value of items sold
  • Ageing and due balances from AR and AP
  • Customer count (filtered by regions)
  • Split values on non-posting codes
  • Outstanding quotes
  • Open order
  • Job budget
  • Draft entries in Job Journal

Supported Editions

This app supports the Essential and Premium editions of Microsoft Dynamics 365 Business Central

Supported Countries

This app supports all countries where Business Central is available

Supported Languages

The app is available in Czech (Czech Republic), Danish (Denmark), German (all areas), Spanish (Spain and Mexico), Italian, Icelandic, Dutch (Belgium), Finnish (Finland), French (all areas), Japanese, Korean, Norwegian, Russian, Swedish and English (all areas)

De relance