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.
Hi,
We use a report to create a label for quality control, printing the report some fields are automatically filled to save time like QC Number / Product Code as unique in the Quality control.
Is it possible when several data are possible to select…
We have just switched to V12. I am wanting to export information from various pages.
Is there a way to personalise an export spreadsheet to suit my requirements?
Some of the information I require is:
Product SKU
Product Description
Pack
…
Hello There,
I need help in Sage x3 Aged Balance report (BALAGEGRP), which I need to add more intervals in it. The report already shows the following intervals:
0-30 Days
31-60 Days
61-90 Days
+91 Days
What I need to do is add 2 more intervals…
Hello,
When i try to print a report via PDF, the font is smaller than if i do it directly to a printer.
I don't know why this happens, the report is the same for the 2 options. Shouldn't the final document be the same for the 2 options?
Thanks in…
Hi,
Since this past Friday Dec 17 2021 we have started to experience a weird behaviour where for some users the SBONFACP Report generated via printing on (Sales >> Sales Invoice) does not print out to PDF, it remains showing the progress bar moving…
Hi all, Our client uses the Calculate Expected cost function (Manufacturing) That prints the Expected cost type report without the actual and expected costs for these workcenters. I've attached reports how it is blank in the first image. However a few…
Hi All,
We have completed the migration from v6.5 to v12. But while printing the standard reports we are getting error.The architecture of the system is multi-tier i.e. application server and Database server are both on different server. Please refer…
X3 generates a log file of every transaction in X3. This log can be found under Reports and Log Reading. The issue is that you cannot find the log number of a specific transaction from the actual transaction and the log list doesn't always give transaction…
How do I connect to the same database set: This is what I need to connect to.
When I click on the left list. It is bringing in the table from different set.
I am trying to find out what are all the sales invoices, that have not been paid per specific site. I am using the Inquiry under sales->List of invoices.
Can I make this search even more specific, for not paid.
Trying to get a handle on purchase cost over time for our Raw Materials.
I cannot find a report or dashboard for this type of information. What am I missing.
How are others solving this issue?
Noel
Hi,
I want to make two versions of the BOMPRN printouts available to users via Production BOMs. However I can't find the print code to do so. The original BOMPRN report isn't listed in Paramters>Destinations>Print Codes.
Any ideas?
Thanks
Hi,
i need to print two report in just one click transaction. I have created two separately reports that take the same parameters. How can i to print one after another?
As shown in the preview image I added a row in "Crystal Report" section in Dictionary…
Hi,
I need create one webservice to return the result of one Crystal Report (PDF for example).
So, I use function ETAT to generate the result of report (PDF format) to specific location,after that I need return this file to Web, any idea how I can…
Tired of your current boring Invoice templates and wish you could spruce them up a little bit? Well, now you can. Download these crystal reports and make sure the last impression you leave is a lasting one.
Download Now
These set of templates have…
Hi Israel,
Sorry to bother you again, but I have yet another question. I'm trying to do as you've shown me for search criteria, but I seem to be running into a small issue. I have 2 fields that are joined. I have the following query:
SELECT F.ITMREF_0…
When we are attaching a report(PDF) in email, the attachment takes a name like 'jobrpt_ReportCode_UserCode_Number'. Is it possible to change the default naming style to change a name which could be meaningful. E.g. If Purchase Order, attachment should…
Hi Ben:
Could you please provide some more details on what do you mean by "SQL command"
Standard reports in X3 have parameters in them that allow the report to connect properly when launched within Sage ERP X3.
For example if you open Tabcountry…