Knowledgebase
[QODBC-Desktop] How to create Vendors (Suppliers) using QODBC
Posted by brad waddell on 12 March 2009 05:21 PM

An Example of Creating a Vendor (Supplier)

Note: If you need to create a supplier, you can use a format similar to the one below.

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','')

Special Notes

For Jobs

    For jobs, add ParentRefListID or ParentRefFullName of the Jobs parent record.

Unique Name

     The name must be unique to the Customer, Employee, or Vendor, and another name is required for the insert. You can query the Entity to verify if a name already exists.


Note:  QODBC Support Wizard is used only to test QODBC SQL queries and is not a development tool.


Problem and Solution

Problem Description

     I have inserted a new vendor successfully. The customer shows in QuickBooks, but the customer record isn't there when I do a query in the QODBC Test Tool. What causes that to happen, and how do I fix it?

Solution

     This occurs when your computer's time setting has been changed or when using a QuickBooks sample file. When this happens, you can resync your optimized vendor table by running the following:

     sp_optimizefullsync vendor

Or you can by-pass the optimized table by doing the:

     Select * from vendor unoptimized

(187 vote(s))
Helpful
Not helpful
Comments (1)
Morad
20 September 2012 01:08 PM
Review by EmbeddedFlyer for Rating: As another reveiw mentions, the bulk of the 29 reveiws currently posted are by Vines members who received the product for free and beta testers who are coddled by Intuit. There are precious few independent reveiws here. Why is that?I've been a Quickbooks user since 1999. Up until QB 2005, it was a solid, nearly bug free and user friendly product. Unfortunately, Intuit sunsets their products and makes it increasingly impossible to use an older version after a few years. So I was forced to upgrade beyond 2005. The short version of a very long sad saga is each version after 2005 has been worse than the one before it with 2009 being the biggest mess yet.2010 is *marginally* better than 2009 in some ways. Intuit has made the online banking actually function again (they completely broke it in 2009) and cleaned up a few other annoying 2009 issues. But, sadly, the nag screens have gotten even worse and there are even more things that are now expensive upgrades. It's completely insulting to be forced into buying new versions of Quickbooks only to have it increasingly function like trial ware or some light or limited functionality version until you spend even more money with Intuit.Not only is it annoying, but all the nagging literally makes the product harder and slower to use. When you're just trying to get things done, another offer is in your face to spend more money with Intuit. It's not good for one's blood pressure or productivity.Quickbooks behaves almost like malware. Their online update system runs all the time even when you don't have Quickbooks open. And not only does it get updates for the software itself, it also seems to feed yet more special offers to your PC to spend more money with Intuit. I've used ad-supported freeware that's less invasive and annoying than Quickbooks is. If you have a PC firewall set to alert you when software attempts to connect to the outside world, you'll be shocked how often Quickbooks contacts the Intuit Mothership for who knows what? Many of the new features in 2010 have a revenue stream for Intuit tied to them including attaching documents. I agree with the other reveiw that Intuit seems to focus nearly all their considerable resources on ways to extract more money from customers, and further hype their buggy bloated products, rather than making them easier to use. They also seem to have taken to actively managing online reveiws such as the ones here.I encourage others who have issues with Intuit products to post their experiences here and elsewhere. Intuit has a near monopoly with Quickbooks. I think only if the problems are voiced loudly enough (such as with the online banking debacle in 2009) will Intuit have any desire to change their ways and actually focus on what customers want rather than ways to milk ever more money out of them.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).