I had the same problem and here is how I fixed it.
I used an ODBC connection through Excel to open Checkhed, found the bad
check number and put in a low number (like 100). Saved and that fixed it.
You must be very careful though as there are no safeguards to protect you
from really hosing up your data.
Jim Carnes
IS Administrator
Kenlee Precision Corporation
1700 Morrell Park Ave
Baltimore, MD 21230
410-525-3800 x132
jcarnes@...
-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Thursday, October 17, 2002 11:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Check number
At 11:04 AM 10/17/2002 -0400, you wrote:
uses an index on CheckHed to determine the highest number for that
bank. To fix it, you would have to delete the offending check or change
its number. There is no way in the standard system to do this.
You can create a new bank code identical with your current one, and start
using that (and retire the old code).
If you have ProVision or can hire or persuade someone with it to whip up a
program, you could write a zero value over the check number
(CheckHed.CheckNum) to fix it. Since you've probably voided the check,
your GL would still balance. But if you ever tried to match APTran to the
check data, you would not have a perfect match.
-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071
83:HM/A=1278098/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b3089010792061
6000>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
I used an ODBC connection through Excel to open Checkhed, found the bad
check number and put in a low number (like 100). Saved and that fixed it.
You must be very careful though as there are no safeguards to protect you
from really hosing up your data.
Jim Carnes
IS Administrator
Kenlee Precision Corporation
1700 Morrell Park Ave
Baltimore, MD 21230
410-525-3800 x132
jcarnes@...
-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Thursday, October 17, 2002 11:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Check number
At 11:04 AM 10/17/2002 -0400, you wrote:
>How do you change the check number currently loaded default value. WhenIt's not stored as a counter anywhere. Each time you print checks, Vantage
>Vantage was originally installed they entered in a large false number.
>Now, every time they print checks that number is the current check
uses an index on CheckHed to determine the highest number for that
bank. To fix it, you would have to delete the offending check or change
its number. There is no way in the standard system to do this.
You can create a new bank code identical with your current one, and start
using that (and retire the old code).
If you have ProVision or can hire or persuade someone with it to whip up a
program, you could write a zero value over the check number
(CheckHed.CheckNum) to fix it. Since you've probably voided the check,
your GL would still balance. But if you ever tried to match APTran to the
check data, you would not have a perfect match.
-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=237459.2482214.3895589.2146399/D=egroupweb/S=17050071
83:HM/A=1278098/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b3089010792061
6000>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]