Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
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…
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…
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.
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…
Hi! i´m trying to edit the SBONFACP crystal report with the parameters values.
So i tried to print it in rpt format and later open with the SAP crystal reports.
When i tried to open it i have this error: "Unable to find language and/or path in…
Does anyone have details notes on how to add a new crystal report to show up in SAGEX3. The report has been developed on crystal but I want it to show up as an option under printer in PO. It is a copy of BONCDE report with a little modification but I…
I have a report I built from scratch. Pretty simple, only 4 tables and one parameter to fill.
I added it to the directory, then thereport dictionary, then set up the default values and then the print code.
The report is visible after I hit "Record…
Hello Guys,
I am just a newbie here in this forum and hoping to get along with you all.
Moreover, I am about to support a newly implemented ERP system in-house through a post implementation phase and am just wondering what are the proper steps and…
We currently have customer that accept Back orders. On the sales order the user is able to input items that are on back order. However, if a product is on back order the invoice form drops that product.
The sales order:
This is the invoice: The…
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?