• PAYPROPLIST Report

    Hello, Is it possible to change the date format on one of the fields in the payment proposal report (PAYPROPLIST)? If so, where can I do that? This report is not accessible through the normal means I am familiar with. Regards, Dave
  • Goods Received but Not Invoice -Report

    Hi I am checking report for Goods Received Not Invoice (Clearing Account) in Sage X3 but not found any of such report. Could anyone help me how can we get the report of Good Received not Invoiced. Arshad
  • What is the file path of printed reports? (GFILPATH)

    Hello, I'm trying to find the directory where printed reports are, and call it in the context of an ASYRMAIL attachment, however, I can't seem to get the code right. I am passing GFILPATH through a workflow, which returns the exact name of the report…
  • ActiveFax Codes Not Reading on PDF Exports with Version 12 (Solved)

    The problem: When printing PDF files generated through X3 V12 to ActiveFax with the goal of automating email & print jobs; ActiveFax cannot read the codes despite having the font successfully installed on the server, pointing to the font in the crystal…
  • Entry report missing some data

    Hello team I have a challenge, when I run Entry inquiry (function CONSPCE) the report appears to have two issues: does not balance (between debit & credit) some transactions are missing that I believe is due to issue on first bullet I picked…
  • BALAGEGRPDEV- blank report

    anyone else have issues getting data from this report? I've entered all criteria and I keep getting blank report. Not sure why. I've checked and believe have the recent version from 6/2022. It seems every time I go to run a sage standard reports I get…
  • X3 V12 - Barcode Font (IDAutomationHC39M) Not working on Crystal Reports

    On X3 version 6.5 (and version 5) we installed font IDAutomationHC39M.ttf on client computers to get barcodes to show on crystal reports. With V12 I figured I would have to install the font on the server(s). I installed the font on both the application…
  • [v12p33] Question about Sage X3 support for latest Excel format (.xlsx) for print export

    Hi, Sage X3 version: v12p33 (latest) Possible for Sage X3 to support latest `.xlsx` format currently used by Excel : ? When I check the Destinations setup, I only notice the Excel format export is up to 2000 and using `.xls` format. Limitation…
  • GLANA2 report

    I'm having issues running above Sage report. I keep getting either blank report or when I enter dimension type getting error that the type does not exist. AX1, AX2?? These are selections. any help appreciated thanks Christine
  • Renaming an email message's report file attachment based on certain static and dynamic parameters set in report

    Hi, I found answer for rename file attachment from Adonix X3 v6, send using 4GL using AIMP3 with hardcoded entry, and how to recurring send the report using APRINT, but no specific answer for this case . Reference used - https://www.sagecity.com…
  • Reports > Reports (AIMP), Print Server response: NULL, for multi-tier setup

    Hi Contexts: Sage X3 v12p33 Application/Runtime Server and Print Server are in dedicated servers. Both AdxAdmin ports are allowed. The print server port is opened for Application/Runtime server. Both servers can access to SQL Server with no issues…
  • ZPL

    Hi Guys i'm trying to add my ZPL printer to Sage X3 but it's not on my server because its bluetooth anyone has any solution for this issue ?
  • 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…
  • Print Engine Error in Sage X3

    Job 2 - ERR 504 coming from the edition server : Error induced by the print engine Crystal .NET. YPO_QrTest.rpt - - Message 1/3 : Error running the report: c:\Sage\SafeX3\PRTSRV\Data\SEED_WIN-AHQG645R547_20100\ENG\Report\YPO_QrTest_CrDll_SEED.rpt - Message…
  • Change file name when printing list

    Hello, Is it possible to change the name of the file when printing using output type preview? I tried with AIMP3 entry point, with GPOINT PARAM but nothing works. JOBID didn't update the name ExportFile parameter neither thanks for you…
  • Work Order Costing with Sales Costing

    I'm trying to create a Crystal Report that will show the costing of work orders, but of course, they had to add in a twist. I need to be able to show the sales cost along with it. It would kind of be like the sales invoice line inquiry where it shows…
  • v12- where is the stock valuation report?

    i see a few questions regarding this report however in V12 I do not see the report to run. Can someone advise? I saw someone post an issue with STOCK12G report however do not have on V12 nor do I see in the SEED Sage folder. I'm looking for an inventory…
  • Locking a PDF for editing

    Hi All Is there a way to lock the PDF generated report in SageX3 from being edited ? We have a customer in the chemical/pharma industry that requires this functionality.
  • sales order form- suppress headers/ footers on crystal report

    Hi- I'm hoping someone can help me as in a pickle trying to resolve this issue. I have to add Terms and conditions to the sales order form but it is about 3 pages long. I'm having issues suppressing the header on the section where the terms are displayed…
  • Stock Valuation Report extraction

    I have being trying to extract a stock valuation report but it has being grouping the products based on category, is there a way i can extract it with grouping it by the product category ?
  • Advice needed X3 compatible printers

    Hello, everyone! We are in the process of selecting barcode printers compatible with the X3 for our shop floor. We have 2 options so far: ZEBRA ZD421, DIRECT THERMAL, 203 DPI, USB, USB HOST, ETHERNET, BTLE5, EZPL TSC TX210, LCD, WIFI READY,…
  • Multi-level BOM report with costs

    I need to produce a Multi-level BOM report with costing details and totals. The "Print BOMs" report under common data gives the correct BOM structure, but I'd like this with Material, Labour, Overhead costs - and totals... Does anyone know of such…
  • V12- Is there no trial balance or like report at all?

    I'm having issues with my customized trial balance report however would like to compare with a standard version. So question is: in V12 is there no trial balance report (including balances by dimensions?) I know the NA-TRLBAL has been depreciated but…
  • Printing image attachment from Products to the Job Ticket

    I'm very new to Sage X3. Does anyone know if it's possible to have an image that is attached to a product print on the Job Ticket report maybe as a subreport? I have tried everything I can think of in Crystal Reports but I'm not getting anywhere. Thanks…
  • SAGE X3 - USA Legislation

    Hi everyone, When we make a new installation with the USA Legislation in the Sage X3, which reports the system brings for us? For example: Is there a USA Sales Order report? Is there a USA Purchase Order report? Please is Urgent. I need your help…