"Other 2" in Invoice Template |
Author |
Message |
Cody |
|
Group | : Members |
Posts | : 4 |
Joined | : 2008-09-30 |
|
Profile |
|
Posted : 2008-09-30 07:16:47 |
I'm trying to use this connection to build some non-quickbooks looking invoices based off invoices which are already created. Unfortunately I can't seem to find a field or it's not accessible via the driver.
What I have is a Invoice which is being created via a template.
Line items are put into a group which is printed, the group has a "Service Period" and "Service Location" which are set using Other 1 and Other 2 columns on the template.
I can access these in the DB when they are set on a line item, but not on a group.
Any idea where to pull these from? |
|
|
|
Cody |
|
Group | : Members |
Posts | : 4 |
Joined | : 2008-09-30 |
|
Profile |
|
Posted : 2008-09-30 09:15:33 |
QODBC - 8.00.00.242
QB Ver - 2007 |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-09-30 10:01:43 |
If you look at: How do I invoice item groups? you will see that QODBC simply inserts a InvoiceLineGroupItemGroupRefListID for the group and QuickBooks goes away and actually inserts all the group lines for the group. So there's no way to set the CustomFieldInvoiceLineOther1 or CustomFieldInvoiceLineOther2 values for a group line.
If might be easier to read the ItemGroup and just insert all the invoice lines yourself with the CustomFieldInvoiceLineOther1 or CustomFieldInvoiceLineOther2 values you require instead. |
|
|
|
Cody |
|
Group | : Members |
Posts | : 4 |
Joined | : 2008-09-30 |
|
Profile |
|
Posted : 2008-09-30 10:13:32 |
I'm not trying to insert, but rather read the CustomFieldInvoiceLineOther2 which is set on a group. I just can't find where that value is being stored. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-09-30 12:48:27 |
Ok the columns you are really looking for are: CustomFieldInvoiceLineGroupOther1 and CustomFieldInvoiceLineGroupOther2 |
|
|
|
Cody |
|
Group | : Members |
Posts | : 4 |
Joined | : 2008-09-30 |
|
Profile |
|
Posted : 2008-10-01 02:23:14 |
Tom -
Looks like both those columns are blank for every row.
Any other ideas? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-01 13:12:50 |
Try running:
SELECT * from InvoiceLine UNOPTIMIZED where RefNumber='1234' |
|
|
|