Error: Invoice contact Revision ID cannot be empty.

[kashyap]

We are getting error for one client since last 10 days

Request:

{"orderType":{"value":"IN"},"customer":{"value":"12363"},"orderNumber":{"value":"203506"},"customerRefNo":{"value":"Entrance tickets"},"description":{"value":"440114-1 Capitales Balticas tickets 010923\n\nKontaktperson: Anna Isabel Munos"},"note":{"value":"441377-12-203506-590983-115127"},"date":{"value":"2023-09-15T17:33:02"},"hold":{"value":false},"branchNumber":{"value":"1    "},"lines":[{"operation":"Insert","inventoryNumber":{"value":"EVENT-12-113"},"description":{"value":"Inngangsbillett Norsk Folkemuseum NF avtale A"},"quantity":{"value":42},"unitPrice":{"value":"64.29"},"accountNumber":{"value":"3050"},"vatCodeId":{"value":"33"},"subaccount":[{"segmentId":1,"segmentValue":"650"},{"segmentId":2,"segmentValue":"0000001"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}]},{"operation":"Insert","inventoryNumber":{"value":"EVENT-12-107"},"description":{"value":"Inngangsbillett Norsk Folkemuseum Guide\/sj\u00e5f\u00f8r fri"},"quantity":{"value":1},"unitPrice":{"value":"0.00"},"accountNumber":{"value":"3050"},"vatCodeId":{"value":"33"},"subaccount":[{"segmentId":1,"segmentValue":"650"},{"segmentId":2,"segmentValue":"0000001"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}]}]}

Response Headers

{"date":["Thu, 28 Sep 2023 06:58:33 GMT"],"server":["Nginx"],"strict-transport-security":["max-age=31536000; includeSubDomains","max-age=31536000; includeSubDomains"],"content-type":["application\/json; charset=utf-8"],"ipp-request-id":["b81cad41-ce8a-4772-a554-72040fe9ce67"],"x-content-type-options":["application\/json"],"pragma":["no-cache"],"x-handled-by":["Visma-PX.Export\/AuthenticationManagerModule"],"referrer-policy":["origin-when-cross-origin"],"vnfinstanceid":["ERP_NO_REAL_0034"],"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=Wed, 27-Sep-2023 06:58:30 GMT; path=\/; secure; HttpOnly"],"connection":["close"],"transfer-encoding":["chunked"]}

Response:

Error: Inserting  'Invoice contact' record raised at least one error. Please review the errors.
Error: 'Revision ID' cannot be empty.

[Yıldırım]

Hello, have you tried creating IN type Order with the same values in the Financials Company UI ? 

[kashyap]

No. We dont have client account access.

[Yıldırım]

Please inform the client to try that operation with the same values in their company so that you can diagnose the case.

[kashyap]

Today I got access and try to add order manually. Its working perfectly. 

Can you please advice, how we can resolve this issue? Everyday many client receiving same error.

[Yıldırım]

What endpoint & operation are you using ? Please also send us print screen of the document that you've created in the UI and specify the screen ID. 
Thanks.

[kashyap]

[2023.10.10 14:33:41]   REQUEST::


{"orderType":{"value":"IN"},"customer":{"value":"12483"},"orderNumber":{"value":"203506"},"customerRefNo":{"value":"Entrance tickets"},"description":{"value":"440114-1 Capitales Balticas tickets 010923\n\nKontaktperson: Anna Isabel Munos"},"note":{"value":"441377-12-203506-590983-115127"},"date":{"value":"2023-09-15T17:33:02"},"hold":{"value":false},"branchNumber":{"value":"1    "},"lines":[{"operation":"Insert","inventoryNumber":{"value":"EVENT-12-113"},"description":{"value":"Inngangsbillett Norsk Folkemuseum NF avtale A"},"quantity":{"value":42},"unitPrice":{"value":"64.29"},"accountNumber":{"value":"3050"},"vatCodeId":{"value":"33"},"subaccount":[{"segmentId":1,"segmentValue":"650"},{"segmentId":2,"segmentValue":"0000001"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}]},{"operation":"Insert","inventoryNumber":{"value":"EVENT-12-107"},"description":{"value":"Inngangsbillett Norsk Folkemuseum Guide\/sj\u00e5f\u00f8r fri"},"quantity":{"value":1},"unitPrice":{"value":"0.00"},"accountNumber":{"value":"3050"},"vatCodeId":{"value":"33"},"subaccount":[{"segmentId":1,"segmentValue":"650"},{"segmentId":2,"segmentValue":"0000001"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}]}]}


[2023.10.10 14:33:41] 

POST https://integration.visma.net/API/controller/api/v2/salesorder

["ipp-company-id: 4017586","ipp-application-type: Visma.net Financials","Content-Type: application\/json; charset=utf-8","Accept: application\/json","Authorization: Bearer xxxxxx-xxxx-xxxxx-xxx-xxxxxxx"]

[2023.10.10 14:33:45] RESULT OF HEADERS :: 

{"date":["Tue, 10 Oct 2023 12:33:45 GMT"],"server":["Nginx"],"strict-transport-security":["max-age=31536000; includeSubDomains","max-age=31536000; includeSubDomains"],"content-type":["application\/json; charset=utf-8"],"ipp-request-id":["e3eefcf1-bb22-44bb-ada0-35848a522494"],"x-content-type-options":["application\/json"],"pragma":["no-cache"],"x-handled-by":["Visma-PX.Export\/AuthenticationManagerModule"],"referrer-policy":["origin-when-cross-origin"],"vnfinstanceid":["ERP_NO_REAL_0034"],"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=Mon, 09-Oct-2023 12:33:41 GMT; path=\/; secure; HttpOnly"],"connection":["close"],"transfer-encoding":["chunked"]}

[2023.10.10 14:33:45] call() - Result Failed:: 


Error: Inserting  'Invoice contact' record raised at least one error. Please review the errors.
Error: 'Revision ID' cannot be empty.

[kashyap]

API call logs:

[2023.10.10 14:33:41] 

POST https://integration.visma.net/API/controller/api/v2/salesorder

HEADERS: 

["ipp-company-id: 4017586","ipp-application-type: Visma.net Financials","Content-Type: application\/json; charset=utf-8","Accept: application\/json","Authorization: Bearer f476d2fc-d287-4be5-aab7-e893841e9f13"]

[2023.10.10 14:33:41]   REQUEST:

{"orderType":{"value":"IN"},"customer":{"value":"12483"},"orderNumber":{"value":"203506"},"customerRefNo":{"value":"Entrance tickets"},"description":{"value":"440114-1 Capitales Balticas tickets 010923\n\nKontaktperson: Anna Isabel Munos"},"note":{"value":"441377-12-203506-590983-115127"},"date":{"value":"2023-09-15T17:33:02"},"hold":{"value":false},"branchNumber":{"value":"1    "},"lines":[{"operation":"Insert","inventoryNumber":{"value":"EVENT-12-113"},"description":{"value":"Inngangsbillett Norsk Folkemuseum NF avtale A"},"quantity":{"value":42},"unitPrice":{"value":"64.29"},"accountNumber":{"value":"3050"},"vatCodeId":{"value":"33"},"subaccount":[{"segmentId":1,"segmentValue":"650"},{"segmentId":2,"segmentValue":"0000001"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}]},{"operation":"Insert","inventoryNumber":{"value":"EVENT-12-107"},"description":{"value":"Inngangsbillett Norsk Folkemuseum Guide\/sj\u00e5f\u00f8r fri"},"quantity":{"value":1},"unitPrice":{"value":"0.00"},"accountNumber":{"value":"3050"},"vatCodeId":{"value":"33"},"subaccount":[{"segmentId":1,"segmentValue":"650"},{"segmentId":2,"segmentValue":"0000001"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}]}]}

[2023.10.10 14:33:45] RESULT OF HEADERS :: 

{"date":["Tue, 10 Oct 2023 12:33:45 GMT"],"server":["Nginx"],"strict-transport-security":["max-age=31536000; includeSubDomains","max-age=31536000; includeSubDomains"],"content-type":["application\/json; charset=utf-8"],"ipp-request-id":["e3eefcf1-bb22-44bb-ada0-35848a522494"],"x-content-type-options":["application\/json"],"pragma":["no-cache"],"x-handled-by":["Visma-PX.Export\/AuthenticationManagerModule"],"referrer-policy":["origin-when-cross-origin"],"vnfinstanceid":["ERP_NO_REAL_0034"],"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=Mon, 09-Oct-2023 12:33:41 GMT; path=\/; secure; HttpOnly"],"connection":["close"],"transfer-encoding":["chunked"]}

[2023.10.10 14:33:45] call() - Result Failed:: 

Error: Inserting  'Invoice contact' record raised at least one error. Please review the errors.
Error: 'Revision ID' cannot be empty.

 

Used screen URL: PFA

[kashyap]

API call logs:

[2023.10.10 14:33:41]   Request Data:


{"orderType":{"value":"IN"},"customer":{"value":"12483"},"orderNumber":{"value":"203506"},"customerRefNo":{"value":"Entrance tickets"},"description":{"value":"440114-1 Capitales Balticas tickets 010923\n\nKontaktperson: Anna Isabel Munos"},"note":{"value":"441377-12-203506-590983-115127"},"date":{"value":"2023-09-15T17:33:02"},"hold":{"value":false},"branchNumber":{"value":"1    "},"lines":[{"operation":"Insert","inventoryNumber":{"value":"EVENT-12-113"},"description":{"value":"Inngangsbillett Norsk Folkemuseum NF avtale A"},"quantity":{"value":42},"unitPrice":{"value":"64.29"},"accountNumber":{"value":"3050"},"vatCodeId":{"value":"33"},"subaccount":[{"segmentId":1,"segmentValue":"650"},{"segmentId":2,"segmentValue":"0000001"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}]},{"operation":"Insert","inventoryNumber":{"value":"EVENT-12-107"},"description":{"value":"Inngangsbillett Norsk Folkemuseum Guide\/sj\u00e5f\u00f8r fri"},"quantity":{"value":1},"unitPrice":{"value":"0.00"},"accountNumber":{"value":"3050"},"vatCodeId":{"value":"33"},"subaccount":[{"segmentId":1,"segmentValue":"650"},{"segmentId":2,"segmentValue":"0000001"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}]}]}​

URL:
POST https://integration.visma.net/API/controller/api/v2/salesorder

Headers: 
["ipp-company-id: 4017586","ipp-application-type: Visma.net Financials","Content-Type: application\/json; charset=utf-8","Accept: application\/json","Authorization: Bearer xxxxxxxc-xxxx-4be5-xxxx-e893841e9f13"]

[2023.10.10 14:33:45] RESULT OF HEADERS :: 

{"date":["Tue, 10 Oct 2023 12:33:45 GMT"],"server":["Nginx"],"strict-transport-security":["max-age=31536000; includeSubDomains","max-age=31536000; includeSubDomains"],"content-type":["application\/json; charset=utf-8"],"ipp-request-id":["e3eefcf1-bb22-44bb-ada0-35848a522494"],"x-content-type-options":["application\/json"],"pragma":["no-cache"],"x-handled-by":["Visma-PX.Export\/AuthenticationManagerModule"],"referrer-policy":["origin-when-cross-origin"],"vnfinstanceid":["ERP_NO_REAL_0034"],"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=Mon, 09-Oct-2023 12:33:41 GMT; path=\/; secure; HttpOnly"],"connection":["close"],"transfer-encoding":["chunked"]}

[2023.10.10 14:33:45] Response:: 


Error: Inserting  'Invoice contact' record raised at least one error. Please review the errors.
Error: 'Revision ID' cannot be empty.

URL: https://finance.visma.net/0965051004/Main?CompanyID=Norsk+Folkemuseum&ScreenId=SO301000&OrderType=IN...

PFA

[Yıldırım]

Hello,
- does the used customer have Parent - Child relation setup in the company ? 

- can you check the used customer's Invoicing Settings > Invoice Address fields and make sure it has data or marked same as main ? 
- Please also check that customer's > Delivery settings > Default Location Settings > Corporate ID
if there's no value, please add and retry. 

[kashyap]

As of now, we are sending same address fields in below fields:

mainAddress
invoiceAddress
deliveryAddress


Same for contact information sending in below fields

mainContact
invoiceContact
deliveryContact


Does this make issue? If yes, what if I will send only mainContact and mainAddress only?

[Yıldırım]

In what endpoint are you sending those fields ? Those are not available in SalesOrderV2, instead following fields can be used soBillingContact, soBillingAddress, soShippingContact,soShippingAddress however the payload you've shared doesn't contain them. 

So please share information on the points we've mentioned previously, 

- does the used customer have Parent - Child relation setup in the company ? 

- can you check the used customer's Invoicing Settings > Invoice Address fields and make sure it has data or marked same as main ? 
- Please also check that customer's > Delivery settings > Default Location Settings > Corporate ID
if there's no value, please add and retry. 

If you're unable to pinpoint the issue after reviewing those options, please share your companyID & Name via developersupport@visma.com so that we can import a copy of the company DB for further investigation. 

Thanks.

[kashyap]

Above mentioned fields we use to create customer via endpoint controller/api/v1/customer,  not for sales order. 

Do we need to pass all this fields or only main field ok?

[Yıldırım]

Hello Kashyap, you can include all the fields those are necessary for your operation. At this point, we believe it'd be best to restore a copy of your company DB to be able to diagnose the issue.