If your Crystal check form is using a "SpellMoney(ToText..." formula, you might try changing it to a "propercase ( ToWords...." formula.  It is pretty much the same formula other than that, but if you need the whole thing, just let me know.

Hi Jim,

If you can provide me with the whole formula, that would be great.  I will glad to give it a go.

I am puzzled, why the trouble in the first place.  

Thank you.

Hi Ingolf Sage implement newer versions of the Crystal Reporting engine with newer versions of Sage 300 and occasionally SAP drop support for Crystal Functions in newer releases.  There was actually a press release from Sage regarding SpellMoney a couple of years ago I remember and am trying to find which explained what to do.  I definitely recall it but haven't located it yet.  It might be in the What's New for Sage 300 2023...

OK according to my research, the SpellMoney function was dropped natively for Crystal Reports version 12 and the DLL required for SpellMoney seems to sometimes not get re-installed with Sage 300 as expected (who knows).  In any case, (and this is bringing back memories), you can normally fix it by locating the correct DLLs off the older Sage 300 system post-upgrade, off the net or by searching your system (maybe just in wrong location) and copying them to the correct location.  I found an article where someone has dealt with this - hope it helps https://www.baass.com/blog/crystal-reporting-spell-money-function (Credit: BAASS Business Solutions).

This is the formula I use:

numberVar numDec :=ToNumber({?EXTPARAM1});
if ({?ALIGNMENT} = "Y") then
 ReplicateString("X",40)
else
 if Right (ToText ({BKREG.SISSUED}), 3) = ".00" Then
  ProperCase (Towords({BKREG.SISSUED},0)+" and 00/100 U.S. Dollars******"
else
  ProperCase(Towords({BKREG.SISSUED},numDec))+" U.S. Dollars******"

Hi Jim,

Thank you for the formula. Very much appreciated.

I have entered the formula. It does generate some errors when saving. I am not familiar enough with the formula to make the necessary corrections to make it work.

To simplify, try just the last line of the formula:

  ProperCase(Towords({BKREG.SISSUED},2))+" U.S. Dollars******"

This assumes that (a) you don't care if it's an alignment check, your currency is USD, your currency is 2 decimals, and you don't care if says "and 00/100" vs just the number.  if you need those other features of the formula, build out from here once you get this one working.

To simplify, try just the last line of the formula:

  ProperCase(Towords({BKREG.SISSUED},2))+" U.S. Dollars******"

This assumes that (a) you don't care if it's an alignment check, your currency is USD, your currency is 2 decimals, and you don't care if says "and 00/100" vs just the number.  if you need those other features of the formula, build out from here once you get this one working.