Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Why do people appear in the Entity table as a Customer but not appear in the Customer table? |
Author |
Message |
|
Posted : 2009-01-17 03:33:54 |
I am using Quickbooks 2008 and VB6. When adding customers I first check the Entity table to verify that they do not already exist before I add them. I am finding that some will show up in Entity as a Customer but not show up on a search of Customer table. Is there a temporary table that holds them? Are they in limbo somewhere needing to be finalized? I cannot enter this person until I get rid of them in the entity table. Thanks Steve |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-17 09:42:00 |
The Entity table is a read only view of Customers, Employees, Vendors, and OtherNames with minimal details. We normally use the Entity table to query if a name already exists. For all the details on Customers, Employees, Vendors, and OtherNames, query those tables instead. Name must be unique across Customer, Employee, Vendor, and OtherName to be added to QuickBooks. You can query the Entity to verify if a name already exists.
If your optimized Customer table is simply out of sync, then you can force a rebuild by doing:
Select * from Customer verify |
|
|
|
|
Posted : 2009-01-18 08:04:51 |
This problem was solved by rebuilding the Quickbooks data file Thanks For your help |
|
|
|
|