Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
stanley1271 8/12/2009 12:39:38 PM

Create Vendor Record

I am trying to import all of our agents and check to see if they are already set up as vendors in GP. I can check to see if they are there and if they need to be updated, but if they are new then I need to create the record. So I am trying to use taUpdateCreateVendorRcd, however, when I populate the name, vendorid and address it tells me "The Primary Address Code is required when other address information is filled in". So I figured I would need to create the address record first. So when I started looking into this i saw that in taUpdateCreateVendorRcd, there is a property CreateAddress and the docs say:

 Flag to allow a primary address code to be created on the fly:

0=Do not create address code;

1=Create address code

So I thought that if I set that to 1 I would be fine. That did not work. I still get the same error message as above. So now I am trying to use taCreateVendorAddress, but in my code this comes up as an error telling me to use taCreateEmployeeAddress or taCreateInternetAddress or taCreateInventorySite or taDeleteCustomerAddress.

None of which fits what I need as far as I know. Any ideas as to what I can do?

Version: Unknown or N/A
Section: eConnect

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables