invantive documentation
Invantive Support ForumsLog In / Sign Up

GeneralLedgerBalancesV2: Visma.net Financials General Ledger Balances

popular read only REST

  • Catalog: VismaNet
  • Schema: GeneralLedgerBalanceV2
  • Label: General Ledger Balances

Get a range of General Ledger Balances. Complete documentation can be found under 8.21 release notes. Please use a page size lower or equal to the allowed max page size which is returned under metadata. If pagesize is greater than the max page size, it will be limited to max page size.

Can only retrieve data.

API Source

  • Endpoint: /v2/generalLedgerBalance
  • Operation: get /v2/generalLedgerBalance

Performance Characteristics

Characteristic Value
Average access latency (ms) 111
Full scan rows per minute 54,500
Point query rows per minute 387

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
account `` Account to retrieve balance for
balanceType `` Balance Type of the ledger to be exported (Values: Actual, Report, Statistical, Budget)
branch `` Branch to retrieve balance for
excludeYTDAccount ``
lastModifiedDateTime `` This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Mandatory if 'PeriodId' is not provided. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF
ledger `` Ledger to retrieve balance for
periodId `` Period to retrieve balance for. Mandatory if 'LastModifiedDateTime' not provided. Format: 'yyyyMM'
subaccount `` Subaccount to retrieve balance for
toggleBalanceSigns `` Parameter can be used in order to change the balance sign for liability and income accounts

Table Columns

The columns of the table GeneralLedgerBalancesV2 are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
COMPANY_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
account_description varchar2 Account Description filters on the platform, writable, account.description Name of item/description
account_externalCode1 varchar2 Account External Code 1 filters on the platform, writable, account.externalCode1 ExternalCode1 is deprecated, please use ExternalCode1Info instead.
account_externalCode1Info_description varchar2 itgen_vnet_account_externalcode1info_description filters on the platform, writable, account.externalCode1Info.description Name of item/description
account_externalCode1Info_number varchar2 itgen_vnet_account_externalcode1info_number filters on the platform, writable, account.externalCode1Info.number Number of item
account_externalCode2 varchar2 Account External Code 2 filters on the platform, writable, account.externalCode2 ExternalCode2 is deprecated, please use ExternalCode2Info instead.
account_externalCode2Info_description varchar2 itgen_vnet_account_externalcode2info_description filters on the platform, writable, account.externalCode2Info.description Name of item/description
account_externalCode2Info_number varchar2 itgen_vnet_account_externalcode2info_number filters on the platform, writable, account.externalCode2Info.number Number of item
account_glConsolAccountCD varchar2 itgen_vnet_account_glconsolaccountcd filters on the platform, writable, account.glConsolAccountCD
account_number varchar2 Account Number filters on the platform, writable, account.number Number of item
account_type varchar2 Account Type filters on the platform, writable, account.type
balanceType varchar2 Balance Type filters on the platform, writable, balanceType
beginningBalance double itgen_vnet_beginningbalance filters on the platform, writable, beginningBalance The total account balance at the start of the selected period.
beginningBalanceInCurrency double itgen_vnet_beginningbalanceincurrency filters on the platform, writable, beginningBalanceInCurrency The total account balance in the currency of the selected account at the start of the selected period.
branch_name varchar2 Branch Name filters on the platform, writable, branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number filters on the platform, writable, branch.number Click the magnifier. > The identifier.
currencyId varchar2 Currency ID filters on the platform, writable, currencyId
errorInfo varchar2 Error Message filters on the platform, writable, errorInfo
financialPeriod varchar2 Financial Period filters on the platform, writable, financialPeriod The financial period to which the transactions recorded in the document should be posted. Format YYYYMM.
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime
ledger_description varchar2 Ledger Description filters on the platform, writable, ledger.description Click on the magnifier. > The description.
ledger_id varchar2 Ledger ID filters on the platform, writable, ledger.id Click on the magnifier. > The identifier.
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, metadata.totalCount
periodToDateCredit double itgen_vnet_periodtodatecredit filters on the platform, writable, periodToDateCredit The total of all credit movements for the selected period.
periodToDateCreditInCurrency double itgen_vnet_periodtodatecreditincurrency filters on the platform, writable, periodToDateCreditInCurrency The total of all credit movements in the currency of the selected account for the selected period.
periodToDateDebit double itgen_vnet_periodtodatedebit filters on the platform, writable, periodToDateDebit The total of all debit movements for the selected period.
periodToDateDebitInCurrency double itgen_vnet_periodtodatedebitincurrency filters on the platform, writable, periodToDateDebitInCurrency The total of all debit movements in the currency of the selected account for the selected period.
subAccountCd varchar2 itgen_vnet_subaccountcd filters on the platform, writable, subAccountCd [This field has been deprecated and will be removed in future versions. Use 'subaccount.subaccountNumber' instead.] This field has been deprecated and will be removed in future versions. Use 'subaccount.subaccountNumber' instead.
subaccountId varchar2 itgen_vnet_subaccountid filters on the platform, writable, subaccountId [This field has been deprecated and will be removed in future versions. Use 'subaccount.subaccountId' instead.] This field has been deprecated and will be removed in future versions. Use 'subaccount.subaccountId' instead.
subaccount_subaccountId int32 Sub Account ID filters on the platform, writable, subaccount.subaccountId The internal SubID identifier of the subaccount.
subaccount_subaccountNumber varchar2 Sub Account Number filters on the platform, writable, subaccount.subaccountNumber The subaccount number / code. Format 9-XX.
yearClosed char itgen_vnet_yearclosed filters on the platform, writable, yearClosed True when the last period of a financial year is closed in all modules.
yearToDateBalance double itgen_vnet_yeartodatebalance filters on the platform, writable, yearToDateBalance The total account balance at the end of the selected period.
yearToDateBalanceInCurrency double itgen_vnet_yeartodatebalanceincurrency filters on the platform, writable, yearToDateBalanceInCurrency The total account balance in the currency of the selected account at the end of the selected period.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: