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
|
|
Invoice Template |
Author |
Message |
|
Posted : 2009-01-03 04:22:31 |
What is the relation field for customers and customer invoice templates. I need to post invoice but make sure that certain jobs/customers use a specific invoice template and the rest use another. I cannot find the relationship between the customer and the invoice template selected. Currently this is hard coded in my code (and if the user ever whacks the current template - i go into the weeds).
thanks for a great product. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-03 08:59:50 |
Sorry, there's no relationship between customers and customer invoice templates. QuickBooks simply uses the last invoice template I've used for any customer as far as I can see. To check what templates are being used by any customer or customer:job you can run:
SELECT DISTINCT TemplateRefFullName FROM Invoice where TxnDate> {d'2008-01-01'} and CustomerRefFullName = 'Lamb, Brad:Room Addition' |
|
|
|
|