Excelのバランスフォーミュラ用に総勘定元帳のアカウント範囲を指定する

[forums]

See:

New Excel consolidation options for Exact Online companies and general ledger accounts

Go to Dutch version With Invantive Control, you can easily consolidate and report on general ledger accounts and multiple Exact Online companies. This can be done using hundreds of additional Excel formulas for Exact, but also via mass downloads from more than 1,000 linked Exact APIs. This consolidation and reporting takes place in Excel, but in real time with the most up-to-date financial data from multiple administrations. For EUR 59 per month, you get Exact consolidation for up to 100 admin…

A range can be specified using ‘-’ (dash):

I_EOL_BAL_PDE_CLOSE(; 2020; 1; 12; “8000-8015”)