Sage X3

Hello, I need to get a check register from Sage X3 but the report I am getting is incomplete, as it is not pulling all the checks that have been issued. Reports->Reports->CHKREG-> I am selecting the right bank account, the right status, without…

Hello, We are setting up a new client that has a company on UK, and he required to submit his VAT returns to HMRC If we go on parameter values (ADPVAL) we have the parameter MTDURL This parameter is set by default as production, is there…

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…

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…

In the All>A/P-A/R accounting>Payments Supplier Cash Payment after entering all of the data, user cannot print the accounting document. as shown below.\\ Need urgent help in this regard

when exporting queried data (for example, in journal enquiry screen) - the export function used in the documents tab - actions - excel export, is exporting max 500 lines, although 1800+ were found. However, when using the excel export on the same screen;…

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 have a report I built from scratch. Pretty simple, only 4 tables and one parameter to fill. I added it to the directory, then thereport dictionary, then set up the default values and then the print code. The report is visible after I hit "Record…

Hi All I was really excited to read about the new additions to X3 in relation to GST. (GESGST). However I am interested to know if anyone is using it? The report only works for invoices processed through sales, purchases, Accounts payable and Accounts…

Hello I'm creating an XML output in Crystal which I need to be formatted in utf-8. Sage X3 is creating the characters using ISO-8859-1 in my Crystal report which then don't convert into utf-8 characters. Is there any way of controlling the output character…

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…

If I create a scheduled distribution of a worksheet, how can I make it only deliver if it pulls data. So for example I want to use this as essentially a notification for certain invoice types. I have the work sheet built and filtered, and it's scheduled…

The budget analysis is only including reporting debit code 1 dimension for actual amounts. How do I include a reporting credit cod 1 dimension into this SEI budget analysis?

Hi Auditors have requested a simple report that all other software packages seems to have. It lists the opening bank, closing bank, and lists the outstanding cheques and outstanding deposits. There must be a report in X3 but I have been unable to…

Hi all, I'm a Crystal Reports developer working for a company that uses X3 V6.5 patch 26 and I'm having troubles with a report that uses a SQL command. It doesn't seem that X3 sets the connection details properly on the command object when it runs the…