| "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' |
|
|
|
