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…
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…
Group,
A question from a co worker was asked of me a couple weeks back, and I'm late asking this question. Does Sage have report cards, vendor grading capabilities? Doesn't have to be anything too complicated. The basics would be a great start. I really…
If Sage x3 Doesn't have a SOC 1 report than can we get something alternative to this. As SOC1 report is mandate to get the change management authorized.
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…
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…
Hi,
This may not be an error as much as a question as the internal workings of Sage X3. I've been setting up reports for our Sales department, but they weren't lining up wtih our Actuals. I realized that I was utilizing SORDER.SHIDAT_0 instead of SDELIVERYD…
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…
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…
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…
Hello,
I need to get a check register from Sage X3 but the report I am getting is incomplete, as it is not pulling all the checks that have been issued.
Reports->Reports->CHKREG->
I am selecting the right bank account, the right status, without…
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…
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…
Hi All,
I want to change report code for British declaration report. Hence can anyone help me to find out entry point for "British declaration" VAT return.
Please refer attached screen for your reference.
Declarations --> Tax management -->…
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…
I got a problem regarding the sales order report printing , it keeps on loading but it never print . I'm just asking why was this happen . It only happen with this particular SO number.
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…
How can I pull a report that will show the customer BP invoice. We have the sales invoice by lines report. But we want to connect information from the Customer BP Invoice.
We want all the information under this:
The inquiry does not output the…
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 did the following to the YSBONFAC Report.
When I print the report, the report does not break. But it does not out put the lot number either. Any recommendation. The lot number is on the delivery.
I have a recurring task set up to run a shipping availability report for our warehouse. The report parameters include a date which needs to be the current date plus 14 days. Is there a way to set the report parameters to accomplish this?