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
|
|
Extracting printed checks information |
Author |
Message |
|
Posted : 2006-07-06 01:23:37 |
We are involved in a new project with our bank involving a 'Positive Payment' solution that requires I send them a file with the check summary data each time we do a check prining run. The example layout I received from this looks like this: (best viewed with a fixed font)
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8 RECONCILIATIONHEADER0075207990012345600000001000000005 20799001234560000071909000005100020040512 Abelman, Frayne & Schwab 20799001234560000071910000000200020040512 American Express 20799001234560000071911000000200020040512 Arizona Dept. of Revenue 20799001234560000071912000000200020040512 Arrow Electronics Inc. 20799001234560000071913000000200020040512 ASCOM Hasler Mailing Sys
I can mange the formatting if I can get the data into Access, but basically I need to grab the check number, check amount issue date, a void indicator if thats available, and the payee name.
can I do this? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-06 12:31:54 |
If you are paying bills each day and printing them in a daily batch, then you can try looking at:
SELECT RefNumber, Amount, TxnDate, Memo, PayeeEntityRefFullName FROM BillPaymentCheck where BankAccountRefFullname='Checking' and IsToBePrinted is NULL and TxnDate={fn CURDATE()} |
|
|
|
|
Posted : 2006-07-07 00:28:14 |
|
|
|
|