|
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
|
|
| New User - Support for Quickbooks Item List from Access |
| Author |
Message |
|
|
| Posted : 2006-10-17 18:56:00 |
Hello,
I am trialing the product and am hopeful that it can me integrate my finances in Quickbooks and a production database that is being developed in Access.
I have have installed the QODBC product successfully. I can for example modify Vendor information and see the information propogated both ways.
However, I'm not having the same luck when it comes to 'Items'. I can create a link table of the information from quickbooks. Most information is propogated, however some information is missing however. For example: Items of type service do seem to link to their description while Inventory Items do not.
More importanly, I cannot propogate changes made in the link table to QuickBooks. If I change any field in the link table, upon trying to save that record, I get the following error message:
ODBC--update on a linked table 'Item' failed.
[QODBC] Not supported (#10003)]
When looking at messages, in the QODBC setup dialog, I see the following:
2006-10-17 04:44:03 QODBC Ver: 7.00.00.194 *********************************************************************************************************************
IsAService: False
SQL Statement: UPDATE "Item" SET "Name"=?,"FullName"=? WHERE "ListID" = ? AND "EditSequence" = ?
Error Modify not supported on this table in BuildXMLHeader
Please let me know if this is a known limitation of the product ( I could not find any reference to it on the web), if this is some sort of limitation of the trial, or if this is a problem with the new version of the software.
Best Regards,
Matt Behr |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-10-18 09:49:30 |
The ITEM table is actually a read only view that's a combined list of all Item tables in QuickBooks: ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup; with minimum common fields. You should be using one of these tables instead of the ITEM table.
Note: Not all columns in a table are writable. See: Where are the schema rules for using QODBC? How do I use sp_columns? for the rules. |
|
|
|
|
|
| Posted : 2006-10-18 23:22:20 |
| Thanks for the prompt response. I will look at your solution this evening. |
|
|
|
|