Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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

Forum : Support required regarding QuickBooks Custom FieldsSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v8 Forum

 New Topic 
 
 Post Reply 
[1]  
 Support required regarding QuickBooks Custom Fields 
 Author   Message 
  Clifford 
  
 Group: Members 
 Posts: 24 
 Joined: 2006-04-04 
 Profile
 Posted : 2008-08-19 21:06:05

 We are facing some problem in accessing custom field data through QODBC and would really appreciate your help in this regards.

We having client’s data with custom field name “DUEDATE” assigned to Item and Sales Order. We can view/edit data in this field on Sales Order screen. However when we try to view or access this field data using QODBC it shows us the blank data though the field contains data.

When we add custom field in Sample Company and view the data using QODBC, it shows the data properly. We would really appreciate if you could let us know whether this is data specific issue and how do we retrieve field data using QODBC in this case?

 JFYI we are using QuickBooks Enterprise Solutions 8.0 and 8.0.0.242 Version of QODBC.

 

 

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-08-19 23:06:41

Simply use the VERIFY tag to rebuild your optimized image of the table you are using. When you update custom fields the transaction date doesn't get modified by QuickBooks, so any changes to existing records need a rebuild. For example:-

Select * from SalesOrderLine VERIFY where TxnDate > {d'2008-07-01'}

See: How do I link Item Custom fields with Invoice lines? and How do I setup the QODBC Optimizer? Where are the Optimizer options? for more information.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to