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.
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…
We have just switched to V12. I am wanting to export information from various pages.
Is there a way to personalise an export spreadsheet to suit my requirements?
Some of the information I require is:
Product SKU
Product Description
Pack
…
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…
Add a field by default for the VAT / tax code of the journal entry lines (GACCENTRYD, field TAX) in the report DE-GLGRP (GL journal account details). This is a must have for many users.
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 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…
In this blog I want to show you how to save different parameter values that are pass into reports. Many different combinations of values can be saved and then later recalled and used. This means you only should ever have to type them in once. Let's take…
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 guys,
I hope you are well.
I made some researches but surprisingly, i didn't find any answer.
In the table PORDERQ, do you know, how the field RETRCPDAT is populated and what its purpose ?
Many thanks for your help,
In this blog I want to talk about another built-in report that is part of SQL Server. A few blogs ago, i mentioned that Microsoft SQL Server contains some built-in reports that can help give information. For example, the Server Dashboard report, you can…
Did you know that SQL Server comes with some helpful built-in reports? I want to talk about one of those reports named the Server Dashboard. This dashboard has a lot of information about SQL Server contained inside "gauges". These "gauges"are similar…
When extracting data from the system you sometimes return a value of 1, 2 or 3 etc, not the actual data for example "item status", you get a one through six. My understanding is that because this system is in several languages? This creates extra work…
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…
Hello All,
I am trying to setup row level permissions on Query reports so that users can see data only specific to their site. I was able to setup the row level permission on all the transaction screens, but I am not sure how to setup similar permissions…
We have an issue where when you run queries from within a landing page and go to the "Show Advanced Fields" to get the date and time the query refreshed, this is only correct for 6 months of the year in the UK. The other 6 months it shows an hour behind…
X3 generates a log file of every transaction in X3. This log can be found under Reports and Log Reading. The issue is that you cannot find the log number of a specific transaction from the actual transaction and the log list doesn't always give transaction…
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.
I am trying to find out what are all the sales invoices, that have not been paid per specific site. I am using the Inquiry under sales->List of invoices.
Can I make this search even more specific, for not paid.