|
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
|
|
| Updating CustomFieldOther in the SalesReceipt table |
| Author |
Message |
|
|
| Posted : 2006-10-11 02:30:37 |
| I'm using QODBC 7.0 and Quickbooks Pro 2006. I have created an MS Access front end to Quickbooks. I'm trying to update the CustomFieldOther field in the SalesReceipt table and am being prevented. I've also tried updating this field through the SalesReceiptLine table, but that doesn't work as well. My goal is to be able to import a UPS generated CSV file and update this field with the Tracking Number. Is there a workaround. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-10-11 15:52:06 |
Sorry, CustomFieldOther, CustomFieldSalesReceiptLineOther1 and CustomFieldSalesReceiptLineOther2 are all query only columns using QODBC v6 or v7 with QuickBooks 2006 or lower revisions (due to limitations by Intuit).
If you upgrade to QuickBooks 2007, you can use QODBC v7 to insert or update data in the Other, SalesReceiptLineOther1 and SalesReceiptLineOther2 fields. |
|
|
|
|