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
|
|
Create Invoice from Bill |
Author |
Message |
|
Posted : 2008-08-29 03:17:05 |
Currently our users of quickbooks create bills and then invoice those bills via the time and costs area of the invoice. This is different than the typical example of invoicing by using an invoice item. Do you have an example of how to accomplish this using QODBC? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-29 08:26:06 |
There's no simple SQL Statement to do this. You would need to read the BillExpenseLine and BillItemLine tables, extract the appropriate rows that require invoicing, create the invoice lines and store a link reference in a custom field and then update another custom field in the BillExpenseLine and BillItemLine tables to show they these expenses have been on-billed.
See also: Generate report from InvoiceLine, BillItemLine, BillExpenseLine |
|
|
|
|