Conditional Formatting Check Numbers on AP Checks

Yahoo Archive
1
Yes, the output file needs to run on a daily schedule before 9:00 pm. It looks for payments for that day and brings in the appropriate data in a txt file. If for some reason the file does not get picked up, then all AP Payments not processed up to that point need to be in that file

--- On Wed, 5/13/09, Sean McDaniel <smcdanie@...> wrote:


From: Sean McDaniel <smcdanie@...>
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks
To: vantage@yahoogroups.com
Date: Wednesday, May 13, 2009, 12:33 PM








Are you wanting to set up something like a CSV file for output to the bank?

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Vic Drecchio
Sent: Wednesday, May 13, 2009 11:51 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks

Mark,

I created a Positive Pay report in Crystal Reports for our bank.

I kept it "raw" meaning no formatting, etc. I then have the user generating
the Positive Pay report print to a "text" printer driver instead of a
physical printer. Works like a charm.

If you are interested I'd be willing to share the BAQ Query, BAQ Report and
corresponding Crystal Report.

For the printer driver, Google: "Miraplacid Text Driver"

Vic

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf Of Mark Wagner
Sent: Wednesday, May 13, 2009 11:32 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks

I also need to create an output file to the bank for a positive pay
verification. I see I can update the crystal report form to display the
zeros but when I query the AP Payment for my output file of course it is
only the payment number from Vantage and not what is displayed on the report
with leading zeros. My question is can I convert the payment number with
leading zeros using SQL so my output file has the correct number of
characters?

--- On Wed, 5/13/09, Vic Drecchio <vic.drecchio@ timco.aero
<mailto:vic. drecchio% 40timco.aero> > wrote:

From: Vic Drecchio <vic.drecchio@ timco.aero
<mailto:vic. drecchio% 40timco.aero> >
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Date: Wednesday, May 13, 2009, 8:55 AM

Mark,

In Crystal Reports, create a formula and use this syntax:

Right(("0000000000" + ToText({APCHECKNUM_ FIELD},0, "")),10)

Insert that formula on the check form.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Mark Wagner
Sent: Wednesday, May 13, 2009 8:39 AM
To: Vantage User Group
Subject: [Vantage] Conditional Formatting Check Numbers on AP Checks

I need to always have a 10 digit check number when we send checks to the
bank for scanning, which means if I have a 5 digit payment number I need to
add 5 leading zeros, 8 charcters I need to add 2 leading zeros, etc.

Has anyone written a condition that would auto populate the leading zeros
based on the number of characters for the AP Payment?

[Non-text portions of this message have been removed]

------------ --------- --------- ------

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/ linksYahoo! Groups Links

[Non-text portions of this message have been removed]

------------ --------- --------- ------

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/.
<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/ linksYahoo! Groups Links

[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]
2
I need to always have a 10 digit check number when we send checks to the bank for scanning, which means if I have a 5 digit payment number I need to add 5 leading zeros, 8 charcters I need to add 2 leading zeros, etc.
Â
Has anyone written a condition that would auto populate the leading zeros based on the number of characters for the AP Payment?




[Non-text portions of this message have been removed]
3
Can this not be done through the formatting of the number? If not I would
convert the number to a string count the characters then add the correct
number of zeros. Adding the leading zeros would need to be done through a
loop.



IF you need some code written up let me know I'll sling something together.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wagner
Sent: Wednesday, May 13, 2009 8:39 AM
To: Vantage User Group
Subject: [Vantage] Conditional Formatting Check Numbers on AP Checks








I need to always have a 10 digit check number when we send checks to the
bank for scanning, which means if I have a 5 digit payment number I need to
add 5 leading zeros, 8 charcters I need to add 2 leading zeros, etc.

Has anyone written a condition that would auto populate the leading zeros
based on the number of characters for the AP Payment?

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
4
Mark,

In Crystal Reports, create a formula and use this syntax:

Right(("0000000000" + ToText({APCHECKNUM_FIELD},0,"")),10)


Insert that formula on the check form.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Wednesday, May 13, 2009 8:39 AM
To: Vantage User Group
Subject: [Vantage] Conditional Formatting Check Numbers on AP Checks

I need to always have a 10 digit check number when we send checks to the bank for scanning, which means if I have a 5 digit payment number I need to add 5 leading zeros, 8 charcters I need to add 2 leading zeros, etc.
Â
Has anyone written a condition that would auto populate the leading zeros based on the number of characters for the AP Payment?




[Non-text portions of this message have been removed]



------------------------------------

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/linksYahoo! Groups Links
5
stringvar test := '';



test := CStr (table.numberfield)



test := Left (test, (length (test) - 3));



while Length (test) < 10 Do

(

test := '0' + test;

);



test;



Hope this helps.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Wednesday, May 13, 2009 8:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks








Can this not be done through the formatting of the number? If not I would
convert the number to a string count the characters then add the correct
number of zeros. Adding the leading zeros would need to be done through a
loop.

IF you need some code written up let me know I'll sling something together.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Mark Wagner
Sent: Wednesday, May 13, 2009 8:39 AM
To: Vantage User Group
Subject: [Vantage] Conditional Formatting Check Numbers on AP Checks

I need to always have a 10 digit check number when we send checks to the
bank for scanning, which means if I have a 5 digit payment number I need to
add 5 leading zeros, 8 charcters I need to add 2 leading zeros, etc.

Has anyone written a condition that would auto populate the leading zeros
based on the number of characters for the AP Payment?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
6
That's very slick right there. Nice one Vic.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vic Drecchio
Sent: Wednesday, May 13, 2009 8:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks








Mark,

In Crystal Reports, create a formula and use this syntax:

Right(("0000000000" + ToText({APCHECKNUM_FIELD},0,"")),10)

Insert that formula on the check form.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Mark Wagner
Sent: Wednesday, May 13, 2009 8:39 AM
To: Vantage User Group
Subject: [Vantage] Conditional Formatting Check Numbers on AP Checks

I need to always have a 10 digit check number when we send checks to the
bank for scanning, which means if I have a 5 digit payment number I need to
add 5 leading zeros, 8 charcters I need to add 2 leading zeros, etc.

Has anyone written a condition that would auto populate the leading zeros
based on the number of characters for the AP Payment?

[Non-text portions of this message have been removed]

------------------------------------

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.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
7
Try this. A bit simpler (without a loop):

//Set up the length of your final "filled" string

numbervar StringLength:=10;

numbervar x:=123;

stringvar test;

//Create a filler string that will be contatenated to the left of the number

stringvar FillString:=replicatestring('0',StringLength);

//Get rid of decimal's

test := replace(totext(x),".00","");

//grab the right "x" characters

test := right(FillString & test,StringLength);



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Wednesday, May 13, 2009 8:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks








stringvar test := '';

test := CStr (table.numberfield)

test := Left (test, (length (test) - 3));

while Length (test) < 10 Do

(

test := '0' + test;

);

test;

Hope this helps.
~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Charlie Wilson
Sent: Wednesday, May 13, 2009 8:44 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks

Can this not be done through the formatting of the number? If not I would
convert the number to a string count the characters then add the correct
number of zeros. Adding the leading zeros would need to be done through a
loop.

IF you need some code written up let me know I'll sling something together.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Mark Wagner
Sent: Wednesday, May 13, 2009 8:39 AM
To: Vantage User Group
Subject: [Vantage] Conditional Formatting Check Numbers on AP Checks

I need to always have a 10 digit check number when we send checks to the
bank for scanning, which means if I have a 5 digit payment number I need to
add 5 leading zeros, 8 charcters I need to add 2 leading zeros, etc.

Has anyone written a condition that would auto populate the leading zeros
based on the number of characters for the AP Payment?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
8
I also need to create an output file to the bank for a positive pay verification. I see I can update the crystal report form to display the zeros but when I query the AP Payment for my output file of course it is only the payment number from Vantage and not what is displayed on the report with leading zeros. My question is can I convert the payment number with leading zeros using SQL so my output file has the correct number of characters?

--- On Wed, 5/13/09, Vic Drecchio <vic.drecchio@...> wrote:


From: Vic Drecchio <vic.drecchio@...>
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks
To: vantage@yahoogroups.com
Date: Wednesday, May 13, 2009, 8:55 AM








Mark,

In Crystal Reports, create a formula and use this syntax:

Right(("0000000000" + ToText({APCHECKNUM_ FIELD},0, "")),10)

Insert that formula on the check form.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Mark Wagner
Sent: Wednesday, May 13, 2009 8:39 AM
To: Vantage User Group
Subject: [Vantage] Conditional Formatting Check Numbers on AP Checks

I need to always have a 10 digit check number when we send checks to the bank for scanning, which means if I have a 5 digit payment number I need to add 5 leading zeros, 8 charcters I need to add 2 leading zeros, etc.
Â
Has anyone written a condition that would auto populate the leading zeros based on the number of characters for the AP Payment?

[Non-text portions of this message have been removed]

------------ --------- --------- ------

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/ linksYahoo! Groups Links



















[Non-text portions of this message have been removed]
9
Mark,

I created a Positive Pay report in Crystal Reports for our bank.

I kept it "raw" meaning no formatting, etc. I then have the user generating the Positive Pay report print to a "text" printer driver instead of a physical printer. Works like a charm.

If you are interested I'd be willing to share the BAQ Query, BAQ Report and corresponding Crystal Report.

For the printer driver, Google: "Miraplacid Text Driver"


Vic


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Wednesday, May 13, 2009 11:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks

I also need to create an output file to the bank for a positive pay verification. I see I can update the crystal report form to display the zeros but when I query the AP Payment for my output file of course it is only the payment number from Vantage and not what is displayed on the report with leading zeros. My question is can I convert the payment number with leading zeros using SQL so my output file has the correct number of characters?

--- On Wed, 5/13/09, Vic Drecchio <vic.drecchio@...> wrote:


From: Vic Drecchio <vic.drecchio@...>
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks
To: vantage@yahoogroups.com
Date: Wednesday, May 13, 2009, 8:55 AM








Mark,

In Crystal Reports, create a formula and use this syntax:

Right(("0000000000" + ToText({APCHECKNUM_ FIELD},0, "")),10)

Insert that formula on the check form.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Mark Wagner
Sent: Wednesday, May 13, 2009 8:39 AM
To: Vantage User Group
Subject: [Vantage] Conditional Formatting Check Numbers on AP Checks

I need to always have a 10 digit check number when we send checks to the bank for scanning, which means if I have a 5 digit payment number I need to add 5 leading zeros, 8 charcters I need to add 2 leading zeros, etc.
Â
Has anyone written a condition that would auto populate the leading zeros based on the number of characters for the AP Payment?

[Non-text portions of this message have been removed]

------------ --------- --------- ------

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/ linksYahoo! Groups Links



















[Non-text portions of this message have been removed]



------------------------------------

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/linksYahoo! Groups Links
10
Are you wanting to set up something like a CSV file for output to the bank?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vic Drecchio
Sent: Wednesday, May 13, 2009 11:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks








Mark,

I created a Positive Pay report in Crystal Reports for our bank.

I kept it "raw" meaning no formatting, etc. I then have the user generating
the Positive Pay report print to a "text" printer driver instead of a
physical printer. Works like a charm.

If you are interested I'd be willing to share the BAQ Query, BAQ Report and
corresponding Crystal Report.

For the printer driver, Google: "Miraplacid Text Driver"

Vic

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Mark Wagner
Sent: Wednesday, May 13, 2009 11:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks

I also need to create an output file to the bank for a positive pay
verification. I see I can update the crystal report form to display the
zeros but when I query the AP Payment for my output file of course it is
only the payment number from Vantage and not what is displayed on the report
with leading zeros. My question is can I convert the payment number with
leading zeros using SQL so my output file has the correct number of
characters?

--- On Wed, 5/13/09, Vic Drecchio <vic.drecchio@...
<mailto:vic.drecchio%40timco.aero> > wrote:

From: Vic Drecchio <vic.drecchio@...
<mailto:vic.drecchio%40timco.aero> >
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Wednesday, May 13, 2009, 8:55 AM

Mark,

In Crystal Reports, create a formula and use this syntax:

Right(("0000000000" + ToText({APCHECKNUM_ FIELD},0, "")),10)

Insert that formula on the check form.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Mark Wagner
Sent: Wednesday, May 13, 2009 8:39 AM
To: Vantage User Group
Subject: [Vantage] Conditional Formatting Check Numbers on AP Checks

I need to always have a 10 digit check number when we send checks to the
bank for scanning, which means if I have a 5 digit payment number I need to
add 5 leading zeros, 8 charcters I need to add 2 leading zeros, etc.

Has anyone written a condition that would auto populate the leading zeros
based on the number of characters for the AP Payment?

[Non-text portions of this message have been removed]

------------ --------- --------- ------

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/ linksYahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

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/.
<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/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
11
Thats a nice approach. We need to output to a mapped drive with a unique file name (typically the date) so that would work. So in your scenario the leading zeros are added in Crystal and then become part of the text file. The only thing I can think of that might come up is someone depending on a user to create the file. In the case where the file is not created for some reason they want all the payment records that have not processed to be included in the next file. Good things to consider though. Thanks!

--- On Wed, 5/13/09, Vic Drecchio <vic.drecchio@...> wrote:


From: Vic Drecchio <vic.drecchio@...>
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks
To: vantage@yahoogroups.com
Date: Wednesday, May 13, 2009, 11:51 AM








Mark,

I created a Positive Pay report in Crystal Reports for our bank.

I kept it "raw" meaning no formatting, etc. I then have the user generating the Positive Pay report print to a "text" printer driver instead of a physical printer. Works like a charm.

If you are interested I'd be willing to share the BAQ Query, BAQ Report and corresponding Crystal Report.

For the printer driver, Google: "Miraplacid Text Driver"

Vic

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Mark Wagner
Sent: Wednesday, May 13, 2009 11:32 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks

I also need to create an output file to the bank for a positive pay verification. I see I can update the crystal report form to display the zeros but when I query the AP Payment for my output file of course it is only the payment number from Vantage and not what is displayed on the report with leading zeros. My question is can I convert the payment number with leading zeros using SQL so my output file has the correct number of characters?

--- On Wed, 5/13/09, Vic Drecchio <vic.drecchio@ timco.aero> wrote:

From: Vic Drecchio <vic.drecchio@ timco.aero>
Subject: RE: [Vantage] Conditional Formatting Check Numbers on AP Checks
To: vantage@yahoogroups .com
Date: Wednesday, May 13, 2009, 8:55 AM

Mark,

In Crystal Reports, create a formula and use this syntax:

Right(("0000000000" + ToText({APCHECKNUM_ FIELD},0, "")),10)

Insert that formula on the check form.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf Of Mark Wagner
Sent: Wednesday, May 13, 2009 8:39 AM
To: Vantage User Group
Subject: [Vantage] Conditional Formatting Check Numbers on AP Checks

I need to always have a 10 digit check number when we send checks to the bank for scanning, which means if I have a 5 digit payment number I need to add 5 leading zeros, 8 charcters I need to add 2 leading zeros, etc.
Â
Has anyone written a condition that would auto populate the leading zeros based on the number of characters for the AP Payment?

[Non-text portions of this message have been removed]

------------ --------- --------- ------

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/ linksYahoo! Groups Links

[Non-text portions of this message have been removed]

------------ --------- --------- ------

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/ linksYahoo! Groups Links



















[Non-text portions of this message have been removed]