Sage 100

This just in from client.

When we print an AP check with zero cents, it is printing out the words "One Hundred and XX/100".      How do I edit the formula to get it to read 00/100 instead of printing XX's?

I have looked at formula there is no apparent to to change the "XX".  Can anyone confirm?

TIA

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Jeff - This is what my my ap check formula says....
formula = "*" + Uppercase(ToWords({AP_CheckWrk.CheckAmt},2))

Is yours different?

------------------------------
Randy Marion
------------------------------

Yep, that is it.  where do you swap out the "XX" for "00".

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 02-08-2019 09:59
From: Randy Marion
Subject: AP Check Template Wording

Jeff - This is what my my ap check formula says....
formula = "*" + Uppercase(ToWords({AP_CheckWrk.CheckAmt},2))

Is yours different?

------------------------------
Randy Marion
------------------------------

The only thing I can think of would be text manipulation of that formula result.  If it ends in XX/100 then grab everything up to that point, and replace the remaining characters with 00/100.
Of course, even better would be to tell them this is a programmed function, and a known standard format.  Changing it is not easy, nor recommended.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 02-08-2019 11:34
From: Jeff Schwenk
Subject: AP Check Template Wording

Yep, that is it.  where do you swap out the "XX" for "00".

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 02-08-2019 09:59
From: Randy Marion
Subject: AP Check Template Wording

Jeff - This is what my my ap check formula says....
formula = "*" + Uppercase(ToWords({AP_CheckWrk.CheckAmt},2))

Is yours different?

------------------------------
Randy Marion

IT probably because it is a whole number, and not actually using decimals? Maybe doublecheck in DFDM, you can mod the formula to replace the xx with 00:

(replace(towords(...),"xx/","00/"))

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2)"xx/","00/")

I haven't tested that, so you might need to swap the replace and the towords.

*edit, I copied in the original formula from a oneNote from a while back, the second formula is my best guess as to the replacement.
------------------------------
Michelle Forsey
Eide Bailly, Inc.
801-456-5470
------------------------------

Original Message:
Sent: 02-08-2019 11:34
From: Jeff Schwenk
Subject: AP Check Template Wording

Yep, that is it.  where do you swap out the "XX" for "00".

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 02-08-2019 09:59
From: Randy Marion
Subject: AP Check Template Wording

Jeff - This is what my my ap check formula says....
formula = "*" + Uppercase(ToWords({AP_CheckWrk.CheckAmt},2))

Is yours different?

------------------------------
Randy Marion

I like Michelle's replace syntax too.
(If you're not aware, ToWords is a Crystal Reports function, based on a number input... with the xx/100 output being automatic with no options).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 02-08-2019 11:59
From: Michelle Forsey
Subject: AP Check Template Wording

IT probably because it is a whole number, and not actually using decimals? Maybe doublecheck in DFDM, you can mod the formula to replace the xx with 00:

(replace(towords(...),"xx/","00/"))

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2)"xx/","00/")

I haven't tested that, so you might need to swap the replace and the towords.

*edit, I copied in the original formula from a oneNote from a while back, the second formula is my best guess as to the replacement.
------------------------------
Michelle Forsey
Eide Bailly, Inc.
801-456-5470
------------------------------


Original Message:
Sent: 02-08-2019 11:34
From: Jeff Schwenk
Subject: AP Check Template Wording

Yep, that is it.  where do you swap out the "XX" for "00".

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 09:59
From: Randy Marion
Subject: AP Check Template Wording

Jeff - This is what my my ap check formula says....
formula = "*" + Uppercase(ToWords({AP_CheckWrk.CheckAmt},2))

Is yours different?

------------------------------
Randy Marion

You could use a conditional.   For example, if the amount is $100.00;

If right({AP_CheckWrk.CheckAmt},2)=0
then
( Uppercase(ToWords({AP_CheckWrk.CheckAmt},0)) + "and 00/100"
else
( Uppercase(ToWords({AP_CheckWrk.CheckAmt},2))

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 02-08-2019 11:34
From: Jeff Schwenk
Subject: AP Check Template Wording

Yep, that is it.  where do you swap out the "XX" for "00".

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 02-08-2019 09:59
From: Randy Marion
Subject: AP Check Template Wording

Jeff - This is what my my ap check formula says....
formula = "*" + Uppercase(ToWords({AP_CheckWrk.CheckAmt},2))

Is yours different?

------------------------------
Randy Marion

Actually, Michelle's solution looks better than mine and not sure mine will work.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 02-08-2019 12:02
From: Doug Higgs
Subject: AP Check Template Wording

You could use a conditional.   For example, if the amount is $100.00;

If right({AP_CheckWrk.CheckAmt},2)=0
then
( Uppercase(ToWords({AP_CheckWrk.CheckAmt},0)) + "and 00/100"
else
( Uppercase(ToWords({AP_CheckWrk.CheckAmt},2))

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------


Original Message:
Sent: 02-08-2019 11:34
From: Jeff Schwenk
Subject: AP Check Template Wording

Yep, that is it.  where do you swap out the "XX" for "00".

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 09:59
From: Randy Marion
Subject: AP Check Template Wording

Jeff - This is what my my ap check formula says....
formula = "*" + Uppercase(ToWords({AP_CheckWrk.CheckAmt},2))

Is yours different?

------------------------------
Randy Marion

Wow, I thought I was anal-retentive.

------------------------------
- Brett
------------------------------

Kinda my thought.  This is the first in 20 years for me.  These are the same folks that were hand writing checks for over a year (most vendors paid via bank's DD portal) and took five months after I recommended they start printing checks in house......

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 02-08-2019 16:37
From: Brett Zimmerman
Subject: AP Check Template Wording

Wow, I thought I was anal-retentive.

------------------------------
- Brett
------------------------------

I managed to get the formula not to error out but the below attempt did not result in any bell ringing or eureka moments.  "xx/" still appeared.

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2),"xx/","00/"))

Any other thoughts out there?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 02-08-2019 19:43
From: Jeff Schwenk
Subject: AP Check Template Wording

Kinda my thought.  This is the first in 20 years for me.  These are the same folks that were hand writing checks for over a year (most vendors paid via bank's DD portal) and took five months after I recommended they start printing checks in house......

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 02-08-2019 16:37
From: Brett Zimmerman
Subject: AP Check Template Wording

Wow, I thought I was anal-retentive.

------------------------------
- Brett

I just tested the following and it works:

new formula @LengthOfSpelledOutAmount
length({@SpelledOutCheckAmount})

new formula  @TEST1
left({@SpelledOutCheckAmount},{@LengthOfSpelledOutAmount}-8)

new formula @newSpelledOutCheckAmount
{@TEST1} + " " + right(totext({AP_CheckWrk.CheckAmt}),2) + " / 100"

Of course you can use different formula names and combine the formulas if you wish.  I did this quick and dirty a piece at a time to get it working.
​​​

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 02-10-2019 17:04
From: Jeff Schwenk
Subject: AP Check Template Wording

I managed to get the formula not to error out but the below attempt did not result in any bell ringing or eureka moments.  "xx/" still appeared.

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2),"xx/","00/"))

Any other thoughts out there?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 02-08-2019 19:43
From: Jeff Schwenk
Subject: AP Check Template Wording

Kinda my thought.  This is the first in 20 years for me.  These are the same folks that were hand writing checks for over a year (most vendors paid via bank's DD portal) and took five months after I recommended they start printing checks in house......

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 16:37
From: Brett Zimmerman
Subject: AP Check Template Wording

Wow, I thought I was anal-retentive.

------------------------------
- Brett

see attached sample.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 02-10-2019 17:04
From: Jeff Schwenk
Subject: AP Check Template Wording

I managed to get the formula not to error out but the below attempt did not result in any bell ringing or eureka moments.  "xx/" still appeared.

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2),"xx/","00/"))

Any other thoughts out there?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 02-08-2019 19:43
From: Jeff Schwenk
Subject: AP Check Template Wording

Kinda my thought.  This is the first in 20 years for me.  These are the same folks that were hand writing checks for over a year (most vendors paid via bank's DD portal) and took five months after I recommended they start printing checks in house......

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 16:37
From: Brett Zimmerman
Subject: AP Check Template Wording

Wow, I thought I was anal-retentive.

------------------------------
- Brett

Interesting.  Thanks.  Client will be happy.  Now back to the Grammies​.  Sad that Dollie is the only one I know so far....

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 02-10-2019 18:21
From: Doug Higgs
Subject: AP Check Template Wording

see attached sample.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------


Original Message:
Sent: 02-10-2019 17:04
From: Jeff Schwenk
Subject: AP Check Template Wording

I managed to get the formula not to error out but the below attempt did not result in any bell ringing or eureka moments.  "xx/" still appeared.

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2),"xx/","00/"))

Any other thoughts out there?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 19:43
From: Jeff Schwenk
Subject: AP Check Template Wording

Kinda my thought.  This is the first in 20 years for me.  These are the same folks that were hand writing checks for over a year (most vendors paid via bank's DD portal) and took five months after I recommended they start printing checks in house......

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 16:37
From: Brett Zimmerman
Subject: AP Check Template Wording

Wow, I thought I was anal-retentive.

------------------------------
- Brett

You better start getting some ideas for Karaoke night.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 02-10-2019 21:28
From: Jeff Schwenk
Subject: AP Check Template Wording

Interesting.  Thanks.  Client will be happy.  Now back to the Grammies​.  Sad that Dollie is the only one I know so far....

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 02-10-2019 18:21
From: Doug Higgs
Subject: AP Check Template Wording

see attached sample.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 02-10-2019 17:04
From: Jeff Schwenk
Subject: AP Check Template Wording

I managed to get the formula not to error out but the below attempt did not result in any bell ringing or eureka moments.  "xx/" still appeared.

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2),"xx/","00/"))

Any other thoughts out there?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 19:43
From: Jeff Schwenk
Subject: AP Check Template Wording

Kinda my thought.  This is the first in 20 years for me.  These are the same folks that were hand writing checks for over a year (most vendors paid via bank's DD portal) and took five months after I recommended they start printing checks in house......

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 16:37
From: Brett Zimmerman
Subject: AP Check Template Wording

Wow, I thought I was anal-retentive.

------------------------------
- Brett

I am thinking a medley of Queen's greatest hits.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 02-10-2019 21:38
From: Doug Higgs
Subject: AP Check Template Wording

You better start getting some ideas for Karaoke night.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------


Original Message:
Sent: 02-10-2019 21:28
From: Jeff Schwenk
Subject: AP Check Template Wording

Interesting.  Thanks.  Client will be happy.  Now back to the Grammies​.  Sad that Dollie is the only one I know so far....

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-10-2019 18:21
From: Doug Higgs
Subject: AP Check Template Wording

see attached sample.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 02-10-2019 17:04
From: Jeff Schwenk
Subject: AP Check Template Wording

I managed to get the formula not to error out but the below attempt did not result in any bell ringing or eureka moments.  "xx/" still appeared.

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2),"xx/","00/"))

Any other thoughts out there?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 19:43
From: Jeff Schwenk
Subject: AP Check Template Wording

Kinda my thought.  This is the first in 20 years for me.  These are the same folks that were hand writing checks for over a year (most vendors paid via bank's DD portal) and took five months after I recommended they start printing checks in house......

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 16:37
From: Brett Zimmerman
Subject: AP Check Template Wording

Wow, I thought I was anal-retentive.

------------------------------
- Brett

Don't tease me with that....

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, and Cagney
Beth Bowers
269-445-1625
------------------------------

Original Message:
Sent: 02-11-2019 10:30
From: Jeff Schwenk
Subject: AP Check Template Wording

I am thinking a medley of Queen's greatest hits.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 02-10-2019 21:38
From: Doug Higgs
Subject: AP Check Template Wording

You better start getting some ideas for Karaoke night.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 02-10-2019 21:28
From: Jeff Schwenk
Subject: AP Check Template Wording

Interesting.  Thanks.  Client will be happy.  Now back to the Grammies​.  Sad that Dollie is the only one I know so far....

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-10-2019 18:21
From: Doug Higgs
Subject: AP Check Template Wording

see attached sample.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 02-10-2019 17:04
From: Jeff Schwenk
Subject: AP Check Template Wording

I managed to get the formula not to error out but the below attempt did not result in any bell ringing or eureka moments.  "xx/" still appeared.

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2),"xx/","00/"))

Any other thoughts out there?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 19:43
From: Jeff Schwenk
Subject: AP Check Template Wording

Kinda my thought.  This is the first in 20 years for me.  These are the same folks that were hand writing checks for over a year (most vendors paid via bank's DD portal) and took five months after I recommended they start printing checks in house......

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 16:37
From: Brett Zimmerman
Subject: AP Check Template Wording

Wow, I thought I was anal-retentive.

------------------------------
- Brett

Will there be a cover charge to hear you perform the Queen songs?

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 02-11-2019 10:30
From: Jeff Schwenk
Subject: AP Check Template Wording

I am thinking a medley of Queen's greatest hits.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 02-10-2019 21:38
From: Doug Higgs
Subject: AP Check Template Wording

You better start getting some ideas for Karaoke night.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 02-10-2019 21:28
From: Jeff Schwenk
Subject: AP Check Template Wording

Interesting.  Thanks.  Client will be happy.  Now back to the Grammies​.  Sad that Dollie is the only one I know so far....

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-10-2019 18:21
From: Doug Higgs
Subject: AP Check Template Wording

see attached sample.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 02-10-2019 17:04
From: Jeff Schwenk
Subject: AP Check Template Wording

I managed to get the formula not to error out but the below attempt did not result in any bell ringing or eureka moments.  "xx/" still appeared.

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2),"xx/","00/"))

Any other thoughts out there?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 19:43
From: Jeff Schwenk
Subject: AP Check Template Wording

Kinda my thought.  This is the first in 20 years for me.  These are the same folks that were hand writing checks for over a year (most vendors paid via bank's DD portal) and took five months after I recommended they start printing checks in house......

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 16:37
From: Brett Zimmerman
Subject: AP Check Template Wording

Wow, I thought I was anal-retentive.

------------------------------
- Brett

@Doug Higgs - Yes, it is called shots of Patron!  I hope your remember the drill from two years ago.  @Beth Bowers - We Will ROCK You!!!! ​​

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 02-11-2019 11:20
From: Doug Higgs
Subject: AP Check Template Wording

Will there be a cover charge to hear you perform the Queen songs?

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------


Original Message:
Sent: 02-11-2019 10:30
From: Jeff Schwenk
Subject: AP Check Template Wording

I am thinking a medley of Queen's greatest hits.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-10-2019 21:38
From: Doug Higgs
Subject: AP Check Template Wording

You better start getting some ideas for Karaoke night.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 02-10-2019 21:28
From: Jeff Schwenk
Subject: AP Check Template Wording

Interesting.  Thanks.  Client will be happy.  Now back to the Grammies​.  Sad that Dollie is the only one I know so far....

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-10-2019 18:21
From: Doug Higgs
Subject: AP Check Template Wording

see attached sample.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 02-10-2019 17:04
From: Jeff Schwenk
Subject: AP Check Template Wording

I managed to get the formula not to error out but the below attempt did not result in any bell ringing or eureka moments.  "xx/" still appeared.

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2),"xx/","00/"))

Any other thoughts out there?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 19:43
From: Jeff Schwenk
Subject: AP Check Template Wording

Kinda my thought.  This is the first in 20 years for me.  These are the same folks that were hand writing checks for over a year (most vendors paid via bank's DD portal) and took five months after I recommended they start printing checks in house......

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 16:37
From: Brett Zimmerman
Subject: AP Check Template Wording

Wow, I thought I was anal-retentive.

------------------------------
- Brett

You got it!  Whatever it takes to keep you on the "stage".

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 02-11-2019 13:29
From: Jeff Schwenk
Subject: AP Check Template Wording

@Doug Higgs - Yes, it is called shots of Patron!  I hope your remember the drill from two years ago.  @Beth Bowers - We Will ROCK You!!!! ​​

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 02-11-2019 11:20
From: Doug Higgs
Subject: AP Check Template Wording

Will there be a cover charge to hear you perform the Queen songs?

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 02-11-2019 10:30
From: Jeff Schwenk
Subject: AP Check Template Wording

I am thinking a medley of Queen's greatest hits.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-10-2019 21:38
From: Doug Higgs
Subject: AP Check Template Wording

You better start getting some ideas for Karaoke night.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 02-10-2019 21:28
From: Jeff Schwenk
Subject: AP Check Template Wording

Interesting.  Thanks.  Client will be happy.  Now back to the Grammies​.  Sad that Dollie is the only one I know so far....

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-10-2019 18:21
From: Doug Higgs
Subject: AP Check Template Wording

see attached sample.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 02-10-2019 17:04
From: Jeff Schwenk
Subject: AP Check Template Wording

I managed to get the formula not to error out but the below attempt did not result in any bell ringing or eureka moments.  "xx/" still appeared.

formula = "*" + Uppercase(Replace(ToWords({AP_CheckWrk.CheckAmt},2),"xx/","00/"))

Any other thoughts out there?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 19:43
From: Jeff Schwenk
Subject: AP Check Template Wording

Kinda my thought.  This is the first in 20 years for me.  These are the same folks that were hand writing checks for over a year (most vendors paid via bank's DD portal) and took five months after I recommended they start printing checks in house......

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 02-08-2019 16:37
From: Brett Zimmerman
Subject: AP Check Template Wording

Wow, I thought I was anal-retentive.

------------------------------
- Brett