|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Add Time/Costs to Invoice |
| Author |
Message |
|
|
| Posted : 2008-11-24 10:50:21 |
The Invoice form has a button at the bottom labeled "Add Time/Costs ...". Our accountant tells me that this must be set for some transactions. I am using the following statement for normal invoices:
sSQL = "" & _
"INSERT INTO QB_InvoiceLine ( " & _
"RefNumber, PONumber, TermsRefListID, CustomerRefListID, " & _
"DueDate, TxnDate, InvoiceLineItemRefListID, " & _
"Memo, InvoiceLineDesc, InvoiceLineQuantity, " & _
"InvoiceLineRate, InvoiceLineSalesTaxCodeRefListID, " & _
"FQSaveToCache ) " & _
"VALUES ( '" & _
rIS!InvoiceID & "', '" & rIS!PO_Num & "', '" & Nz(rIS!ARTermsListID, sARTermsID) & "', '" & rIS!CustomerListID & "', #" & _
rIS!DueDate & "#, #" & rIS!InvoiceDate & "#, '" & rIS!ItemRefListID & "', '" & _
sMemo & "', '" & Replace(rIS!DetailType, "'", "") & "', " & Nz(rIS!Qty, 1) & ", " & _
Nz(rIS!Rate, rIS!Charge) & ", '" & Nz(rIS!SalesTaxCodeRefListID, sNonTaxID) & "', " & _
IIf(iCnt < iLines, 1, 0) & " );"
DoCmd.RunSQL sSQL
How do I effectively set that option on some invoices?
Thanks,
Chris |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-11-25 17:28:18 |
The "Add Time/Costs..." is an actual QuickBooks application process itself that adds lines to an invoice. With QODBC you need to find this information yourself first and then create your own INSERT statements to add time/costs manually.
See: Billable Payroll - Need to Display More Fields on Invoice for further information. |
|
|
|
|