Crystal Report - APCHK03 does not display the cheque amount in text after upgrade to 2018

Question

We have a customer that has used APCHK03 for many years and then after an upgrade to Sage 300 2018, that form does not display the cheque text amount. The report itself looks OK in Crystal. Any suggestions? It is a standalone machine running Windows 10.

Ron Boyd · Accepted Answer

Sage300 does not use the SpellMoney function anymore and sometimes when a function does not work well Crystal does not show a value 
 top part below if 5.6 bottom part is 6.5 
 numberVar numDec :=ToNumber({?EXTPARAM1}); if ({?ALIGNMENT}="Y") then ReplicateString("X",40) else SpellMoney(ToText({BKREG.SISSUED},10,""),ToText(numDec),{BKREG.LANGUAGE},"0")+"******" ===================== numberVar numDec :=ToNumber({?EXTPARAM1}); if ({?ALIGNMENT}="Y") then ReplicateString("X",40) else //SpellMoney(ToText({BKREG.SISSUED},10,""),ToText(numDec),{BKREG.LANGUAGE},"0")+"******" if Right(ToText({BKREG.SISSUED}), 3) = ".00" Then Towords({BKREG.SISSUED},0)+" and 00/100 ******" else Towords({BKREG.SISSUED},numDec)+"******"

Sage 300

Crystal Report - APCHK03 does not display the cheque amount in text after upgrade to 2018

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING