BKPER_ACCOUNTS
Fetch the (Chart of) Accounts from your Bkper book. Gives you a listing of accounts and groups from your Bkper book:
β=BKPER_ACCOUNTS(bookId, cache, groups, properties)
β
Sample usage
=BKPER_ACCOUNTS("agtzfmJrcGVyLWhyZHITCxIGTGVkZ2VyGICAgKD_4bMLDA", 1, TRUE, FALSE)
Explaining the syntax:
bookId: string - The universal Book Id.
cache: number - Cache-control. Increase to clean cache and force fetch update.
groups: TRUE or FALSE - True to include account groups.
properties: TRUE or FALSE - True to include custom account properties.
β