• Report parameters : How to filter the value of the selection ?

    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…
  • Sage V12 Exporting Information from Various Pages

    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 …
  • How can I add more intervals to Aged Balance Report (BALAGEGRP)

    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…
  • Reports printing with smaller font in PDF

    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…
  • Report DE-GLGRP: Add field for tax code

    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.
  • Sales Invoice report stuck when printing for some 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…
  • Manufacturing costing report (MFGCOST) not showing actual and expected values in operations

    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…
  • Creating and Saving report memos

    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…
  • Error 504 while printing report in v12

    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…
  • PORDERQ - RETRCPDAT field ?

    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,
  • Another Built-in SQL Server reporting tool

    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…
  • SQL Server Dashboard report

    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…
  • product expiraion

    how do we get notified when a product is near to expiry.
  • using Microsoft Query

    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…
  • Last transaction dates/Inventory

    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…
  • Row Level Permissions on Query Reports

    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…
  • to be able to amend the default time zone for the credat and updatim

    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…
  • How to add a new crystal report to SAGE X3 V11

    Hello everybody I want the steps to add a report to Sage x3 V11 please.
  • SQL REPORT IN X3

    I am trying to run the following query but its giving me an error. Any suggestion on how it can be fixed.
  • Transaction Log Files

    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…
  • Crystal Report DATABASE CONNECT

    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.
  • Users Report

    Is it possible to get all the information from the screen below that shows the user and the what the function profile they have?
  • Posted Sales Invoices that are not Paid

    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.
  • SQL Report

    How can I set up reports in Microsoft SQL Manager. I have tried using Query in Sage but it can be time consuming to get the times to work.
  • Printing Multiple Invoices ERROR Crystal REPORT

    When I put a range invoice to print, which I do by going to an invoice and changing the parameter, I am getting the following errors.