|
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
|
|
| To be Printed Flag |
| Author |
Message |
|
|
| Posted : 2008-11-15 04:43:24 |
I have 3000 checks to be printed in QB Enterprise 7.0
Can I use QODBC to remove the to be printed flag on all of these and reset it on the transactions that I want? We have an internal file # that could be the primary key.
Thank you,
-Jeff |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-11-15 10:49:28 |
Providing you have a full read/write version of QODBC with a purchased a QODBC CDKey Code you could do:
Select * from BillPaymentCheck where IsToBePrinted = 1
and if these are all the checks you want to remove the IsToBePrinted flay on, then do:-
UPDATE BillPaymentCheck SET IsToBePrinted = False where IsToBePrinted = 1 |
|
|
|
|
|
| Posted : 2008-11-18 09:02:58 |
Thank you for your response.
Can I delete the flag except selected ones based upon a parameter like 'memo' or 'txn id'?
I have about 300 out of the 3000 that I would like to print now.
Or is there an easy way to take the flag off all of them and add it back to the desired ones? |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-11-18 10:13:50 |
Most likely you know a date for the old Checks you no longer want to print anymore. Try something like:
UPDATE BillPaymentCheck SET IsToBePrinted = False where IsToBePrinted = 1 and TxnDate < {d'2008-11-01'} |
|
|
|
|
|
| Posted : 2008-11-18 10:21:36 |
Unfortunately the dates span several days. In any case I will eventually want to print these.
My hope was to remove the flag on all but the 300 I want now. Then, in the future, use the same logic to work my way through the 3000. |
|
|
|
|