• [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…
  • X3 V12 - Barcode Font (IDAutomationHC39M) Not working on Crystal Reports

    On X3 version 6.5 (and version 5) we installed font IDAutomationHC39M.ttf on client computers to get barcodes to show on crystal reports. With V12 I figured I would have to install the font on the server(s). I installed the font on both the application…
  • 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???
  • 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?
  • Using SQL Function in SQL Requester

    Hi, I am creating a simple SQL Requester which will pull back data from 2 tables - PREQUIS and ACLOB. I wish to use a SQL Function I have to convert the CLOB Text from RTF to 'readable' text. This works fine in SQL, but when I try in the SQL Requester…
  • Open Items Report for BP

    Hi, I want to run a report for a specific BP/Customer and I would like this report to show a complete list of all transactions for the customers - open and closed, invoices, CMs, DMs. I want to see 2 columns, one showing original amount and one column…
  • For Pivots, why is the grouping and data staggered?

    I'm trying to automate reporting for my organization. However when utilizing SEI's pivot function, it staggers the groups from the data itself making the data useless upon exporting to Excel. I'm hoping there's some setting where I can have a more traditional…
  • 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…
  • why aged balance report showing separate line for currency revaluation (CURVA) instead of embedded in each invoice?

    In the standard report - BALAGEHIST and normal BALAGEGRP - the detail aged balance is showing currency revaluation as a separate line. Can this revaluation entry show at individual invoice instead as for audit purpose - it will not be transparent to show…
  • 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…
  • Functional Profile Report

    Hi, I wonder if you can help me please? I'd like to create a report / pull data from SQL which would show a list of all User Profiles, along with all of the Functions they have access to - is this possible? If so, which tables would I use? Thank…
  • reporting

    Hi can anyone assist on how to link a crystal report to an inquiry screen
  • Pass user's default facility through Landing Page to linked report (x3v11)

    I've created a number of reports intended for Facility Managers to access through a link I made on their Landing Page. What I would like to do is pass their default facility through to the report to restrict the data they can retrieve to just that which…
  • Sage X3 - Print reports to Email

    Good afternoon. With the need of one of my clients to send all kind of reporting by email we came across a problem. We used the ARP event to manage the workflows so they could send the message with their report as an attachment. This worked smoothly…
  • How to send crystal report by mail

    We have a report file that is generats a PDF and we need to send it by mail once it was generated. Documentation says that we can use "REPORT" entry point to do that. After some tests, we see that "REPORT" subroutine is called before the report file…
  • How can I run a crystal report standalone?

    Hi All, I get the error message "The system cannot find the path specified" when I try to run a report. The print log file was not helpful for me. In order to better debug the problem I would like to run the crystal report without X3, because I…
  • Dimensions to display PO(purchase order) Reports. SageX3

    Hello All. Please how can i make dimension print out on purchase order (PO) report.
  • Blank Report

    Hi there, We have an issue where a few users are trying to run a report but it is producing a blank PDF. The same users can run other reports fine. Other users who have a different user profile can run this report fine. This points to the user…
  • How can i convert number to Text in crystal repport SAP

    i used this function: ProperCase( ToWords(10000, 0) ) //Dix Mille but how can i convert in two language french and english
  • How do I make adjustments to a crystal report?

    I need to make adjustments to the way our purchase orders are displayed. How do I do that?