| Can't Find Custom Fields in InvoiceLine in QuickBooks Online Edition |
| Author |
Message |
|
|
| Posted : 2009-02-05 05:23:43 |
Hello,
QBOE allows users to set up 3 custom fields that appear in invoices. I expected these to be accessible in the InvoiceLine table (or the Invoice table) but can't find the data anywhere. Am I missing something or is this data just not available in the online edition?
Thanks,
Dave |
|
|
|
|
|
| Posted : 2009-02-05 11:59:15 |
| The custom fields need to be setup first before QODBC will see them. The interface to QBOE is also old and may not support custom fields. |
|
|
|
|
|
| Posted : 2009-02-05 15:22:42 |
Thanks Tom,
The fields are set up, but they don't show up (and I've tried to use sp_optimizefullsync invoiceline as well). In any case, I wonder if you can verify that it's not supported.
Thanks,
Dave |
|
|
|
|
|
| Posted : 2009-02-05 22:16:25 |
Please use VB Demo (How do I use the VB Demo for testing? ) to run:
sp_columns InvoiceLine
and
sp_columns Invoice
to check whether the custom columns are avaliable to you or not. Most likely the custom fields will be in the Invoice table. |
|
|
|
|
|
| Posted : 2009-02-06 05:34:51 |
|
sp_columns InvoiceLine
and
sp_columns Invoice
yield the following and there are no custom fields
invoiceline
and invoice
|
|
|
|
|
|
| Posted : 2009-02-06 14:52:10 |
| Thanks for the screen dumps from QBOE. It looks like we haven't implemented Custom Fields when using QBOE. I will check with the QODBC Software Engineer whether it's avaliable in Intuit's qbXML SDK or not? |
|
|
|
|
|
| Posted : 2010-03-24 09:23:02 |
Hello again,
I've run into this issue again and it would be very helpful to have access to the Custom Fields within QBOE (within the invoiceline table). I wonder if you can revisit this and see if it can be added to the SDK?
Thanks,
Dave |
|
|
|
|
|
| Posted : 2010-03-24 10:12:45 |
| It's up to Intuit to add them to their qbXML SDK. I've just looked at the Intuit Developer Network and it still shows that QBOE does not support Data Extensions. |
|
|
|
