I randomly get some internal error message when posting journal transactions (like 1 in 20 or so). Error is on different requests every time. The same request works fine with 2 or 3 retries. How do we proceed? Visma.Net: POST: https://integration.visma.net/API/controller/api/v2/journaltransaction
Headers: {
Accept: application/json
Authorization: <hidden>
Accept-Encoding: gzip Accept-Encoding: deflate
Request-Id: |gF8GNmNHyO4=.c7571599_14.
Content-Type: application/json; charset=utf-8
Content-Length: 2014
}
{"transactionDate":{"value":"2023-09-01T00:00:00"},"financialPeriod":{"value":"202309"},"ledger":{"value":"1"},"currencyId":{"value":"SEK"},"description":{"value":"hidden"},"createVatTransaction":{"value":true},"skipVatAmountValidation":{"value":true},"journalTransactionLines":[{"operation":"Insert","accountNumber":{"value":"1513"},"transactionDescription":{"value":"hidden"},"debitAmountInCurrency":{"value":5172}},{"operation":"Insert","accountNumber":{"value":"2610"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":0},"vatId":{"value":"23"}},{"operation":"Insert","accountNumber":{"value":"3150"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":3136},"vatCodeId":{"value":"04"}},{"operation":"Insert","accountNumber":{"value":"2610"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":0},"vatId":{"value":"23"}},{"operation":"Insert","accountNumber":{"value":"3150"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":1720},"vatCodeId":{"value":"04"}},{"operation":"Insert","accountNumber":{"value":"2610"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":0},"vatId":{"value":"23"}},{"operation":"Insert","accountNumber":{"value":"3150"},"transactionDescription":{"value":"hidden"},"creditAmountInCurrency":{"value":316},"vatCodeId":{"value":"04"}}]}
Response: 400 Bad Request
Headers: {
Date: Tue, 05 Sep 2023 11:42:50 GMT
Server: Nginx
Strict-Transport-Security: max-age=31536000; includeSubDomains Strict-Transport-Security: max-age=31536000; includeSubDomains
ipp-request-id: 02a7a1a9-ccca-49ed-9237-149d395daaad
X-Content-Type-Options: application/json
Pragma: no-cache
X-Handled-By: Visma-PX.Export/AuthenticationManagerModule
Referrer-Policy: origin-when-cross-origin
VnfInstanceId: ERP_SE_REAL_0045
Cache-Control: no-cache
X-XSS-Protection: 1;mode=block
Set-Cookie: <crumbs>; path=/; secure; expires=Mon, 04-Sep-2023 11:42:49 GMT; HttpOnly
Connection: close
Transfer-Encoding: chunked
Content-Type: application/json; charset=utf-8
Expires: -1
}
{"message":"VismaId: 02a7a1a9-ccca-49ed-9237-149d395daaad. Error creating journal transaction. Cannot insert the value NULL into column 'LedgerID', table 'ERP_SE_REAL_0045.dbo.GLTran'; column does not allow nulls. INSERT fails.\r\nThe statement has been terminated."}
... View more