Opening balance in Fortnox

[she20]

What table can I use to retrieve the opening balance of a general ledger account?

I have tried

select *
from   AccountOpeningQuantitiesByAccountNumber(6200) aoy

but this table returns no row, whatever account number I put in the query.

[sda]

Would you rather use Fortnox.Accounts.AccountByNumber ?

[forums]

See also:

Faster way to retrieve account balances on Fortnox

I am using the following view to retrieve the account balances: create or replace view AccountActiveBalances as select act.Number AccountNumber , act.Description AccountDescription , act.Active AccountActive , act.Year AccountYear , anr.Account_BalanceBroughtForward BalanceBroughtForward , anr.Account_balanceCarriedForward BalanceCarriedForward from Accounts@fnx act join Fortnox.Accounts.AccountByNumber@fnx(act.number) anr where act.Active = true But it is very sl…

In release 24.0.728 and newer, the view AccountActiveBalances will be available.

Performance improvements are being studied.