Search
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Sign In
My Products
Help
Sign in or create account
to get a personalized navigation.
Sign in or create account
to get a personalized navigation.
User Profile
Sander_Feenstra
12
Posts
0
Kudos
0
Solutions
04-03-2024
13:11
Hi Anté, My customer is try'ing to identify this problem together with their reseller. For now let's close this issue. Best regards, Sander
... View more
26-02-2024
13:31
Hi Sandra, Yeah I implemented the new auth method using the interactive API. It's a new customer for which I'll try to post the first invoice using the API. In my ISV test environment I did not get this message, but there I have only one branch with number "1" Additionally when I click the option "Create new invoice" in the front-end. I immediately receive the error: It means something like: "An error occured when processing your request, a report has been sent to support. Please try again later, thanks for your understanding" (Sorry I didn't try this before) I looks like some roles a missing on my user now, what do you say? Kind regards, Sander
... View more
26-02-2024
12:28
Hello There, I'm try'ing to post a customer invoice but received a 400 - bad request with the message: Error: Inserting 'Sales invoice/note' record raised at least one error. Please review the errors. Error: Branch '1 ' cannot be found in the system. The invoice I'm trying to create must be made for branch "4" so I don't understand the complaint about branch 1. See my request below. Any idea? Error requesting: POST "https://integration.visma.net/API/controller/api/v2/customerinvoice"
HTTP error: 400 - Bad Request
message: Error: Inserting 'Sales invoice/note' record raised at least one error. Please review the errors.
Error: Branch '1 ' cannot be found in the system.
Body: {
"branchNumber": {
"value": "4"
},
"overrideNumberSeries": {
"value": true
},
"referenceNumber": {
"value": "9999999"
},
"customerNumber": {
"value": "21827"
},
"documentDate": {
"value": "2024-02-20T00:00:00"
},
"creditTermsId": {
"value": "30"
},
"documentDueDate": {
"value": "2024-03-21T00:00:00"
},
"currencyId": {
"value": "EUR"
},
"externalReference": {
"value": "9999999"
},
"paymentReference": {
"value": "9999999"
},
"hold": {
"value": false
},
"postPeriod": {
"value": "022024"
},
"dontPrint": {
"value": true
},
"dontEmail": {
"value": true
},
"invoiceLines": [
{
"operation": "insert",
"lineNumber": {
"value": 1
},
"description": {
"value": "21827 9999999"
},
"quantity": {
"value": null
},
"manualAmountInCurrency": {
"value": 518.4900
},
"accountNumber": {
"value": "8110"
},
"vatCodeId": {
"value": "1"
},
"subaccount": []
}
],
"taxDetailLines": []
} Best regards, Sander
... View more
08-02-2024
12:31
Based on the reports: "Balance by Customer" / "Balance by Supplier"
... View more
08-02-2024
11:23
Well, signing the monetary amounts would be most appropriate but I don't think (backwards compatibility wise) this is a good idea. Either a sign or a D(ebit) / C(redit) indication could be a solution. See my example below: Could something like that be add to the endpoints: ../CustomerDocument ../Customer/{CustomerCd}/Document ../SupplierDocument ../Supplier/{SupplierCd}/Document Please also look a my previous post, didn't get a clear answer on that one. https://community.visma.com/t5/Forum-in-Developers-Visma-net/How-to-retrieve-detailed-outstanding-balances/m-p/635363/highlight/true#M4686 Best regards, Sander
... View more
29-01-2024
17:20
Right, setting a default subaccount did the trick. Can you explain? Why can I leave it empty at all if I can't import journal transactions anymore?
... View more
29-01-2024
16:56
Hi Marten, No I can't either, got the same error message.
... View more
29-01-2024
16:10
Hello, I try to post a journal transaction on which I receive error 'SubID' is not found. I can't figure out what wrong. Error requesting: POST "https://integration.visma.net/API/controller/api/v2/journalTransaction"
HTTP error: 400 - Bad Request
message: VismaId: 64e857ac-e612-4e0d-8065-29ea343b2f47. Error creating journal transaction. Error: 'SubID' is not found.
Body: {
"batchNumber": {
"value": "3001"
},
"overrideNumberSeries": {
"value": true
},
"branch": {
"value": "1"
},
"transactionDate": {
"value": "2024-01-26T00:00:00"
},
"postPeriod": {
"value": "012024"
},
"ledger": {
"value": "WERKELIJK"
},
"hold": {
"value": false
},
"currencyId": {
"value": "EUR"
},
"createVatTransaction": {
"value": "true"
},
"journalTransactionLines": [
{
"operation": "insert",
"lineNumber": {
"value": 1
},
"accountNumber": {
"value": "8100"
},
"subaccount": [
{
"segmentId": 1,
"segmentValue": "A"
},
{
"segmentId": 2,
"segmentValue": "1"
}
],
"transactionDescription": {
"value": "Regel 1"
},
"debitAmountInCurrency": {
"value": 500.0000
},
"creditAmountInCurrency": {
"value": null
},
"quantity": {
"value": null
}
},
{
"operation": "insert",
"lineNumber": {
"value": 2
},
"accountNumber": {
"value": "8100"
},
"subaccount": [
{
"segmentId": 1,
"segmentValue": "B"
},
{
"segmentId": 2,
"segmentValue": "3"
}
],
"transactionDescription": {
"value": "Regeltje 2"
},
"debitAmountInCurrency": {
"value": null
},
"creditAmountInCurrency": {
"value": 500.0000
},
"quantity": {
"value": null
}
}
]
} Can someone help me out? Thanks Kind regards, Sander
... View more
29-01-2024
15:45
Hi Suzdar, In addition to my previous reply, I also found out that I can't roughly sum the balances together from the documents returned by: ....customer/{customerCd}/document Apparently I also need knowhow of the different document types in order to use the correct sign. [ Invoice, DebitNote, CreditNote, Payment, VoidPayment, Prepayment, Refund, FinCharge, SmallBalanceWo, SmallCreditWo, CashSale, CashReturn, Undefined, NoUpdate ] I find this also very inconvenient, can you somehow add a "sign" field to the document objects? Best Regards, Sander
... View more
26-01-2024
16:57
Hi Suzdar, I replied accidentally to my own post 🙈 which was, of course, directed to you. Kind regards, Sander
... View more
26-01-2024
15:26
Hi Suzdar, First of all thank you for your quick reply. Unfortenately it's not quite the answer I was hoping for. First I have to make a request for the balances for all customers with a respective page size of 250 it takes 20 seconds for ~1250 customers. For all returned customers with a balance <> 0.00 I request: /controller/api/v1/customer/{customerCd}/document?status=Open Finally I'm be able to locally filter the returned data for the branchNumber I actually want. The result was 1180 open documents This took all and all more than 3 minutes which I find not quite acceptable. Even more worse when I did the same for the suppliers in my case ~7750 in total and 99 suppliers with a outstanding balance. This took 7 minutes. Maybe this had something to do with the fact that /controller/api/v1/supplier/{supplierCd}/document?status=Open gave me also all closed documents, so as it looks the filtering doesn't work. So I actually pulled 25k documents and only 286 with an actual balance on them. It’s a pity because the report “Balance by Customer” in the font-end is exactly what I need and can also be filtered by branch right away. Furthermore it only takes less than 10 seconds to generate! I also find out about the endpoints: /controller/api/v1/customerDocument & /controller/api/v1/supplierDocument Without any query params the customerDocument endpoint only gave me 3 results. With ?status=Open it gave me 22 ? What did i miss? I should expect 1180 docs. It looks like these endpoints are exactly what I'll need and only lack a branchnumber filtering possibility Can you help me out on this? Thanks in advance. Br, Sander
... View more
24-01-2024
19:50
Hi there, How can I get the all outstanding balances for a customer (or all customers at once) with at least the following fields: invoice number, invoice date, currency, invoice amount, paid amount, (amount due) What I'll need is the same data as shown in de "Balance by customer" report but then using a single API endpoint. And the same question for creditors 🙂 Best regards, Sander
... View more
Activity Feed for Sander_Feenstra
- Posted Re: Branch '1 ' cannot be found in the system on Forum in Developers Visma.net. 04-03-2024 13:11
- Posted Re: Branch '1 ' cannot be found in the system on Forum in Developers Visma.net. 26-02-2024 13:31
- Posted Branch '1 ' cannot be found in the system on Forum in Developers Visma.net. 26-02-2024 12:28
- Posted Re: How to retrieve detailed outstanding balances on Forum in Developers Visma.net. 08-02-2024 12:31
- Posted Re: How to retrieve detailed outstanding balances on Forum in Developers Visma.net. 08-02-2024 11:23
- Posted Re: Post journal transaction error "SubId" is not found on Forum in Developers Visma.net. 29-01-2024 17:20
- Posted Re: Post journal transaction error "SubId" is not found on Forum in Developers Visma.net. 29-01-2024 16:56
- Posted Post journal transaction error "SubId" is not found on Forum in Developers Visma.net. 29-01-2024 16:10
- Posted Re: How to retrieve detailed outstanding balances on Forum in Developers Visma.net. 29-01-2024 15:45
- Posted Re: How to retrieve detailed outstanding balances on Forum in Developers Visma.net. 26-01-2024 16:57
- Posted Re: How to retrieve detailed outstanding balances on Forum in Developers Visma.net. 26-01-2024 15:26
- Posted How to retrieve detailed outstanding balances on Forum in Developers Visma.net. 24-01-2024 19:50
Useful pages
Contact us
Copyright © 2022 Visma.com. All rights reserved.
Visma Denmark
Visma Finland
Visma Latvia
Visma Netherlands
Visma Norway
Visma Sweden
Visma Developers & Partners
Visma Latin America