Sage X3

I have a stored procedure and crystal report I created. I have reviewed the permissions on the stored procedure and the schema. When I run the report in PILOT and also in PRODUCTION, I get the same message: Job 47636 - ERR 504 coming from the edition…

Hello All, Please i need amount in word formula, the one am using is not coming out very well. Please find screen shot below. This is the formula that i 'm using below. Propercase(ToWords(truncate(Sum ({PORDERQ.LINAMT_0})),0) + ' Naira and…

Good day, When trying to print a report that has the standard TRT script and a SPE script linked to it, we get the error IMPRIME : Non-existent Label @X3.TRT/AIMP3$adx(1279) : @X3.TRT/AIMP3$adx(877):AIMP3.IMPRIME @X3.TRT/AIMP1$adx(98):AIMP1.EXEC…

Has anybody tried printing a crystal report via web services by creating a subprogram? If so, could you please send some examples so I can take a look at what was done to get this accomplished? If not, anybody got any ideas on the best approach for this…

Hello All, Please i did a USD transaction in purchase order, while printing purchase order report, i notice the exchange rate is not displaying on the report. Please how will i go about it in crystal report.. Thanks Samuel

Hello I need to be able to manipulate the data from field TEXCLOB.TEXTE_0 in my Crystal report by splitting it to create new fields. The problem I have is that the data contains formatting characters for rtf and this contains endless combinations of font…

I'm using Sage X3 (7.1.6); I'm writing a crystal report that needs to include the value of all stock as at the end of last month. Are there any simple ways to get this value? Or further still, how would I get the value of stock as at the end of…