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…

HI All Please assist on how to resolve this error. It appears when trying to print any report in the system. The print server is configured and the service is running. Job 2 - ERR 262 coming from the edition server : Connection to the X3 file server…

I made a copy of the X3 Purchase Orders data model. When I try to create a new view off of that data model (only the copy, not the original), the folders inside of Dimensions and Data Measures are showing in French. Everything in set up is set to english…

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…

Hello, I need help, i'm creating a PAT file using openo and wrseq with some ZPL code, that file is then called by a Report wich has been created using a ZPL list. The PAT file is created without any problem, but when i call the report the .DATA is generated…

Hi, I was wondering if anyone else had a similar issue when building graphical view on SEI. On the screenshot bellow, for each product category on the legend I get duplicates of the column's description. Thanks in advance for your help. Tar…

Anyone know how automatically show only the last 30 days data?

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…

When trying to generate the positive pay file - we experience the following error - file return error - no checks selected. There are checks generated and printed.

Hello, As the title suggests, my business' reports are now being sent out an hour earlier than they should due to DST. When looking at the admin guide in SEI, it suggests I set a Time Zone for the scheduled job. However, as you can see below the option…

What would cause SEI to not populate the data in a view and just be stuck on "Pre-Fetching"? I've also noticed scheduled reports aren't being sent out either, so I'm guessing it's a connection problem.

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.

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 would like to know the difference between UDM and normal Finance process,dashboard and reports?

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…

Using SEI 8.2.0.38. I can email a worksheet, report etc. when I share it from the Command Center (Sharing>Email). When I schedule the same worksheet, report to email out, I don't receive an email. The Scheduler console shows that it ran and was Successful…

Dear All, I am facing some problem to generate a report through sage enterprise intelligence. I want information from the report is 'product without customer' but when i apply criteria/filter to the customer i.e. 'customer code=null', the output…

Can the SEI weblinks be opened without a user signing in? I want to deploy ongoing report through the browser that will automatically tab over to display different reports. The issues is, we have to sign into it every time it reboots.

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…

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.