• 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…
  • Printing error

    HI All Please assist on how to resolve this error. It appears when trying to print any report in the system. The print server is configured and the service is running. Job 2 - ERR 262 coming from the edition server : Connection to the X3 file server…
  • Setting up ZPL Printer (Private Network) with Sage X3 (Cloud)

    Hello Everyone, We are trying to setup ZPL printer on Sage X3 but the problem we are facing is: a. ZPL printer is on a private (LAN) network - not accessible outside b. Sage X3 is on the cloud (Accessible only by a secured SSL URL) c. Sage X3…
  • 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…
  • ZPL List "cuting" my file

    Hello, I need help, i'm creating a PAT file using openo and wrseq with some ZPL code, that file is then called by a Report wich has been created using a ZPL list. The PAT file is created without any problem, but when i call the report the .DATA is generated…
  • 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???
  • Slow Performance during Report Phase Job Started and Printing X3 V12

    Hi, my company is in the middle of a migration from SAGE X3V5 to SAGE X3V12. R093.001.00019 When running a report in X3V12, the querying part (Job Started Phase with the green bars) takes an extra 1-3 minutes on average than it did in X3V5. In X3V5…
  • 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?
  • 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…
  • Positive Pay file generation

    When trying to generate the positive pay file - we experience the following error - file return error - no checks selected. There are checks generated and printed.
  • 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…
  • 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…
  • Scheduler Not Emailing Report

    Using SEI 8.2.0.38. I can email a worksheet, report etc. when I share it from the Command Center (Sharing>Email). When I schedule the same worksheet, report to email out, I don't receive an email. The Scheduler console shows that it ran and was Successful…
  • reporting

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