Opening balance in Fortnox

[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.