Sage X3

I want to create a crystal report. However, how can I find out which database column is using in the application? Suppose Common Data > Products > Department? How can I kno wwhich database couln I can refer to find out the department?

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…

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…

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…

When a report fails to print, is it being stored anywhere in the database?

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.

Hi, Can anyone help me create barcode labels for goods received using crystal reports in X3 ?

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…

I created another field in the table SINVOICE. Prior to this time i can browse all fields from the explorer, but with the new field added i can not browse that particular field. I do want to should i create a new connection to the database.

I have the following Graphical query, the two tables are BPCUST AND SINVOICE. How can I set a criteria for it to pull invoices that have a date of 5/01/2018 to 5/30/2018. When I search for this its outputting all the invoices and duplicating…

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…

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.

Is it possible to get all the information from the screen below that shows the user and the what the function profile they have?

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…

We have instances where a customer accepts back orders. On the sales order, it will allow you to put all the product, even the ones on back order. However on the invoice, it will only show the products that are available and drop off the back order products…

I am trying to report on the invoice inquiry screen. The fields are exactly what i need. Anyone has an idea what those tables are that are running?

I am running the following Query, however when I run it, it does not output the delivery number. What am I missing.

Does the system has some sort of a report that shows how much of a product we have at each site. Something we can get in excel format would be ideal.

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

The system is printing the wrong Ship to address on the RAW Material orders. On the order it is displaying the correct address but on the PDF crystal report it has the wrong ship to address on all the raw material orders. Any Idea how to fix this…

Hi, I took the original PO report and modified to print the supplier notes from the supplier record. However, the report seems to be duplicating the lines. Original Report. With the notes field added: How can I fix it so it does…