We have vouchers in 2025. They can be found (as shown in Missing Fortnox-table for VoucherRows of a voucher ) using the query: select vse.code , fyr.FromDate , vle.VoucherNumber , vcr.Voucher_ReferenceNumber , vcr.Voucher_ReferenceType , vcr.Voucher_TransactionDate , v…

The same holds for instance for: select * from VouchersByVoucherSeries('B') where year(TransactionDate) != 2024 Also returns no rows. As an alternative, I have tried to retrieve them using a manually crafted URL over the secured connection: insert into NativePlatformScalarRequests@fnx ( url )…

The default behaviour of APIs seems to be that the last complete financial year or something alike is used.

I had the same problem but I found a workaround by creating a view in the Startup SQL: create or replace force view CurrentVouchers as select vce.TransactionDate , vce.Description , vle.Account , vle.Credit , vle.Debit , vle.Description from Vouchers (12 ) vce j…

Same result/issue here select * from Vouchers V gives me results for 2025, current year only. The number of records in the result matches the number of vouchers in the Accounting/Vouchers in the Fortnox webUI, for the current accounting year, 2025. select * from Vouchers V where V.Year = 2…

My understanding is that you have to give the fiscal year as a parameter in the query. Have you tried: select * from Vouchers(26)

Ah yes, it works. That means Invantive language is not passing the parameter select * from Vouchers where Year = 26 is not the same as select * from Vouchers(26) [Capture d’écran 2025-02-12 à 09.48.09] May be this is something Invantive is willing to improve since Fortnox API only giv…

It is planned to add functionality as described in Parameters in addition to the current implementation which is solely based on Swagger/OpenAPI specification. There is currently no planned date; focus is currently on disentangling US-based components and Invantive UniversalSQL Server sneak preview …

In release 24.0.633, available on Invantive Cloud, extensions have been made that allow multiple years to be retrieved in one query. Starting release 24.0.634, the views Vouchers and VoucherLines will reflect these: Fortnox Vouchers across all Years select fyr.Id YearId , fyr.FromDate YearSta…

Related to the problem might be that Fortnox uses the fiscal year as a selector in the user interface, simiar to Visma AccountView: [image]

Manglende bilag fra 2025 i Bilag på Fortnox

Spørsmål (en)

Emne		Svar	Visninger
Missing Fortnox-table for VoucherRows of a voucher Vragen (en) invantive-cloud , fortnox	3	48	mars 12, 2025
Get Fortnox vouchers + voucher lines script Ideeën invantive-cloud , fortnox	0	36	juni 4, 2025
Extract transactions of specific Fortnox general ledger account Vragen (en) invantive-sql , fortnox	2	49	august 27, 2025
Retrieving financial periods from Visma Net Vragen (en) invantive-cloud , visma-net	14	573	desember 2, 2022
No rows shown in Fortnox when user has no authorisation Wiki (en) invantive-sql , fortnox	0	7	januar 22, 2026

Manglende bilag fra 2025 i Bilag på Fortnox

Related topics