Skip to main content

Data Mart API - 2026-11-10

Visma Net ERP Data Mart

In this release:

New query: apHistoricalDataForwardByGroup​

Visma.net ERP stores AP history only for periods with activity. The new apHistoricalDataForwardByGroup query returns one row per financial period for each branch, account, subaccount, currency and supplier, from the first period with activity up to periodsUpTo (default: the current open financial period, or the latest defined period when the calendar does not reach the current date), following the company's financial calendar.

  • A new hasActivity field marks the periods that have an ERP history row. A period without one repeats the previous ending balances, including the open prepayment balance, with revaluedGainLoss 0.
  • Results are paginated by group: pass lastGroupKey back until hasMore is false.
  • With updatedInDataMart, only groups with a changed row are returned, each from its earliest changed period.

The query requires the accounting_read scope, like apHistoricalData. See Balances for every period in the historic payables guide.