User Profile
MortenFlexyBox
6
Posts
0
Kudos
0
Solutions
06-09-2022
13:03
Hi We are using the Inventory api to create and update Inventory Items, however as our system is the system with the Master data and the location where our customer creates new inventory items it would be great if we could fully create and update inventory items and all the Units including the conversion table between units.
... View more
25-05-2022
12:24
Any news ?
... View more
15-05-2022
16:29
Initial GET request to get existing Journal data: GET https://integration.visma.net/API/controller/api/v2/journaltransaction?releasedBatch=False&periodId=202205 HTTP/1.1
Host: integration.visma.net
Authorization: Bearer XXXXXXXXXXXXXXXXXXXXXXX
ipp-application-type: Visma.net Financials
ipp-company-id: 4081739 HTTP/1.1 200 OK
Date: Sun, 15 May 2022 14:24:37 GMT
Server: Nginx
Strict-Transport-Security: max-age=31536000; includeSubDomains
Content-Type: application/json; charset=utf-8
ipp-request-id: 75dd8e87-1b29-4419-9252-6498145dd6da
X-Content-Type-Options: application/json
Pragma: no-cache
X-Handled-By: Acumatica-PX.Export/AuthenticationManagerModule
Referrer-Policy: origin-when-cross-origin
VnfInstanceId: ERP_DK_DEMO_0001
Strict-Transport-Security: max-age=31536000; includeSubDomains
Cache-Control: no-cache,no-cache
Feature-Policy: geolocation 'none'; vr 'none'; payment 'none'; midi 'none'; microphone 'none'; fullscreen 'none'; encrypted-media 'none'; camera 'none'; autoplay 'none';
Expires: -1
X-XSS-Protection: 1;mode=block
Set-Cookie: LegacyUI=0; path=/; secure; HttpOnly,UserBranch=13; path=/; secure; HttpOnly,Locale=TimeZone=GMTE0000U&Culture=en-GB; path=/; secure; HttpOnly,UserDisplayName=; expires=Sat, 14-May-2022 14:24:36 GMT; path=/; secure; HttpOnly
Transfer-Encoding: chunked
1470
[{"module":"ModuleGL","batchNumber":"000012","status":"Balanced","hold":false,"transactionDate":"2022-05-11T00:00:00","postPeriod":"052022","financialPeriod":"202205","ledger":"1","ledgerDescription":"Regnskab","currencyId":"DKK","exchangeRate":1.00000000,"autoReversing":false,"reversingEntry":false,"description":"1111","debitTotal":0.0000,"debitTotalInCurrency":0.0000,"creditTotal":0.0000,"creditTotalInCurrency":0.0000,"controlTotal":0.0000,"controlTotalInCurrency":0.0000,"createVatTransaction":false,"skipVatAmountValidation":false,"lastModifiedDateTime":"2022-05-11T08:06:08.21","branch":"1","journalTransactionLines":[{"lineNumber":2,"accountNumber":"10100","description":"Omsætning Indland","subaccount":{"subaccountNumber":"0","subaccountId":30588,"description":"Ingen","lastModifiedDateTime":"2022-05-06T07:09:18.233","active":true,"segments":[{"segmentId":1,"segmentDescription":"Afdeling","segmentValue":"0","segmentValueDescription":"(Default)"}]},"referenceNumber":"000012","debitAmount":0.0000,"debitAmountInCurrency":0.0000,"creditAmount":400.0000,"creditAmountInCurrency":400.0000,"transactionDescription":"Testing","branch":"1","transactionType":" ","module":"ModuleGL","project":{"id":"X","description":"Non-Project Code."},"quantity":0.000000},{"lineNumber":4,"accountNumber":"10150","description":"Omsætning Indland uden moms","subaccount":{"subaccountNumber":"0","subaccountId":30588,"description":"Ingen","lastModifiedDateTime":"2022-05-06T07:09:18.233","active":true,"segments":[{"segmentId":1,"segmentDescription":"Afdeling","segmentValue":"0","segmentValueDescription":"(Default)"}]},"referenceNumber":"000012","debitAmount":0.0000,"debitAmountInCurrency":0.0000,"creditAmount":-200.0000,"creditAmountInCurrency":-200.0000,"transactionDescription":"Testing","branch":"1","transactionType":" ","module":"ModuleGL","project":{"id":"X","description":"Non-Project Code."},"quantity":0.000000},{"lineNumber":6,"accountNumber":"10100","description":"Omsætning Indland","subaccount":{"subaccountNumber":"0","subaccountId":30588,"description":"Ingen","lastModifiedDateTime":"2022-05-06T07:09:18.233","active":true,"segments":[{"segmentId":1,"segmentDescription":"Afdeling","segmentValue":"0","segmentValueDescription":"(Default)"}]},"referenceNumber":"000012","debitAmount":0.0000,"debitAmountInCurrency":0.0000,"creditAmount":-200.0000,"creditAmountInCurrency":-200.0000,"transactionDescription":"Testing","branch":"1","transactionType":" ","module":"ModuleGL","project":{"id":"X","description":"Non-Project Code."},"quantity":0.000000}],"metadata":{"totalCount":6,"maxPageSize":1000}},{"module":"ModuleGL","batchNumber":"000013","status":"Balanced","hold":false,"transactionDate":"2022-05-15T00:00:00","postPeriod":"052022","financialPeriod":"202205","ledger":"1","ledgerDescription":"Regnskab","currencyId":"DKK","exchangeRate":1.00000000,"autoReversing":false,"reversingEntry":false,"description":"1111","debitTotal":0.0000,"debitTotalInCurrency":0.0000,"creditTotal":0.0000,"creditTotalInCurrency":0.0000,"controlTotal":0.0000,"controlTotalInCurrency":0.0000,"createVatTransaction":false,"skipVatAmountValidation":false,"lastModifiedDateTime":"2022-05-15T16:23:55.647","branch":"1","journalTransactionLines":[{"lineNumber":2,"accountNumber":"10100","description":"Omsætning Indland","subaccount":{"subaccountNumber":"0","subaccountId":30588,"description":"Ingen","lastModifiedDateTime":"2022-05-06T07:09:18.233","active":true,"segments":[{"segmentId":1,"segmentDescription":"Afdeling","segmentValue":"0","segmentValueDescription":"(Default)"}]},"referenceNumber":"000013","debitAmount":0.0000,"debitAmountInCurrency":0.0000,"creditAmount":400.0000,"creditAmountInCurrency":400.0000,"transactionDescription":"Testing","branch":"1","transactionType":" ","module":"ModuleGL","project":{"id":"X","description":"Non-Project Code."},"quantity":0.000000},{"lineNumber":4,"accountNumber":"10150","description":"Omsætning Indland uden moms","subaccount":{"subaccountNumber":"0","subaccountId":30588,"description":"Ingen","lastModifiedDateTime":"2022-05-06T07:09:18.233","active":true,"segments":[{"segmentId":1,"segmentDescription":"Afdeling","segmentValue":"0","segmentValueDescription":"(Default)"}]},"referenceNumber":"000013","debitAmount":0.0000,"debitAmountInCurrency":0.0000,"creditAmount":-200.0000,"creditAmountInCurrency":-200.0000,"transactionDescription":"Testing","branch":"1","transactionType":" ","module":"ModuleGL","project":{"id":"X","description":"Non-Project Code."},"quantity":0.000000},{"lineNumber":6,"accountNumber":"10100","description":"Omsætning Indland","subaccount":{"subaccountNumber":"0","subaccountId":30588,"description":"Ingen","lastModifiedDateTime":"2022-05-06T07:09:18.233","active":true,"segments":[{"segmentId":1,"segmentDescription":"Afdeling","segmentValue":"0","segmentValueDescription":"(Default)"}]},"referenceNumber":"000013","debitAmount":0.0000,"debitAmountInCurrency":0.0000,"creditAmount":-200.0000,"creditAmountInCurrency":-200.0000,"transactionDescription":"Testing","branch":"1","transactionType":" ","module":"ModuleGL","project":{"id":"X","description":"Non-Project Code."},"quantity":0.000000}],"metadata":{"totalCount":6,"maxPageSize":1000}}]
0 REMOVE AND INSERT - this is the one that fails as can be seen PUT https://integration.visma.net/API/controller/api/v2/journaltransaction/000013 HTTP/1.1
Host: integration.visma.net
Authorization: Bearer XXXXXXXXXXXXXXXXXXXXXXXXX
ipp-application-type: Visma.net Financials
ipp-company-id: 4081739
Transfer-Encoding: chunked
Cookie: LegacyUI=0; UserBranch=13; Locale=TimeZone=GMTE0000U&Culture=en-GB
Content-Type: application/json; charset=utf-8
47A
{"transactionDate":{"value":"2022-05-15T00:00:00+02:00"},"description":{"value":"1111"},"branch":{"value":"1"},"journalTransactionLines":[{"operation":"Delete","lineNumber":{"value":2.0},"accountNumber":{"value":"10100"},"branch":{"value":"1"}},{"operation":"Delete","lineNumber":{"value":4.0},"accountNumber":{"value":"10150"},"branch":{"value":"1"}},{"operation":"Delete","lineNumber":{"value":6.0},"accountNumber":{"value":"10100"},"branch":{"value":"1"}},{"operation":"Insert","lineNumber":{"value":7.0},"accountNumber":{"value":"10100"},"project":{"value":"X"},"transactionDescription":{"value":"Testing"},"creditAmountInCurrency":{"value":400.0},"vatId":{},"branch":{"value":"1"}},{"operation":"Insert","lineNumber":{"value":8.0},"accountNumber":{"value":"10150"},"project":{"value":"X"},"transactionDescription":{"value":"Testing"},"creditAmountInCurrency":{"value":-200.0},"vatId":{},"branch":{"value":"1"}},{"operation":"Insert","lineNumber":{"value":9.0},"accountNumber":{"value":"10100"},"project":{"value":"X"},"transactionDescription":{"value":"Testing"},"creditAmountInCurrency":{"value":-200.0},"vatId":{},"branch":{"value":"1"}}]}
0
RESULT: HTTP/1.1 400 Bad Request
Date: Sun, 15 May 2022 14:24:38 GMT
Server: Nginx
Strict-Transport-Security: max-age=31536000; includeSubDomains
Content-Type: application/json; charset=utf-8
ipp-request-id: fb2304f2-f7de-4b92-bf13-a8bce3226afb
X-Content-Type-Options: application/json
Pragma: no-cache
X-Handled-By: Acumatica-PX.Export/AuthenticationManagerModule
Referrer-Policy: origin-when-cross-origin
VnfInstanceId: ERP_DK_DEMO_0001
Strict-Transport-Security: max-age=31536000; includeSubDomains
Cache-Control: no-cache,no-cache
Feature-Policy: geolocation 'none'; vr 'none'; payment 'none'; midi 'none'; microphone 'none'; fullscreen 'none'; encrypted-media 'none'; camera 'none'; autoplay 'none';
Expires: -1
X-XSS-Protection: 1;mode=block
Set-Cookie: LegacyUI=0; path=/; secure; HttpOnly,UserBranch=13; path=/; secure; HttpOnly,Locale=TimeZone=GMTE0000U&Culture=en-GB; path=/; secure; HttpOnly,UserDisplayName=; expires=Sat, 14-May-2022 14:24:37 GMT; path=/; secure; HttpOnly
Connection: close
Transfer-Encoding: chunked
31
{"message":"GL transaction line: '0' not found."}
0
... View more
12-05-2022
07:39
Hi, there are no remaining lines, iam attempting to first delete all lines and then add in some new ones. Pretty much a clean and the add.
... View more
11-05-2022
08:27
Hi Magnus Thanks, however the request iam sending is. Am i using "Delete" wrong - couldnt seem to find any documentation on the different operations? {
"transactionDate": {
"value": "2022-05-11T00:00:00+02:00"
},
"description": {
"value": "1111"
},
"branch": {
"value": "1"
},
"journalTransactionLines": [
{
"operation": "Delete",
"lineNumber": {
"value": 2
},
"accountNumber": {
"value": "10100"
},
"branch": {
"value": "1"
}
},
{
"operation": "Delete",
"lineNumber": {
"value": 4
},
"accountNumber": {
"value": "10150"
},
"branch": {
"value": "1"
}
},
{
"operation": "Delete",
"lineNumber": {
"value": 6
},
"accountNumber": {
"value": "10100"
},
"branch": {
"value": "1"
}
},
{
"operation": "Insert",
"lineNumber": {
"value": 7
},
"accountNumber": {
"value": "10100"
},
"project": {
"value": "X"
},
"transactionDescription": {
"value": "Testing"
},
"creditAmountInCurrency": {
"value": 400
},
"vatId": {},
"branch": {
"value": "1"
}
},
{
"operation": "Insert",
"lineNumber": {
"value": 8
},
"accountNumber": {
"value": "10150"
},
"project": {
"value": "X"
},
"transactionDescription": {
"value": "Testing"
},
"creditAmountInCurrency": {
"value": -200
},
"vatId": {},
"branch": {
"value": "1"
}
},
{
"operation": "Insert",
"lineNumber": {
"value": 9
},
"accountNumber": {
"value": "10100"
},
"project": {
"value": "X"
},
"transactionDescription": {
"value": "Testing"
},
"creditAmountInCurrency": {
"value": -200
},
"vatId": {},
"branch": {
"value": "1"
}
}
]
} ,
... View more
11-05-2022
24:29
Hi It seems there is no way of removing an entire Batch, is that correct ? We have tried deleting rows again in the Batch, however we are currently getting back: {"message":"GL transaction line: '0' not found."} What does this error mean ?
... View more
Activity Feed for MortenFlexyBox
- Posted Allow updating the conversion table on InventoryItems using the API on Ideas in Developers Visma.net. 06-09-2022 13:03
- Posted Re: How to delete a JournalTransactionV2 entry ? on Forum in Developers Visma.net. 25-05-2022 12:24
- Posted Sv: How to delete a JournalTransactionV2 entry ? on Forum in Developers Visma.net. 15-05-2022 16:29
- Posted Sv: How to delete a JournalTransactionV2 entry ? on Forum in Developers Visma.net. 12-05-2022 07:39
- Posted Re: How to delete a JournalTransactionV2 entry ? on Forum in Developers Visma.net. 11-05-2022 08:27
- Posted How to delete a JournalTransactionV2 entry ? on Forum in Developers Visma.net. 11-05-2022 24:29
Visma Finland
Visma Latvia
Visma Netherlands
Visma Norway
Visma Sweden
Visma Developers & Partners
Visma Latin America