Hello!
While developing a customization project to extend a webservice to migrate data from our legacy ERP into Acumatica, I have discovered that while there is a standard ‘CustomerLocation’ object where we can access and modify customer location entries, there is no equivalent VendorLocation object.
I tried to create a VendorLocation endpoint by mimicking how the Customer Location fields were all mapped, but there do not appear to be equivalent mappings in order for me to accomplish this.
Additionally, if I just select all fields from the Vendor Location Summary, it corrupts things so badly that we start getting stack overflows when trying to push a Sales Order into Acumatica:
And when we try to pull the VendorLocation data via Postman, it would throw errors relating to the Address information we had mapped directly from the Vendor Location Summary (here’s a small snip of that error):
"message": "An error has occurred.",
"exceptionMessage": "The multi-part identifier \"BAccountID!Address.City\" could not be bound.\r\nThe multi-part identifier \"BAccountID!Address.CountryID\" could not be bound.\r\nThe multi-part identifier \"BAccountID!Address.PostalCode\" could not be bound.",
It took me at least a week to unpublish and republish my project multiple times in order to get the Sales Order object able to receive PUT requests successfully again (without my VendorLocation endpoint in it).
Is Acumatica planning on creating a stock VendorLocation object any time soon? If not, can anyone help with the mappings I need to make so that we do not run into the same issues above?
Any help would be greatly appreciated!
