User Profile
Magnus Johnsen
1050
Posts
112
Kudos
172
Solutions
20-04-2021
16:44
Hello, additionally,
- API Response Header "Date" is always GMT / UTC - Application (Financials ERP & DB) returns the LastModifiedDateTime value stored in the database based on the server location which is currently CEST (UTC/GMT+2) and this will be CET (UTC/GMT +1) during the winter time.
... View more
19-04-2021
16:20
1 Kudo
Currently, the "Attributes" parameter is exposed on the following endpoints.
Endpoint
Customer
CustomerContract
Inventory
Project
Supplier
Setting the attributes for other assets works in the same way as for e.g. customer.
To set Attributes on Customers and Inventory Items you first need to
Create the attributes in the UI.
Assign the attributes to the Customer/Inventory etc. Classes respectively.
Assign the class to the Customer/Inventory Item you want to use them on.
Set the values of the attributes.
1. Creating the attributes:
You can do this in the Attributes screen(ScreenId=CS205000):
2. Assigning the attributes to the class:
Customer
You can either reach the customer classes by
Going to screen ScreenId=AR2010PL
Clicking on the pen next to the class in the customer card:
Here you then add attributes based on the attributes you have created in the attributes screen.
Inventory
You can either find the Item classes by:
Going to the Item class screen(ScreenId=IN201000)
Or clicking in the pen next to the Item class in the Inventory screen:
Same as for customer, you can add attributes here based on the attributes you have created in the Attributes screen.
3/4. Setting the attributes and their values
When this has been done, you can under the Attributes tab add the attributes from the classes the Customer/Inventory belongs to and set their values:
Using the attribute parameter via the API
To use these attributes, below is the syntax to use in your query:
Filtering on several attributes.
{{base}}/inventory?attributes={"AttributeID1":"ValueID1","AttributeID2":"ValueID2"}
Filtering on date time
{{base}}/inventory?attributes={"DATETIME":"2019-04-19"}
Filtering on text. It will not match partial strings. only exact string.
{{base}}/inventory?attributes={"TEXT":"long text to filter upon"}
Filtering on True/False
{{base}}/inventory?attributes={"ACTIVE":"1"}
With special case for Multiple selection combo: {{base}}/inventory?attributes={"AttributeID":"ValueID1,ValueID2"}
When encoding your query, the "equal sign" should not be encoded, below is an example for the customer endpoint and accepted forms of encoding it:
Customer Endpoint:
GET {baseUrl}customer?attributes={"DATETEST":"2019-01-01","TEST":"testvalue"}
Encoded: (both encoding examples below are accepted)
customer?attributes=%7B"DATETEST":"2019-01-01","TEST":"testvalue"%7D
customer?attributes=%7B%22DATETEST%22%3A%222019-01-01%22%2C%22TEST%22%3A%22testvalue%22%7D
Inventory Endpoint
Inventory?attributes={"TEST":"testvalue"}
Encoded: (both encoding examples below are accepted)
inventory?attributes=%7B"TEST":"testvalue"%7D
inventory?attributes=%7B%22TEST%22%3A%22testvalue%22%7D
... View more
19-04-2021
11:10
This case has been accepted by the developers and will be implemented. The case is currently marked with high priority.
... View more
14-04-2021
14:06
Hello.
Currently, this is also valid on the following fields for the API transactions with released "Supplier/Purchase Invoice" documents.
Purchase (Supplier) Invoice header -Payment Ref No -Due Date -Cash Discount Date
Financial Details [Payment Information] -Charge Bearer -Priority -Payment reporting code -Payment Message -Pay date -Payment Location -Payment Method -Cash Account -Approved for payment (paySelected)
As aforementioned, values can be set by sending FT=1 parameter in the request URL as a workaround at the moment. PUT:
https://integration.visma.net/API/controller/api/v1/supplierInvoice/<InvoiceNumber>?FT=1
{
"paySelected": {
"value": true
}
}
... View more
14-04-2021
10:11
Hi,
Ok, we are not able to see any issues with the JSON's you have sent us and are not able to reproduce this in our local enviroments.
As far as we know, there should not be a difference in the validation made in the UI when using the action "addPurchaseOrderLine" and when doing it via the API.
Has this happened to any other purchaseOrderLines?
What type is the inventoryItem? Non-stock or stock?
As we are not able to reproduce this at this moment with the information provided, could you please let us know if it happens again so that we can try to replicate the issue on our end?
Thank you.
... View more
01-04-2021
12:49
Hi,
We'll move this post to the Ideas section of the forum.
Thank you for your suggestion.
... View more
22-03-2021
15:02
Hello,
One currency ID can only have one exchange rate with the same Currency / Currency Type / Effective Date / Currency Rate at the same time. In this way, as it mentioned above, this can be fetched via e.g.
https://integration.visma.net/API/controller/api/v1/currency/exchangerates/EUR/2021-03-22
Currency exchange rates can be recorded any time for a particular currency. Each record contains the date when the rate becomes effective. When the next record for the same rate type is entered, the rate value becomes a historical rate and can be used as the effective rate for operations that take place between the two dates. Historical rates are stored in the database for all the financial years defined in the system. We do not recommend that you change the value of the exchange rate if any transactions were based on the historical rate. You can use the historical rates for entering back-dated transactions and for calculating realized and unrealized gains and losses.
... View more
19-03-2021
16:53
1 Kudo
Hello,
This feature is currently available on the following endpoints, so please make sure you are using the "overrideNumberseries" on POST CustomerInvoice V2.
POST Customer
POST CustomerDebitNote V2
POST SalesOrder
POST Supplier
POST Journal Transaction V2
POST PurchaseOrder
POST Supplier Invoice
POST CustomerCreditNote V2
POST CustomerInvoice V2
Visma.net Financials API updates for version 8.25 (September 2020)
Override number series for POST CustomerInvoice V2 You are now able to override the number series of a customer invoice by specifying the field overrideNumberSeries=true when creating a customer invoice. This functionality has to be enabled in the Number series (CS201010) window by selecting option Allow manual numbering on imports. You also can specify a longer customer invoice number when using overrideNumberSeries than what is specified in number series for customer invoice. 1-Set Allow manual numbering on imports = true on the UI 2-Set
"overrideNumberSeries": {
"value": true
},
3-Add
"referenceNumber": {
"value": "string"
},
... View more
15-03-2021
08:44
This is planned to be included in version 8.41 planned to be released on 16/03/2021:
Visma.net Financials API updates for version 8.41.0 (March 2021)
... View more
04-03-2021
07:16
Hi Trygve, In the second line of your code you are doing an unsafe object casting. It means that you are casting to an object type InputStream, but without checking that your object is of type InputStream . It will give you a runtime error in case your object is not of the type InputSteam. You can read more about it in this article: https://docs.microsoft.com/en-us/dotnet/csharp/how-to/safely-cast-using-pattern-matching-is-and-as-operators It might not help you with your problem, but since you pasted this code I thought it could be a good advice. BR, Rolf Henrik
... View more
03-03-2021
13:42
Hello Thomas,
we also encourage you to use our Ideas Section to raise your improvement requests, thus, the idea would be visible to the development team for the sprint planning and can be prioritized based on demand rate. Thanks.
... View more
25-02-2021
16:50
Hello Andre, as Magnus mentioned, recommended way would be dividing your request into chunks, such as 250 - 500 Line per request. [Initial POST then PUT (Insert Invoice Lines) ] Can you also please send your CompanyID & Name and the API Client ID used in your integration ? In this way we can check our logs to see if there is anything related to the servers. Thanks. <developersupport@visma.com>
... View more
25-02-2021
16:31
Hello Tomi,
This improvement request is in our backlog and the posted "Idea" can be found at Webhook subscription for Purchase receipt Please feel free to add comment and give kudos which will eventually help our development team with prioritization during the sprint planning. Thanks.
... View more
25-02-2021
16:27
Hello Mathias, Could you please send us your integration's API Client ID that is used while generating the token ? You can send this to developersupport@visma.com CompanyName seems to be "Skal", could you confirm ? Thanks.
... View more
25-02-2021
13:12
Hi,
At the moment, none of the wenhook events supports deletion.
You can post it in the Idea's part of the forum if you would like to see this implemented.
... View more
23-02-2021
14:12
Could you please send us an email at developersupport@visma.com and provide us with the ipp-company-id as well as screenshots showing the customer number of any customer that cuses this issue.
Has this been an issue for long? When did it start?
Is this in production or test?
... View more
19-02-2021
15:11
HI,
We recently had a different case also regarding an Inventory related error in the salesOrder endpoint.
The conclussion in that case was that we will not be fixing this in the current endpoint, but will focus on this and many other issues with the salesOrder endpoint during this year.
This year we have a major project where the plan is to rewrite all of the salesOrder logic.
... View more
18-02-2021
13:37
Hi,
We can confirm this and have reported it to the development team.
Thank you for letting us know.
... View more
16-02-2021
14:21
Hi,
Inventory does nos have kitAssembly or stockComponent allocations, what are you trying to do via that endpoint?
As far as we can see, both your images are from kitAssembly, is this correct?
Kitassembly does not have stockComponent allocations exposed for post/put via the API currently:
Please create a post in the Ideas section of the forum. Please describe your use case as well as possible.
This allows others to vote for your suggeston, which in turn influences the assessment and implementation process.
... View more
04-02-2021
15:17
Ahh, now I see the error. It is called "lotSerialNbr" in "shipmentDetailLines", but "lotSerialNumber" in "allocations" Thanks a lot 🙂
... View more
29-01-2021
16:08
Hi,
Could you please provide us with the following information to developersupport@visma.com and we'll forward it to the development team for investigation:
All steps taken until issue occurs
Screenshot of Supplier Invoice showing Financial Details : Batch NR
Screenshot of Journal Transactions window(ScreenId=GL3010PL) showing the batches created for this invoice
... View more
29-01-2021
10:30
There is currently a case in the backlog to extend webhook notifications for "APinvoice_Changed"
... View more
27-01-2021
14:56
[Release Notes] - Visma.Net API 8.33.0 - 19.01.2021
... View more
26-01-2021
08:49
Hi,
OK, glad that it solved the issue.
... View more
22-01-2021
07:04
Hi,
Currently there does not seem to be a solution for this implemented.
We would recommend that you post the suggestion to implement this in the Ideas section.
... View more
21-01-2021
14:24
Hi!
It seems like the lies with using V1 for the customerInvoice endpoint. Please update your call to use the V2 endpoint and let us know if this solves your issue:
/controller/api/v2/customerinvoice
... View more
20-01-2021
11:32
Ok, good to hear it is solved.
Yes, we agree that the error seems to be missrepresenting the issue.
... View more
19-01-2021
13:20
Visma.net ERP version 8.33 will be released 19/01 22:30 CET. There will be short downtime between 22:30 and 00:30 This is because we have an issue with the upgrade process that prevents us from upgrading databases without downtime. In the coming releases this will be resolved. status.visma.com will be updated accordingly. We will keep you informed of any changes.
Scheduled Maintenance for Visma.net ERP
Visma.net Financials API updates for version 8.33.0 (January 2021)
... View more
15-01-2021
10:17
No worries, it is a lot to read at first. 🙂
... View more
Activity Feed for Magnus Johnsen
- Posted Version 10.29 - Scheduled downtime maintenance window has been postponed: 10th December on News in Developers Visma.net. 27-11-2024 14:17
- Posted Version 10.28 - Breaking change due to mandatory changes in the SAF-T report: 6th December 2024 on News in Developers Visma.net. 18-11-2024 14:22
- Got a Kudo for Re: Including Attributes when getting multiple Projects. 17-05-2024 09:03
- Tagged [Release Notes] - Visma.Net API 9.80.0 - 06.02.2024 on News in Developers Visma.net. 09-02-2024 08:57
- Posted Re: TaxID '01' cannot be found in the system. on Forum in Developers Visma.net. 18-01-2024 15:18
- Posted Re: HIGH priority Subaccount missing, Error creating journal transaction. Error: TaxID '01' cannot on Forum in Developers Visma.net. 18-01-2024 15:00
- Posted Re: Budget API is not retrieving inactive subaccounts on Forum in Developers Visma.net. 18-01-2024 13:39
- Posted Re: Bad Gateway messages when making calls to the Visma.Net ERP API on Forum in Developers Visma.net. 17-01-2024 09:56
- Posted Sv: Getting customer / supplier invoice document (PDF) on Forum in Developers Visma.net. 15-01-2024 10:25
- Posted Sv: Getting customer / supplier invoice document (PDF) on Forum in Developers Visma.net. 10-01-2024 13:37
- Posted Re: Insert supplier on Forum in Developers Visma.net. 09-01-2024 09:51
- Posted Svar: Insert supplier on Forum in Developers Visma.net. 09-01-2024 09:47
- Posted Re: Insert supplier on Forum in Developers Visma.net. 09-01-2024 09:03
- Posted Re: Bad Gateway 502, in all API calls, AGAIN (!) on Forum in Developers Visma.net. 05-01-2024 12:10
- Posted Re: Bad Gateway messages when making calls to the Visma.Net ERP API on Forum in Developers Visma.net. 04-01-2024 11:16
- Posted Re: Change from test to production on Forum in Developers Visma.net. 03-01-2024 12:23
- Posted Re: VNI-VC January 1st on Forum in Developers Visma.net. 02-01-2024 11:13
- Posted Re: Salesorder API v3 creating orderLines without subaccount on Forum in Developers Visma.net. 29-12-2023 14:25
- Posted Svar: IPPexception 5520 on every call for select customers migrated to new auth flow on Forum in Developers Visma.net. 29-12-2023 14:21
- Posted Re: Service app status pending on Forum in Developers Visma.net. 29-12-2023 10:24