Customer/Vendor Relationships
Hi,
Is there a way to do a mass upload into the Customer/Vendor Relationships window through SmartConnect?
We have a couple thousand records where the Customer ID is equal to the Vendor ID, and just want create the relationship between the two. Right now, we'd have to copy and paste the ID into both the Customer and Vendor ID field. Anyway to do this with Smartconnect?
Is there a way to do a mass upload into the Customer/Vendor Relationships window through SmartConnect?
We have a couple thousand records where the Customer ID is equal to the Vendor ID, and just want create the relationship between the two. Right now, we'd have to copy and paste the ID into both the Customer and Vendor ID field. Anyway to do this with Smartconnect?
This is not currently a node within Smart Connect or Microsoft eConnect. We could create one for you using Node Builder or you could use the Microsoft SQL table as the destination. I don't usually recommend using the Microsoft SQL Table destination for Dynamics GP tables as it bypasses any business logic. Lorren