What process should be used if one person's checking account number (using the check reader as the entry point) is improperly associated with another giver's envelope number. I'm assuming that that is where the association is made.
Thanks,
Jeff
Disassociating a Checking Account Number
Moderators: Moderators, Tech Support
-
- Posts: 298
- Joined: Sat Oct 11, 2003 9:43 am
- Location: Great Bridge Church of God, Chesapeake VA
- Contact:
Disassociating a Checking Account Number
Jeff
--
Jeff Koke, KK4SN
Great Bridge Church of God
Chesapeake VA
"Every Father should remember that one day his
children will follow his example instead of his advice."
--
Jeff Koke, KK4SN
Great Bridge Church of God
Chesapeake VA
"Every Father should remember that one day his
children will follow his example instead of his advice."
-
- Posts: 298
- Joined: Sat Oct 11, 2003 9:43 am
- Location: Great Bridge Church of God, Chesapeake VA
- Contact:
Problem:
There are times when a check is mis-read by the checkreader and for some reason the PowerChurch associates the check's account with the wrong person.
This has occurred with two different checks during a single contribution entry session. Each time the mis-read check gets associated with the same person's account. These checks have been commercial in nature (refund checks, gov't checks, etc). (This is why I asked if there was a way to see and edit the checking accounts that are associated with a specific contributor.)
Is there any reason for this?
I've noticed that some checks seem to have the MICR (routing/account) numbers in a different order than a personal check. Is this possible?
I'd appreciate some insight to solving this as using the checkreader is a great time saver.
Thanks,
Jeff
There are times when a check is mis-read by the checkreader and for some reason the PowerChurch associates the check's account with the wrong person.
This has occurred with two different checks during a single contribution entry session. Each time the mis-read check gets associated with the same person's account. These checks have been commercial in nature (refund checks, gov't checks, etc). (This is why I asked if there was a way to see and edit the checking accounts that are associated with a specific contributor.)
Is there any reason for this?
I've noticed that some checks seem to have the MICR (routing/account) numbers in a different order than a personal check. Is this possible?
I'd appreciate some insight to solving this as using the checkreader is a great time saver.
Thanks,
Jeff
Jeff
--
Jeff Koke, KK4SN
Great Bridge Church of God
Chesapeake VA
"Every Father should remember that one day his
children will follow his example instead of his advice."
--
Jeff Koke, KK4SN
Great Bridge Church of God
Chesapeake VA
"Every Father should remember that one day his
children will follow his example instead of his advice."
-
- Tech Support
- Posts: 116
- Joined: Tue Sep 02, 2003 12:43 pm
- Location: PowerChurch Software
- Contact:
Regardless of the order of the numbers on the check, the check reader interprets what number is what based on other features on the checks themselves that distinguish the number as the routing number or account number. But the check reader is always going to send the information to PowerChurch in the format routing#/account#/check#.
Currently there is no other way of dissassociating a check number from a member other then changing the envelope when the system pulls them up. The only other way would be thru the Database, and unfortunately the routing and account numbers are encrypted so there is no easy way even thru the database.
Currently there is no other way of dissassociating a check number from a member other then changing the envelope when the system pulls them up. The only other way would be thru the Database, and unfortunately the routing and account numbers are encrypted so there is no easy way even thru the database.
-
- Posts: 298
- Joined: Sat Oct 11, 2003 9:43 am
- Location: Great Bridge Church of God, Chesapeake VA
- Contact:
As a follow-on to this thread, would it be possible to do the following using SQL?
1. Identify the contributor (by envelope number?)
2. Using a SQL statement, pull (to view) the account number associated with a specific contributor (even if it is encrypted), just to ensure that I have the correct contributor.
3. Using a SQL statement, zero or null the appropriate field(s).
4. Pull the same data back out of the database to ensure that it is zeroed.
Make sense? Do-able?
Thanks again,
Jeff
1. Identify the contributor (by envelope number?)
2. Using a SQL statement, pull (to view) the account number associated with a specific contributor (even if it is encrypted), just to ensure that I have the correct contributor.
3. Using a SQL statement, zero or null the appropriate field(s).
4. Pull the same data back out of the database to ensure that it is zeroed.
Make sense? Do-able?
Thanks again,
Jeff
Jeff
--
Jeff Koke, KK4SN
Great Bridge Church of God
Chesapeake VA
"Every Father should remember that one day his
children will follow his example instead of his advice."
--
Jeff Koke, KK4SN
Great Bridge Church of God
Chesapeake VA
"Every Father should remember that one day his
children will follow his example instead of his advice."
-
- Tech Support
- Posts: 116
- Joined: Tue Sep 02, 2003 12:43 pm
- Location: PowerChurch Software
- Contact:
The file involved with the check reader process is called coscan.DBF and its formatted as follows:
KEY (the routing, account, and check # encrypted), ENV_NO , LAST_CO
I am unfortunatly not familiar enough with SQL to be able to give you those commands. There are some commands you could use through the database manager. We generally don't like to publish those commands, so if it something you are not familiar with and don't already know, we would ask that you give us a call to go thru using some of those commands.
KEY (the routing, account, and check # encrypted), ENV_NO , LAST_CO
I am unfortunatly not familiar enough with SQL to be able to give you those commands. There are some commands you could use through the database manager. We generally don't like to publish those commands, so if it something you are not familiar with and don't already know, we would ask that you give us a call to go thru using some of those commands.
Actually, all you would have to do is delete this entry from that table.Zeb wrote:The file involved with the check reader process is called coscan.DBF and its formatted as follows:
KEY (the routing, account, and check # encrypted), ENV_NO , LAST_CO
I am unfortunatly not familiar enough with SQL to be able to give you those commands. There are some commands you could use through the database manager. We generally don't like to publish those commands, so if it something you are not familiar with and don't already know, we would ask that you give us a call to go thru using some of those commands.
In SQL it should be sometthing to the effect of:
DELETE FROM COSCAN
WHERE KEY = (routing,account,check#)
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
-
- Tech Support
- Posts: 116
- Joined: Tue Sep 02, 2003 12:43 pm
- Location: PowerChurch Software
- Contact:
since this is an encrypted field, I am not sure how well that would work. You could say delete from coscan where env_no = <your persons envelope number>NeilZ wrote:Actually, all you would have to do is delete this entry from that table.Zeb wrote:The file involved with the check reader process is called coscan.DBF and its formatted as follows:
KEY (the routing, account, and check # encrypted), ENV_NO , LAST_CO
I am unfortunatly not familiar enough with SQL to be able to give you those commands. There are some commands you could use through the database manager. We generally don't like to publish those commands, so if it something you are not familiar with and don't already know, we would ask that you give us a call to go thru using some of those commands.
In SQL it should be sometthing to the effect of:
DELETE FROM COSCAN
WHERE KEY = (routing,account,check#)
Yep ... you're right . I missed that encrypted in that field. Using the env_no is easier, and safer !!Zeb wrote:since this is an encrypted field, I am not sure how well that would work. You could say delete from coscan where env_no = <your persons envelope number>NeilZ wrote:Actually, all you would have to do is delete this entry from that table.Zeb wrote:The file involved with the check reader process is called coscan.DBF and its formatted as follows:
KEY (the routing, account, and check # encrypted), ENV_NO , LAST_CO
I am unfortunatly not familiar enough with SQL to be able to give you those commands. There are some commands you could use through the database manager. We generally don't like to publish those commands, so if it something you are not familiar with and don't already know, we would ask that you give us a call to go thru using some of those commands.
In SQL it should be sometthing to the effect of:
DELETE FROM COSCAN
WHERE KEY = (routing,account,check#)
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.