Does QODBC support the update of Custom Fields? |
Author |
Message |
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-02-22 09:10:29 |
Yes with QuickBooks 2005 onwards, you can update most of the custom fields. The Other, Other1, and Other2 are not updateable and some of the CustomFields on Line items. You can use the SP_COLUMNS tablename stored procedure command in VBDemo to get the EXACT table schema rules for the QuickBooks Company file you have open. The last few columns have Queryable, Updateable, Insertable, Required_On_Insert and the format ie:-
sp_columns TableName
the columns at the end will tell you if the custom fields are insertable and/or updateable.
|
|
|
|
Aco |
|
Group | : Members |
Posts | : 5 |
Joined | : 2007-01-09 |
|
Profile |
|
Posted : 2007-01-13 08:45:39 |
Will the purchase order and invoice custom fields be made available to insert data into them as well ?, |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-01-13 12:25:42 |
When using QuickBooks 2007 (USA version) Other, Other1, Other2 are now called CustomFieldOther, CustomFieldOther1, CustomFieldOther2 and are now all updateable. |
|
|
|
Aco |
|
Group | : Members |
Posts | : 5 |
Joined | : 2007-01-09 |
|
Profile |
|
Posted : 2007-01-14 10:37:23 |
when wiil the Australian version be updated ? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-01-14 10:59:36 |
Canada, UK and Australian versions of QuickBooks still currently use SDK v3 that was originally built for the USA version of QuickBooks 2004. The US version of QuickBooks 2007 in now on SDK v6 making the rest of the world three years behind the US. Our understanding that work is being done on a unified SDK which would mean we could move QODBC to it but we don't know when at this stage. In the case of Australia, the earliest possible update would be 2008.
Hence why I tell everyone to use sp_columns for the fields and rules of each QODBC table. |
|
|
|
Pino |
|
Group | : Members |
Posts | : 4 |
Joined | : 2007-05-02 |
|
Profile |
|
Posted : 2007-05-02 06:52:49 |
I've just purchased QODBC with the intent of integrating our QB Pro 2004 Wholesale & Manufacturing to a custom-developed application in MS Access for our inventory and shipping control. Surprised to find that I couldn't update a custom field in the Item Master. Is this limitation on QODBC particular to the 2004 version? If I were to be on a newer version of QB (ie: 2005) would I be able to do it? Very much appreciate your help on this matter. |
|
|
|
Pino |
|
Group | : Members |
Posts | : 4 |
Joined | : 2007-05-02 |
|
Profile |
|
Posted : 2007-05-02 07:05:27 |
I'm getting an error QODBC Update not supported #10003. I read on this thread that 2005 Custom Fields are updateable on other tables. Would that be the case of the Item Master? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-02 11:24:34 |
The Item table is a combined list (view) of all Items with minimum common fields from the ItemFixedAsset, ItemGroup, ItemInventory, ItemInventoryAssembly, ItemNonInventory, ItemOtherCharge and ItemService tables. It's a read only table. You need to use the actual table for the item concerned. |
|
|
|
Pino |
|
Group | : Members |
Posts | : 4 |
Joined | : 2007-05-02 |
|
Profile |
|
Posted : 2007-05-02 14:01:32 |
Thanks a lot Tom. That did it.
However, moving around on the linked table is quite slow. The processor seams to be quite busy.
Would it be any better if I tried it on a computer with faster processor and more RAM? If so how can I use my QODBC license from that computer instead of the one I just installed it on. Can I move it? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-02 14:50:26 |
Don't use a MS Access Datasheet grid, use a form, a append query or VBA code to enter custom field values. |
|
|
|
Pino |
|
Group | : Members |
Posts | : 4 |
Joined | : 2007-05-02 |
|
Profile |
|
Posted : 2007-05-02 15:59:38 |
I'll give it a try and report back. |
|
|
|
KofK |
|
Group | : Members |
Posts | : 43 |
Joined | : 2006-04-04 |
|
Profile |
|
Posted : 2007-05-09 02:46:35 |
Why doesn't it support INSERT? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-09 08:18:02 |
You must be talking about the Custom Fields in the Customer table. The actual rules why some custom fields are only updateable while others are both insertable and updateable is controlled entirely by Intuit's qbXML SDK for QuickBooks. Intuit does the rules, not QODBC. |
|
|
|
KofK |
|
Group | : Members |
Posts | : 43 |
Joined | : 2006-04-04 |
|
Profile |
|
Posted : 2007-05-10 00:11:49 |
I added two fields to my invoice by going to the Fixed Asset Item List -> Item -> New -> Custom Fields -> Define Fields. When I try to Insert information into these columns in the invoiceline table I get an error saying the the columns can not be inserted into. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-10 08:07:40 |
Please use the SP_COLUMNS tablename stored procedure command in VB Demo to get the EXACT table schema rules for the QuickBooks Company file you have open. The last few columns have Queryable, Updateable, Insertable, Required_On_Insert and the format ie:-
sp_columns TableName
The QuickBooks sample company file I'm using here has a number of custom fields thats are both UPDATEABLE and INSERTABLE:
|
|
|
|