User Profile
Gert-Jan van der Kamp
52
Posts
2
Kudos
4
Solutions
20-01-2025
14:41
Never mind see that the format should be MMYYYY in te docs, not sure why this did work in other db. Tried to delete question but that option is missing.
... View more
20-01-2025
13:58
Hi, I'm posting invoices to a particular period (first open one) but the api seems to react differently depending on the user. When I send his dto, it posts correctly, but when the user tries the same dto on a prod database they get an error: "Error: HTTP 400 : BadRequest\r\n{\"message\":\"Error creating supplierInvoice. Error: An error in processing of field Post period value 20-2413 General ledger error: The financial period is not found in the system." We didn't feed it 20-2413 but 202413 like you can see below. It seems the api adds a - and then confuses itself? We got that period from the period column from v1/financialperiod.. Thing is, on another test database it worked fine for me, is this a server setting maybe? DTO: POST https://integration.visma.net/API/controller/api/v1/supplierinvoice { "documentType": { "value": "Invoice" }, "hold": { "value": false }, "date": { "value": "2024-10-29T00:00:00Z" }, "origInvoiceDate": { "value": "2024-10-29T00:00:00Z" }, "postPeriod": { "value": "202413" }, "supplierReference": { "value": "***" }, "description": { "value": "***" }, "supplierNumber": { "value": "30805" }, "currencyId": { "value": "USD" }, "branchNumber": { "value": "BBBB" }, "supplierTaxZone": { "value": "IMPEXP" }, "taxCalculationMode": { "value": "Gross" }, "paymentMethod": { "value": "8" }, "cashAccount": { "value": "20080" }, "invoiceLines": [ { "operation": "Insert", "transactionDescription": { "value": "Chat GPT" }, "costInCurrency": { "value": 20 }, "accountNumber": { "value": "47300" }, "vatCodeId": { "value": 99 }, "branch": { "value": "BBBB" } } ] }
... View more
19-11-2024
11:53
Hi all, A client wants to have their expenses and payment synced in original currency. I created a supplierinvoice for 20 USD, but when I want to add a supplierPayment for 20 USD and link that to the si I just created I get this error: "Error: HTTP 400 : BadRequest\r\n{\"message\":\"Error creating payment. Customer error: The entry must be less than or equal to 17.58.\"}" Where that 17.58 is the 20 USD converted to EUR by Visma. Here is my call, there is no currency field on SupplierPaymentAdjustmentUpdateDto so how should I create this payment? POST https://integration.visma.net/API/controller/api/v1/supplierpayment { "type": { "value": "Payment" }, "overrideNumberSeries": { "value": true }, "hold": { "value": false }, "applicationDate": { "value": "2024-10-21T00:00:00Z" }, "supplier": { "value": 30016 }, "paymentMethod": { "value": "8" }, "cashAccount": { "value": "20080" }, "currency": { "value": "USD" }, "description": { "value": "OPENAI *CHATGPT SUBSCR \\ HTTPSOPENAI.C US" }, "paymentAmount": { "value": 20 }, "branch": { "value": "1" }, "paymentLines": [ { "operation": "Insert", "documentType": { "value": "Invoice" }, "refNbr": { "value": "200448" }, "amountPaid": { "value": 20 } } ] }
... View more
08-07-2024
17:38
Hi, I'm getting a 500 error when trying to create a PurchaseOrder, is there any way I can see more details for this VismaId like with the Connect debugger? This doesn't provide much detail how to fix the error. Error: HTTP 500 : InternalServerError {"message":"VismaId: ed8061a0-eda8-4b19-8e8e-29177a5f5d7b. Error creating purchaseOrder. Object reference not set to an instance of an object."} at http (C:\Users\Gert-JanvanderKamp\source\modules\http.js:38:48) -> let res = xlc.http(verb, uri, j, hds, auth).Result at Script [131] [temp]:9:15
... View more
21-06-2024
17:08
Also tried adding publicId when creating the segment but that gets ignored.
... View more
21-06-2024
16:59
Hi, we're facing the same issue, even after adding the segment value, we still get a 1202-SegmentValueNotFound. Adding segment value: PUT https://integration.visma.net/API/controller/api/v1/dimension/subaccount/3 { "segmentValues": [ { "operation": "Insert", "value": "PRR2412012", "description": { "value": "bla bla bla" }, "active": { "value": true } } ] } When I do GET https://integration.visma.net/API/controller/api/v1/dimension/subaccount/3 I can see it in there: ... { "segmentId": 3, "valueId": "PRR2412012", "description": "bla bla", "active": true, "timeStamp": "AAAAABKyDVs=", "lastModified": "2024-06-21T16:36:48.17" }... What I do notice is that this does not have a publicId like other Segments: { "segmentId": 3, "valueId": "PRS000099", "description": "PRS000099", "publicId": "2a068d56-9c27-453d-8798-bd99e6070f0c", "active": true, "timeStamp": "AAAAABHsjho=", "lastModified": "2024-02-14T16:02:05.653" } When I pick another Segment that is Active and has a publicId it does work.. Could that explain it? Which is weird because when I pull the segements through /v1/dimension/subaccount it is in there and active.
... View more
20-06-2024
16:20
FYI running into the same issue. When we use the VismaNetErp api it accepts unknown segment values if validation was turned off, but the SalesOrder API does not. We'll do the workaround to check/add explicitly before we write.
... View more
20-06-2024
11:47
1 Kudo
Sorry never mind must have been cross-eyed yesterday night I see the ETag now. Can;t delete this post.
... View more
20-06-2024
11:27
Hi all, Right now the ETag header is only returned for GET requests, but (the latest) is required for PATCH and POST. When I need to update an order that leads to the following flow: GET /api/v3/SalesOrders/${OrderType}/${OrderId} // get whole order just for etag header PATCH /api/v3/SalesOrders/${OrderType}/${OrderId} // use etag to update Order GET /api/v3/SalesOrders/${OrderType}/${OrderId} // get etag header again DELETE /api/v3/SalesOrders/${OrderType}/${OrderId} /lines?lineIds=1,2,3,4,5 // use etag to delete lines GET /api/v3/SalesOrders/${OrderType}/${OrderId} // get etag header again POST /api/v3/SalesOrders/${OrderType}/${OrderId} /lines // use etag to insert lines Doing a full get is a bit wasteful and introduces added calls/latency. Could you guys include the ETag header in the reply for POST, PATCH and DELETE? Ideally also include a HEAD to get it without getting the full Order. That could shorten the flow above to: HEAD /api/v3/SalesOrders/${OrderType}/${OrderId} // get etag header, no data PATCH /api/v3/SalesOrders/${OrderType}/${OrderId} // use etag from above and capture eTAG from reply DELETE /api/v3/SalesOrders/${OrderType}/${OrderId} /lines?lineIds=1,2,3,4,5 // use from above and capture eTAG from reply POST /api/v3/SalesOrders/${OrderType}/${OrderId} /lines // use etag from above That 6 calls would be 4 and smaller ones too, saving round trips and bandwith.
... View more
17-05-2024
11:00
Hi, I'm trying to write (POST, PUT) projects with their attributes, but I don't see attributes in the ProjectUpdateDto.. Just wanted to double check if missed something and writing attributes to projects might be possible after all? Regards Gert-Jan
... View more
13-05-2024
11:22
Hi we just started having this issue again. We'll wait for it to pass but hopefully you can see something in the logs on why this happens? Client id is isv_xlconnect. Rgds Gert-Jan
... View more
25-04-2024
09:58
Hi Marten, It was the lineNbr indeed (that's what I had wrong on the first attempt, they were all 0 so that same line wat overwritten). Thought I'd leave it out and have it assigned but apparently that is part of the PK for the KitSpec lines? All loaded correctly now thx.
... View more
24-04-2024
15:51
Through the API I am able to add Stock Components. Tried adding one with revision STANDAARD2 and get the same error: {"message":"VismaId: 282b14e4-36f5-4759-9da2-391ec9ccb7af. Error creating INKitSpecHdr. Object reference not set to an instance of an object."} POST https://integration.visma.net/API/controller/api/v1/KitSpecifications { "operation": "Insert", "kitInventoryID": { "value": "13.20.00.00.00" }, "revisionID": { "value": "STANDAARD2" }, "isActive": { "value": true }, "allowCompAddition": { "value": true }, "isNonStock": { "value": false }, "stockComponentLines": [ { "operation": "Insert", "compInventoryID": { "value": "13.22.32.15.00" }, "dfltCompQty": { "value": 9 } }, { "operation": "Insert", "compInventoryID": { "value": "13.24.50.75.00" }, "dfltCompQty": { "value": 7 } }, { "operation": "Insert", "compInventoryID": { "value": "14.30.35.00.80" }, "dfltCompQty": { "value": 150 } } ] }
... View more
24-04-2024
14:54
Hi, I'm moving KitSpecifications from and older system to Visma.Net through the API. I was able to add a lot of them, however when reviewing the result I noticed something wrong so I deleted them all through the normal web client (as the is no KitSpecifications delete). If I GET /v1/KitSpecifications it returns 0 records Now I want to post them again but that gives me this error: {"message":"VismaId: 6d80fb70-42e7-49b9-b0b1-4130f903294e. Error creating INKitSpecHdr. Object reference not set to an instance of an object."} I also tried PUT KitSpecifications /id/revision but indeed those are not found. Could you help me out here?
... View more
02-01-2024
11:55
Hi Yildirim, The screen is SM201030.
... View more
22-12-2023
14:08
Hi, I was able to edit Segment Values through the API, now I want to edit the Restriction Groups through the API, but I can;t find anything with that name in the specs.. How can I update the restrictions on Accounts to only allow certain Segment Values through the API?
... View more
13-11-2023
16:15
Contact your hosting partner, they need to add the "Visma.net Financials API access" license to your Visma environment, then you can assign the "API User" role to the user you want to give access to.
... View more
06-10-2023
14:38
Ok issue seems to have resolved itself, all logins work again.
... View more
06-10-2023
11:19
That says 'No Tenant' Users had the role and it worked until yesterday, I checked three different organizations they all have this error now, seems unlikely they would all have removed that role.. Never looked there before, can't say if that had tenants earlier.
... View more
06-10-2023
09:57
Hi our users still can't log in, please respond. Is the authority having an issue, do we need to adopt some changes?
... View more
05-10-2023
14:56
Hi, The authentication against https://connect.visma.com with Authorization Code flow returns an error: Error redeeming code: invalid_tenant / no description It worked fine just an hour ago, don;t think we changed anything. Below is the return URI with the code, it seems to happen in exchanging the code for the token. Not sure what the tenant would be? Tried another Visma organization and got the same error. http://localhost:8888/callback/?code=33xxxD6&scope=email%20profile%20openid%20offline_access&state=awvXn0D8gIy6_xfjoCCh0Q&session_state=DsEL0qVdhqD9H3_AW94rCWdCSoHDfC3HSdgZm81g-84.F095CAC6F1B4C97200856615C1949C28&iss=https%3A%2F%2Fconnect.visma.com
... View more
07-09-2023
11:50
Prefect thx!
... View more
06-09-2023
12:17
Works for me, probably something on your end. Are you using a mainstream browser like chrome/ edge? Try CTRL-F5 to drop the cache. Else I wouldn't be able to help you..
... View more
06-09-2023
10:44
Hi, When I POST a new journal to JournalTransactionV2 the api replies with "" and I can see the newly created journal in screen GL3010PL but it's not yet posted. There is a second method /action/release but that requires a JournalNumber. How do I get the the Number of the newly created journal from the api, so I can release it? Normally you would expect the api to return the newly created journal or at least the autogenerated Number..
... View more
06-09-2023
10:34
Sorry just read this, can't seem to figure out how to only get emails for my own questions. https://integration.visma.net/API-index/
... View more
17-08-2023
16:34
Never mind, I'll delete the clip itself on loom
... View more
17-08-2023
15:12
Indeed user had particular browser (Gener8) that messed with the cookies. Switching him to Chrome fixed the issue. Sorry I didn't spot that.
... View more
17-08-2023
12:58
Sorry accidentally accepted this as the answer again. We deleted all cookies, also logged out. Waiting for a reply from the user to try the Incognito thing.
... View more
17-08-2023
12:32
We couldn't find any popups. Also deleted all cookies from Visma.com, no luck.
Recorded a Loom video to show the issue: [Deleted Link]
Here's the (redacted) uri of the stalled page, the consent stage is all empty for this user for some reason:
https://connect.visma.com/consent?returnUrl=%2Fconnect%2Fauthorize%2Fcallback%3Fresponse_type%3Dcode%26nonce%3D***9g%26state%3DX***CQ%26code_challenge%3Dbs***6kqw%26code_challenge_method%3DS256%26client_id%3Disv_xlconnect%26scope%3Demail%2520profile%2520openid%2520offline_access%2520vismanet_erp_interactive_api%253Aread%2520vismanet_erp_interactive_api%253Adelete%2520vismanet_erp_interactive_api%253Aupdate%2520vismanet_erp_interactive_api%253Acreate%26redirect_uri%3Dhttp%253A%252F%252Flocalhost%253A8888%252Fcallback%252F%26tenant_hint%3Dea5486b4-4325-11ed-88a1-02da9be7b25b
... View more
15-08-2023
12:07
I have a user where the login process does not complete. I send them to the OAuth start uri, but that process does not complete. When he's logged in, it shows the 'blurry background' with no content on it and stalls there, no pending redirects or anything. If he's logged out he does get the login prompt, but after that it again stops at the same point. Not sure what could cause this, we'll monitor if it resolves itself just wanted to report it. GJ
... View more
Activity Feed for Gert-Jan van der Kamp
- Posted Re: PostPeriod on supplierinvoice dependent on database/ user? on Forum in Developers Visma.net. 20-01-2025 14:41
- Posted PostPeriod on supplierinvoice dependent on database/ user? on Forum in Developers Visma.net. 20-01-2025 13:58
- Posted Add SupplierPayment in USD to SupplierInvoice in USD on Forum in Developers Visma.net. 19-11-2024 11:53
- Kudoed Re: Is het mogelijk te een directe link te krijgen naar onderdelen van ERP? for sanderdercksen. 08-09-2024 14:35
- Kudoed Re: Is het mogelijk te een directe link te krijgen naar onderdelen van ERP? for sanderdercksen. 08-09-2024 12:34
- Kudoed Re: Is het mogelijk te een directe link te krijgen naar onderdelen van ERP? for WilcoR. 08-09-2024 11:56
- Kudoed Re: Is het mogelijk te een directe link te krijgen naar onderdelen van ERP? for Elbert Dannenberg. 08-09-2024 11:55
- Posted Debug API errors? on Forum in Developers Visma.net. 08-07-2024 17:38
- Got a Kudo for Re: SalesOrder API POST/PATCH cumbersome because of ETag/If-Match. 24-06-2024 17:21
- Posted Re: Subaccount SegmentValueNotFound on Forum in Developers Visma.net. 21-06-2024 17:08
- Posted Re: Subaccount SegmentValueNotFound on Forum in Developers Visma.net. 21-06-2024 16:59
- Posted Re: Subaccount SegmentValueNotFound on Forum in Developers Visma.net. 20-06-2024 16:20
- Kudoed Re: Subaccount SegmentValueNotFound for Johan_TW. 20-06-2024 16:18
- Kudoed Subaccount SegmentValueNotFound for Johan_TW. 20-06-2024 16:17
- Posted Re: SalesOrder API POST/PATCH cumbersome because of ETag/If-Match on Forum in Developers Visma.net. 20-06-2024 11:47
- Posted SalesOrder API POST/PATCH cumbersome because of ETag/If-Match on Forum in Developers Visma.net. 20-06-2024 11:27
- Posted Write Project Attributes through API? on Forum in Developers Visma.net. 17-05-2024 11:00
- Kudoed Re: Including Attributes when getting multiple Projects for Magnus Johnsen. 17-05-2024 09:03
- Kudoed Including Attributes when getting multiple Projects for ErikW. 17-05-2024 09:03
- Posted Re: Error redeeming code: invalid_tenant / no description on Forum in Developers Visma.net. 13-05-2024 11:22