Hi Ingolf have you updated your customization directory to the correct location on the new server, and put your check form in the correct AP7xA\ENG and or BK7xA\ENG folders where that directory resolves?  Is the check using a font missing on the new RDS or workstation?  Maybe post a screenshot of the bad result blurring out any sensitive details so we can get an idea of the error?  What version did you upgrade from, maybe its as simple as a field incompatibility or some broken check form customisation - try a factory check form just to see if its a Crystal Template issue.  Good luck!

Hi,

Upgrade was from Sage 300 2022 PU3 to 2023 PU1.

I tried testing with a standard Sage cheque template.  APCHK11A.rpt  It is the same issue. 

The aplha text check amount will print just ******** or  **Dollar** in the space.  For example, should print  *** one thousand one hundred forty***.

I have noticed this same issue on two different workstations and different systems.  One was operating Sage 300 2023 PU1 and other with 2024 PU1.

Thank you for your response.

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.

This!  I forgot in a previous Crystal revision the SpellMoney function was dropped or something to that effect.  Adding the DLL for the SpellMoney function might restore it but long term as Jim says, just use ToWords instead.

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.