Sage X3

Hello All, I have an interesting ask from our User base. We have Word Documents that are required to be printed when ever as a Check sheet each time a user prints a work order. Here's the twist the Word documents are unique to each product or groups of…

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…

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…

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…

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, 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…

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, 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…

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…

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…

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.

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…

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 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…

Hi all - I'm using Microsoft Query to extract info from the system and it appears whats happening is if the item has a few bin location the data is being returned in that manner meaning I could have the same item listed a few times Looking for a means…

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…

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…

Hello everybody I want the steps to add a report to Sage x3 V11 please.

I am trying to run the following query but its giving me an error. Any suggestion on how it can be fixed.

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.

Some fields in our X3 db were renamed. SEI process currently refers to old field names. Is it possible to remap field references in process? I was hoping to be able to update references in the relevant process files in CentralPoint. But this hasn…