My Products
Help
Florian Haase
PARTNER

InventoryNumbers with underscore

by Florian Haase

Hi,

vi have trouble here with import of invoiceLines when the inventorynumber contains "_" (Underscore). I'm not sure if this maybe was a topic here before?

 

Tried to import ANL_BTu as inventoryNumber: Error creating document. Inventory item ANL_BTu not found for line

 

Changed to ANLBTu in Json and in Visma.Net - and it worked.

 

Problem is, that the InventoryNumbers here comes from a 3. party system. Not sure how much work it is to change the numbers there.

 

Regards

 

Florian

3 REPLIES 3
Yıldırım
VISMA

by Yıldırım

Hello, 


Please have a look at this post, where we've shared information about the "underscore"

https://community.visma.com/t5/Forum-in-Developers-Visma-net/Inventory-API-Slow-performance/m-p/3189...

Florian Haase
PARTNER

by Florian Haase

Not sure what the conclusion in the end was... 

Can we say that VIsma.Net does not support inventory-numbers with underscore and register this as an idea for the future? Or is this a bug and somebody works on a solution?

 

Florian

 

Accepted solution
Yıldırım
VISMA

by Yıldırım (Updated ‎17-09-2020 15:36 by Yıldırım VISMA )

Conclusion is, 

  1. Underscore is not supported in the Financials ERP and it's used as a segment delimiter in the Financials UI therefore end-user can not create a resource with reserved  "_" character.  

  2. As of today, API allows creating resources with "Underscore" in their reference values.
    This has been registered as a bug in API with POST operations and will be fixed.

    API should not allow using "_" for resource identifiers. This may lead wrongfully referenced inventories in the UI/ DB transactions therefore you should avoid to use underscore while creating resources via API until this bug is fixed. (Once this bug is fixed, API won't allow underscore usage complying with the Financials ERP Data Structure.)