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

    how do we get notified when a product is near to expiry.
  • 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.
  • 1099 report within Sage

    Is there is a 1099 report within Sage? That is, some sort of report that shows vendor payments for a certain date range
  • Purchase Metrics

    Trying to get a handle on purchase cost over time for our Raw Materials. I cannot find a report or dashboard for this type of information. What am I missing. How are others solving this issue? Noel
  • What is the BOMPRN Print code?

    Hi, I want to make two versions of the BOMPRN printouts available to users via Production BOMs. However I can't find the print code to do so. The original BOMPRN report isn't listed in Paramters>Destinations>Print Codes. Any ideas? Thanks
  • How to print multiple Report

    Hi, i need to print two report in just one click transaction. I have created two separately reports that take the same parameters. How can i to print one after another? As shown in the preview image I added a row in "Crystal Report" section in Dictionary…
  • Graphical Query Tables Linking

    How can I link the following tables together, I tired to link every possible key but keep running into an issue. Please advise.
  • Webservice to return file or blob

    Hi, I need create one webservice to return the result of one Crystal Report (PDF for example). So, I use function ETAT to generate the result of report (PDF format) to specific location,after that I need return this file to Web, any idea how I can…
  • Free Professional Invoices For Sage X3

    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…
  • RE: How to add an 'or' for criteria (SQL)

    Hi Israel, Sorry to bother you again, but I have yet another question. I'm trying to do as you've shown me for search criteria, but I seem to be running into a small issue. I have 2 fields that are joined. I have the following query: SELECT F.ITMREF_0…
  • Report Attachment in Email

    When we are attaching a report(PDF) in email, the attachment takes a name like 'jobrpt_ReportCode_UserCode_Number'. Is it possible to change the default naming style to change a name which could be meaningful. E.g. If Purchase Order, attachment should…
  • RE: Crystal Reports with SQL Commands

    Hi Ben: Could you please provide some more details on what do you mean by "SQL command" Standard reports in X3 have parameters in them that allow the report to connect properly when launched within Sage ERP X3. For example if you open Tabcountry…