Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
The online help says....
Query, Detail, Edit, Lookup, Summary
These columns represent the different facets in which the property can be used. When one of these columns is selected, the property is present in the corresponding facet. Otherwise, it…
Is anyone familiar with linking the MACHINES (Installed base) and CONTSERV (Service Contracts) tables? I am trying to create a crystal report to print from the installed base screen with a summary of all the related service contracts.
From the installed…
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.
The (RAPPRO) Bank Reconciliation report is available to print for a specific bank. Let's explore 4 things you should know about the Bank Reconciliation report.
First, there are various ways to access the report. The first is from A/P-A/R accounting…
Hi All,
As per the requirement we are working on the translation(to traditional Chinese-Taiwan language) and were able to translate the most of the text, screens, windows.
We are now working on the translation of all reports. We would like to know…
I'm looking for ideas as to the best way to consume packaging in work orders.
We sell products in various packaging....totes, drums, pails, etc.
Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…
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…
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…
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…
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…
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;…
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 have a serious challenge in determining the best approach to this issue.
A group called T has 3 sub groups called I,S,H respectively and they are into 3 different types of business.(advertising,security and digital board sales).
Sub group I has…
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…
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…
Hi! i´m trying to edit the SBONFACP crystal report with the parameters values.
So i tried to print it in rpt format and later open with the SAP crystal reports.
When i tried to open it i have this error: "Unable to find language and/or path in…
Does anyone have details notes on how to add a new crystal report to show up in SAGEX3. The report has been developed on crystal but I want it to show up as an option under printer in PO. It is a copy of BONCDE report with a little modification but I…
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…
We currently have customer that accept Back orders. On the sales order the user is able to input items that are on back order. However, if a product is on back order the invoice form drops that product.
The sales order:
This is the invoice: The…
Hello Everybody!
How can I setup a default text in automatic email that I am sending a report from purchasing order?
I have created a workflow rule to do this. I put a default text in : Setup>Workflow Rules>Message. But, It hasn't worked. When I am…
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…
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.