• 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…
  • Finding Lot numbers on Unconfirmed Deliveries

    Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…
  • 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…
  • AP / AR Aging Report Shows Fully Applied Invoices

    Hello, When i run the aged trial balance it shows fully applied invoices and payments. It is matched already and customer wants to see only outstanding documents. Are there any way to remove all applied documents from aging reports. Eranda
  • Record Print options greyed out

    After posting payment, the record print option is greyed out only the list button is active. I need help.
  • How to remove line number from the graphical report created using SQL query

    Dear Sagians, I have graphical report created using view and sql query, but the problem here after adding this into dashboard is instead of date, line number is coming[Below screenshot] Any ideas to display the date here. Note: When running the report…
  • 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…
  • 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…
  • 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…
  • 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…
  • 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.
  • batch job- crystal report

    hi, How can I have a crystal report batch job automatically default the parameters to the current date? As is now we have to manually change the task management every date to change the date range but we would like for the report to run automatically…
  • How to check a transaction is matched or not

    Dear Sagians, If you want to know weather a financial transaction such as invoice or payment is matched or not and if matched what is the match letter. Go to Financial > Inquiries > Entries and type the appropriate criteria then click search option…
  • Packaging Consumption in Work Orders

    I'm looking for ideas as to the best way to consume packaging in work orders. We sell products in various packaging....totes, drums, pails, etc. Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…
  • 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…
  • Tabbing through parameters in X3 V9

    Hello, has anyone had the following issues in version 9: -When tabbing through the fields in the parameters when trying to print a report, sporadically, it will enter fields with letters and not tab through properly. If so, is there a fix? -When in…
  • 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 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…
  • Resynchronizations

    Can anyone provide an interpretation of the Log Reading generated after running the ' Commitment Balances Resync ' - Function RECBLM - Financials / Utilities / Resynchronizations / Commitment Balances.
  • Dimension displaying In Purchase order.

    Hello, Please how can i design a report using crystal report to include the dimensions picked on the product lines.. Thanks
  • 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 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?
  • where are failed printed reports stored?

    When a report fails to print, is it being stored anywhere in the database?
  • HOW BEST TO SETUP CHART OF ACCOUNT

    I have a serious challenge in determining the best approach to this issue. A group called T has 3 sub groups called I,S,H respectively and they are into 3 different types of business.(advertising,security and digital board sales). Sub group I has…