It seems that I am getting an error with my startup SQL since today. Haven’t changed anything, and worked last week still. Queries via the UniversalSQL do work, so it has to be this. See below. Does anyone know what I should do? [image]

It is recommended to correct the query. At least the table function GeneralLedgerBalancesV2 no longer accepts company as described in: [image] Migrating from Visma.net ERP Integrations (VNI) to Visma Connect for Visma.net Wiki (en) Visma is consolidating appl…

Complete information Is it possible to add a (anonymized) screenshot of the request details in Invantive Bridge Online Monitoring as described in More insight with new Bridge Online Monitoring ? Details can be found by clicking on the download request which represents the issue discussed in this top…

itgenboe074 De opstart-SQL-statements van de database hebben een gebruikersfout veroorzaakt, lees de rest van deze fout aandacht door. Onbekende tabel ‘FINANCIALPERIODS’. Mogelijke geldige alternatieven: FinancialPeriodStatistics. Neem s.v.p. contact op met de ontwikkelaar van de opstart-SQL. …

Thanks. Is it possible to add the statements from the SQL Startup here?

use all; create or replace view GeneralLedgerBalancesAll as select fpd.COMPANY_CODE , fpd.COMPANY_NAME , fpd.year , fpd.period , gle.* except gle.financialPeriod, gle.company_code, gle.company_name from FinancialPeriods fpd join GeneralLedgerBalancesV2(fpd.company_code, fpd.…

Thanks for the suggestion! I have discarded the query. The error is gone. Another error occurs, see Itgenboe024 Onbekende tabel 'VismaNet.Account.Accounts@vnt' .

My startup SQL to Visma.net on Accounts@vnt

Vragen (en)

Topic		Replies	Views
Internal Server Error Vragen (alle) invantive-cloud , visma-net	1	22	3 August 2026
Itgenboe024 Onbekende tabel 'VismaNet.Account.Accounts@vnt' Vragen (alle) invantive-cloud , visma-net	2	20	11 June 2025
Visma.net table SalesOrders not accessible Vragen (en) invantive-cloud , visma-net	24	67	19 October 2026
Table FINANCIALPERIODS not found in Visma.net connection Vragen (en) invantive-cloud , visma-net	6	19	31 October 2024
Startup SQL ignored? Vragen (alle) exact-online , invantive-cloud	2	10	12 September 2026

My startup SQL to Visma.net on Accounts@vnt

Related topics