• Workflow send crystal report pdf with different parameters

    Good day, I'm trying to use workflow standard rules to send a pdf (report created in crystal) to some users. Standard usege works fine for me, but I need to send, in my case, an sell order printed with different setup (for example outside with prices…
  • [v12p34] Unable to print Crystal Report dynamic image pulled from HTTP on a HTTPS website

    Hi, Context: - Sage X3 v12p34, single-tier (HTTPS; currently having issue) - AI image server (HTTP, inside Sage X3 v12p34 server, address used assume: http://localhost:58888/) - Sage X3 v12p26, single-tier (HTTPS; control) - Crystal Report 2020…
  • Running a Crystal Report with a range parameter from Web Services using (CWSGPRTRT) Generic Print Report

    We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…
  • Generate separate PDF files of invoices from Crystal Report and send them by email to customers

    Dear community, we are trying to understand if a specific action is achievable with Crystal Reports. At the moment we are printing invoices by customer and invoices range and we get one PDF file with all the invoices inside. This file is then sent…
  • ActiveFax Codes Not Reading on PDF Exports with Version 12 (Solved)

    The problem: When printing PDF files generated through X3 V12 to ActiveFax with the goal of automating email & print jobs; ActiveFax cannot read the codes despite having the font successfully installed on the server, pointing to the font in the crystal…
  • Work Order Costing with Sales Costing

    I'm trying to create a Crystal Report that will show the costing of work orders, but of course, they had to add in a twist. I need to be able to show the sales cost along with it. It would kind of be like the sales invoice line inquiry where it shows…
  • Printing image attachment from Products to the Job Ticket

    I'm very new to Sage X3. Does anyone know if it's possible to have an image that is attached to a product print on the Job Ticket report maybe as a subreport? I have tried everything I can think of in Crystal Reports but I'm not getting anywhere. Thanks…
  • Sage X3 V12P26 Print Server error when printing reports created from Crystal Reports for Enterprise when testing for future QR code purpose

    Hi all, I have a client purchased a Crystal Server 2020 license due to its support of QR code generation over the normal Crystal Reports 2020 which required third-party additions which the client is uncomfortable about purchasing additional third-party…
  • Phone formatting in Crystal Reports

    Does anyone have a suggestion on how to format the phone numbers based on the country's phone number format? Since the table doesn't show the formatted entry (which really makes no sense), I need to create a formula in Crystal, but isn't there an easier…
  • Blank report

    Someone long time ago showed me the way to check the rpt results and why is failing, it was on one of the X3 folders, anybody knows???
  • Crystal Report Duplicating Net Invoice

    Good day It appears that when I select to print multiple copies of an invoice from the enter parameter screen it will multiply the net invoice amount based on the number of copies you select to print. Can anyone please assist?
  • Crystal Report to Print not displaying values, but to .pdf it will.

    Howdy It looks like when I print directly from X3 to the printer I'm not getting my net invoice amount, it appears as #########, but if I do a .pdf preview it is there. Any suggestions?
  • Error 504 - Missing Parameters - Stored Procedure

    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…
  • Crystal report reverts to SANDBOX mode even though the *.rpt file was not modified

    We have a v12 client with a Workflow that runs nightly and emails a PDF attachment. On at least two occasions the first record triggered generated an email without the attachment but the remaining records processed in that same execution of the Workflow…
  • Link between MACHINES and CONTSERV

    Is anyone familiar with linking the MACHINES (Installed base) and CONTSERV (Service Contracts) tables? I am trying to create a crystal report to print from the installed base screen with a summary of all the related service contracts. From the installed…
  • link between Gaccentry and Bank

    Hi. Is there a table, where I can find the link between Gaccentry and Bank? Thanks in advance. MatteoS
  • Sage X3 on Multicore VM

    Dear Experts, we have a strange problem. Sage X3 is allocating only one core for tasks launched from each of the terminals. The system is running in a VM with a 4x4 (4 Physical each with 4 logical cores) configuration. But while creating a big report…
  • Parameter Prompting for Labels

    I am using Sage X3 V11 with Crystal 2013 to create a new label. Is it possible to prompt for report parameters when using the Print Stock Labels function? I am hoping to enter values for the label that are not currently stored in Sage as parameters.
  • Add certificate at pdf and send via email

    Hi Everybody IS there the possibility of adding a certificate when generating a pdf invoice, and automatically sendind it by email? Right now we send pdf invoices by email, but I don't know if can add a certificate to pdf before. Has anyone encountered…
  • Sage X3 Translation to Traditional Chinese

    Hi All, As per the requirement we are working on the translation(to traditional Chinese-Taiwan language) and were able to translate the most of the text, screens, windows. We are now working on the translation of all reports. We would like to know…
  • How to print petty cash statement

    Hello, I want to use the report "Bank Account in Ledgers Report" for petty cash accounts as well. While printing the report under parameter section, i can see the petty cash accounts but when i click on bank selection it says record does not exists…
  • Invoice PDF via Web Service

    Has anybody ever generated a .pdf of an invoice, or other document in X3, using web services? I have a request to make invoice copies available to an external source, and I want to try to do it somehow using web services.
  • Corrupt font size in Document forms

    Just now we realized, that SAGE print server reduce font size for 0.5 points. Tested on different SAGE version (8.4 ...11.2) In document forms used a different type of fonts: Arial, Calibri .. etc. Is it a common problem or there is some fix for it…
  • "Urgent Help" Crystal Report Amount in Words Formula

    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…
  • reporting

    Hi can anyone assist on how to link a crystal report to an inquiry screen