If you need to create a supplier, you can use a format similar to this:
For USA Editions of QuickBooks: INSERT INTO Vendor (IsActive, Name, CompanyName, VendorAddressAddr1, VendorAddressAddr2, VendorAddressAddr3, VendorAddressCity, VendorAddressState, VendorAddressPostalCode, VendorAddressCountry, Phone, Fax, Email, AccountNumber, Notes) VALUES (1,'A-1 Sanitation Service','A-1 Sanitation Service','P.O. Box 9001706','','','Louisville','KY','40290-1706','','(910) 791-4048','','','176854','')
For Non-USA Editions of QuickBooks: INSERT INTO Vendor (IsActive, Name, CompanyName, VendorAddressAddr1, VendorAddressAddr2, VendorAddressAddr3, VendorAddressCity, VendorAddressCounty, VendorAddressPostalCode, VendorAddressCountry, Phone, Fax, Email, AccountNumber, Notes) VALUES (1,'A-1 Sanitation Service','A-1 Sanitation Service','P.O. Box 9001706','','','Lysterfield','VIC','3155,'','(910) 791-4048','','','176854','')
For jobs, add ParentRefListID or ParentRefFullName of the Jobs parent record.
Note: Name must be unique across Customer, Employee, Vendor, and OtherName and is required for the insert. You can query the Entity to verify if a name already exists.
|