We have a big customer with over 3000 stores in the USA. I am having trouble when adding a new Customer/Job. I am able to add the new Customer/Job with the following code. This works just great.
INSERT INTO "Customer" ("ParentRefListID","CompanyName","CustomerTypeRefListID","TermsRefListID","SalesTaxCodeRefListID","Name","Phone", "BillAddressAddr1","BillAddressAddr2","BillAddressCity","BillAddressState","BillAddressPostalcode","ShipAddressAddr1", "ShipAddressAddr2","ShipAddressCity","ShipAddressState","ShipAddressPostalcode")
values('50000-1155757877','Bigmart','10000-1155645258','70000-1155757866','20000-1157469347','BIG-MART #0001','(479)636-3222','BIG-MART STORE #0001','2110 WEST WALNUT','ROGERS','AR','72756','BIG-MART STORE #0001','2110 WEST WALNUT','ROGERS','AR','72756')
The problem is in the Ship To Section, QB seems to give the Address Name "Ship to 4", "Ship to 5", etc. Is there any way to set this field to the "Name" field . We need to lookup "Ship To" by Store Number, ie, 'BIG-MART #0001'
|