Exact Online Connector - AP/AR subledgers at year end?

Questions
,
2

The year or period ultimo figures can easily be retrieved using either

  • pre-defined views such as AROutstandingItemsPerFinancialPeriodUltimo (best used with a filter for the relevant year to improve performance)
  • or directly accessing the table function AROutstandingItemsEx (with Ex standing for “extended”)

Find more information in these topics:

As a sidenote: for reporting / replication purposes, it is recommended to use the *Incremental tables for Items, ...Entries, ...EntryLines and TransactionLines. They are up to 1.000 times faster.

1 like