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 |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
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 |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
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
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
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? |
|
|
|