x Want to participate? Join the group to interact

  • Can stored procedure be used in X3 to run Crystal reports

    Hi, I am new to X3, but not to ERP systems. Have lots of experience with SQL and Crystal reports. This is the issue I am having, I have created a custom report for a client, and have created a stored procedure to run the report. The report is…

  • Part time software consultant - Sage X3 ERP

    We need Sage X3 ERP software consultant Company Details: Mavin Infotech Location: Hyderabad Job Type: Part Time Mavin Infotech is seeking an experienced X3 consultant. Remote opportunity available.The ideal candidate will Have a working…

  • Views in Crystal Reports for update 9

    Hello, Does anyone know if it's not possible anymore to add views in Crystal Reports for update 9? In Crystal after picking the folder, it doesn't show the option for views anymore. Can anyone help on this? Best regards, Nuno Roque

  • Running a report through X3 off a SQL query

    I wrote a SQL query to calculate our Broker commissions. When I try to run the report through X3, I get the below error. Can I not use a query in a report run through X3?

  • Sage x3 - Crystal Reports error - YSORD01.rpt : Table does not exist

    I've copied an existing report in our Sage X3 called SORD01.rpt, make the report directory and print code. This all works fine, but when I come to run the report, no parameters are present and also I get the error of "YSORD01.rpt : Table does not exist…

  • RE: crystal report Sage x3 integration

    Ven, Integrating a report into Sagex3 v7 is a multi-step process. As I understand the process you need to do the following: 1. Point the report to the V7 database if you're moving it from an older version You do this in Crystal Reports using the…

  • Zebra label print

    I am using zebra Gx430t label printer to get my labels with crystal reports 2013 for Sage X3. Having difficulties while printing landscape. Either not printing or printing so huge text or too small. can anyone help with right printer settings. Also my…

  • Historical Stock Valuation

    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…

  • Sage X3 version 8.0.4 while printing - Report was not found in storage area

    Sage X3 version 8.0.4 while printing - Report was not found in storage area

  • SAP Crystal Reports Viewer software

    Does anyone know the cost of the Report editor and viewer built into X3? It is off-the-shelf software and is it possible to buy it directly from Sage and how many licenses does it normally come with? Any comments are welcome. Thank you.

  • Date Format v7/PU8 for Reports

    Changing the Locale setting's Regional Preferences from en-US to en-GB for example correctly displays the UK date format online - but reports still display the date in en-US format. Question: how to have UK user's reports print using the en-GB (d/m…

  • Miscellaneous Tables in Crystal Report

    I want to add a Long Description from a Miscellaneous table to a Crystal Report. I have a field in SORDER table linked to the Misc Table as an ADI. What do I need to add into Crystal to get the linked Long Description, I assume it is ATABDIV / ATEXTRA…

  • How to call / print a crystal report from code

    Using X3V7, currently on patch 5. I'm wanting to use a Recurring Task to run some code which will conditionally call / print a crystal report. I will need to pass the SO number to the report. Does anyone have any information on how to do this? Thanks…

*Community Hub is the new name for Sage City