• Workflow send crystal report pdf with different parameters

    Good day, I'm trying to use workflow standard rules to send a pdf (report created in crystal) to some users. Standard usege works fine for me, but I need to send, in my case, an sell order printed with different setup (for example outside with prices…
  • Unable to stop a print job in Reports > Print Supervision (PSIMP)

    Sage X3 v12p32 Per title. No idea on cause but I have a print job here which cannot be killed from Reports > Print Supervision (PSIMP) and it is taking up 1/5 max concurrent print queue. I have tried to turn off the print server but the print…
  • Expanding the image in Attachment

    Hi, how to expand this attached image other than right click and open in new tab? The provided Sage X3 sizing is very constricted and is difficult to read the details for the product.
  • Generate separate PDF files of invoices from Crystal Report and send them by email to customers

    Dear community, we are trying to understand if a specific action is achievable with Crystal Reports. At the moment we are printing invoices by customer and invoices range and we get one PDF file with all the invoices inside. This file is then sent…
  • 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…
  • [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…
  • 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…
  • 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.
  • [v12p32] Need help on how to send a Report to email directly to user through Reports (AIMP) when email is set on Administration > Notification Server only.

    Hi, How to email a report without a SERMES entry? Tried to email to myself a report without a local SERMES entry. Report is: LISREL However, I receive nothing. Spam also no new email. Assume no local IIS6 SMTP Relay Server is available for…
  • Automate report delivery via batch process?

    Here is my need - to schedule the delivery of a stock X3 report via email that is not triggered by an event (so workflow is really not an option). The main problem is the report has a script that runs first to populate a temp table. If it were not for…
  • Printing is slow for only specific functional profiles

    Hello, I have a very peculiar problem that we have struggled with off and on since we upgraded to v12 in 2020.Some of our users report that SOME of the Crystal reports they print take a very long time to load. I have finally narrowed it down to functional…
  • send report as attachment

    Hello, I would like to know if it is possible to send a report (PDF) by email from sage X3 while allowing the user to personalize the email (subject, message, recipients...). I made a script that automatically generates the invoice in pdf format to…
  • Attaching reports

    I want to e-mail different reports as attachement to customers and suppliers. I used the same principle as workflow rule APRINT and create two rules (1) Purchase order (2) BP Customer invoice The issue I have, when I print e.g. purchase order to…
  • How to send email with PDF attachment using one button

    Hello everyone ! I'm still new with programming on sage, I want to make a button that will send purchase order PDF email to my supplier but only accessible after 'POHSIG' workflow rules completed, does anyone know the best way to approach this. any…
  • Facing issue while printing ZPL reports

    Hi All, We have a client for whom we did customization related to ZPL labels where we are sending ZPL labels for printing on clicking of a button. We made a report named 'YPIHLABEL' for which we set 'PIH_LABELS' as parameter code where PIH_LABELS is…
  • Reminders, Grouping Codes, and FUP report

    Hello - Reminder campaigns are a great way to help with AR collections. In fact, it integrates X3 CRM to help setup tasks, phone calls and other CRM activities. It also provides the ability to generate "Dunnings" style notifications. There are 5 levels…
  • Attaching PDFs to Work Orders

    Can we add PDF (or JPG) attachments to work orders? The PDF will be added to finished goods. When they create the work order package, they wat the PDF to be included in theset.
  • Crystal Report to Print not displaying values, but to .pdf it will.

    Howdy It looks like when I print directly from X3 to the printer I'm not getting my net invoice amount, it appears as #########, but if I do a .pdf preview it is there. Any suggestions?
  • Crystal Report export to Excel - date formatting issue

    I need some help here. I have a Crystal report that contains a sub-report with a date field. My goal is to export the report from X3, go to Excel then to a pivot table and use this date field as a major sorting point. My issue is the date field (from…
  • Crystal report reverts to SANDBOX mode even though the *.rpt file was not modified

    We have a v12 client with a Workflow that runs nightly and emails a PDF attachment. On at least two occasions the first record triggered generated an email without the attachment but the remaining records processed in that same execution of the Workflow…
  • Add certificate at pdf and send via email

    Hi Everybody IS there the possibility of adding a certificate when generating a pdf invoice, and automatically sendind it by email? Right now we send pdf invoices by email, but I don't know if can add a certificate to pdf before. Has anyone encountered…
  • Recurring Tasks AIMP report parameters destination

    Are there variables available in the Recurring Tasks report parameters for an AIMP task file name? For example, I have a set of reports that run weekly and I would like the file name to append the date at the end so each week's report is a separate file…
  • Sent mail with attachment upon workflow complete approval

    Dear Sagians, Is there any way to send an automatic mail with respective pdf attachment in sales order. The mail should sent automatically when the sales order completely approve. Thanks In Advance, Shereef N
  • Problem when attaching an email from Outlook

    Hello, We are facing a problem with SAGE V12 when dragging and dropping an email from outlook (.msg) to the attachments screen in SAGE. Though the email is correctly attached, it is subsequently deleted from Outlook. After submitting a case with SAGE…