Sage X3

I need to make adjustments to the way our purchase orders are displayed. How do I do that?

Is there a report that shows me the 12 month usage, current inventory, and the safety stock for all raw materials within a certain category? I buy hundreds of chemicals for my company, and I want to be able to view on one report the 12 month history/usage…

We have a lot of Chinese customers and will prefer products name to appear in their language. How can I make this characters print on reports (Invoices)

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.

I am trying to run the CLOPER REPORT. When I run the report it flashes but nothing happens.

When we have created a Works Order, we need to print a set of reports. We have created the reports on the Entry Transactions and they list on the File>>Print Menu. We have to then print the set of reports one by one. I would like to find out how can I…

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…

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…

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.

Hi, Does X3 have a report that shows what is owed by a customer. This would be any open invoices that have not been paid. FAHAD

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

I have a Crystal report that runs a script to generate a table which is then used to create the report. I have edited the script to alter the data in the report but the changes I made are not showing up in the report or in the table that the script builds…

How do I "refresh" the translation files (menueng, menufra etc.) located in the folder root catalogue. Somehow they are created from local menues, but I don't know how. When I change some translations in local menus it has no impact in my Crystal…

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…

When users print that Available stock screen using the PRTSCN report the dates don't line up with the columns they represent. Is there a way to modify the PRTSCN report? It's not listed in the Reports > Reports section. Not sure if the picture below will…

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?

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

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?

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…

Hi there, I am reading the XML file by using RDSEQ, but the problem here is its not reading line by line, instead its reading no. line at time. Please advise !

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

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.

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…

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…