• Running a Crystal Report with a range parameter from Web Services using (CWSGPRTRT) Generic Print Report

    We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…
  • Product Site Clarifacation on What the Logic is

    Hello, am wondering if someone can explain the logic behind Product Site Default Location setup? Problem: Snap shot above is how we are picking our apparel for replenish to work, but I don't think it's setup right 100%. Does anyone have any expierence…
  • What data is passed through AWRKMEL? Workflow code [F:AWA]CODE is null

    Hello, I want to change the workflow sender depending on the workflow code [F:AWA]CODE. The workflow code in question is ZTEST However, in a custom ZAWRKMEL script, the [F:AWA]CODE value does not seem to pass through. The result is an email sent by…
  • 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…
  • Signature Management Workflow for a Sales Order created by Import

    Is it possible to have a signature workflow created for a sales order that is created through the import/ export function?
  • Seeking Information on Email Monitoring and Routing Services

    Hello everyone, We would like to ensure proper monitoring of emails sent by X3 workflows and also verify the routing of email addresses through an external provider. Do any of you already know suppliers who offer this type of service? Has anyone successfully…
  • Use Amazon SES (Simple Email Service) as Notification Server in Sage X3

    Amazon Simple Email Service (SES) is a robust email service provided by Amazon Web Services which helps businesses send business emails to their customers securely via the latest email transmission and authentication technologies such as SPF and DKIM…
  • Header Modification ("Affect detail lines") from workflow

    Hello, I'd like to update the shipment site of a sales order and have it affect all of the lines as well, when a workflow condition is met: For example, I have a workflow that will use the AWRKUPDFLD to update the STOFCY field of a SOQ line, but…
  • Display modified fields in a workflow programmatically

    Hello! I have created a simple workflow and script to display fields that have been modified in a PO where the cost is over $10,000. This works by checking the [M] field against the base [F:POH] field, and using RETVAL to display the changed information…
  • Workflow rule or script to email sites with safety stock when product status changes

    Good afternoon! I am looking to set up a new workflow rule which will automatically email all of the affected product-sites when a product status is changed. So far, I have managed to set up a rule that will detect when the custom status field we…
  • POHSIG Workflow signature

    Hi, I'm trying to modify a standard workflow rule POHSIG to automatically sign PO if [F:POH]TOTORD < [F:POH]CREUSR maximum value But it works only if user that creates PO is in the first line of Rule values. For Example how it works in standard…
  • ASYRWRKSIG Workflow approval link Error:

    Hi All, Please assist as to what might be a solution to the following error for workflow approval links: {"$diagnoses":[{"$severity":"error", "$message": "X3 engine error: D:\\Sage\\X3APP\\Folders\\X3\\TRT\\ASYRWRKSIG.src : File Non-existent ()…
  • Trolley Build Function Sage

    I am wondering if anyone out here has had any experience with the trolley build features with Datalinx? We are thinking of exploring "picking to slot", "Trolley Build", "picking to Carton" functions in our warehouse. Would love to pick someone's brain…
  • Workflow rules: mail notification after create QC analysis requests

    Hello, Im looking for solution to create Worfkflow rule/Notification that will return email after create "Analysis requests" from production declaration or receipts. Everything what i get so far is email notification only from modification or closing…
  • Workflow Rule - Operations

    Good afternoon Folks Does anyone have a good guide to what the operations all mean? I'm trying to have this send 30 days before the date in the field, but I dont think create or modify will work for an even like this.
  • Workflow Rule - Message with Amount to Invoice

    Below is a message I created for a workflow rule to notify end users they have an invoice ready for approval. Does anyone know why my "Total Cost" is not working? You can see it present in SQL with an amount and in the invoice. |"Subject Invoice has…
  • Slow Performance during Report Phase Job Started and Printing X3 V12

    Hi, my company is in the middle of a migration from SAGE X3V5 to SAGE X3V12. R093.001.00019 When running a report in X3V12, the querying part (Job Started Phase with the green bars) takes an extra 1-3 minutes on average than it did in X3V5. In X3V5…
  • Using SQL Function in SQL Requester

    Hi, I am creating a simple SQL Requester which will pull back data from 2 tables - PREQUIS and ACLOB. I wish to use a SQL Function I have to convert the CLOB Text from RTF to 'readable' text. This works fine in SQL, but when I try in the SQL Requester…
  • Open Items Report for BP

    Hi, I want to run a report for a specific BP/Customer and I would like this report to show a complete list of all transactions for the customers - open and closed, invoices, CMs, DMs. I want to see 2 columns, one showing original amount and one column…
  • We faced a problem in Sales Order workflow where the signed flag becomes BLANK when header condition not met.

    Hi experts, We faced a problem in Sales Order workflow where the signed flag becomes BLANK when header condition not met. When creating a new sales order in LIVE folder, it doesn't trigger the workflow because the "header condition was not met", and…
  • For Pivots, why is the grouping and data staggered?

    I'm trying to automate reporting for my organization. However when utilizing SEI's pivot function, it staggers the groups from the data itself making the data useless upon exporting to Excel. I'm hoping there's some setting where I can have a more traditional…
  • why aged balance report showing separate line for currency revaluation (CURVA) instead of embedded in each invoice?

    In the standard report - BALAGEHIST and normal BALAGEGRP - the detail aged balance is showing currency revaluation as a separate line. Can this revaluation entry show at individual invoice instead as for audit purpose - it will not be transparent to show…
  • Parameter Prompting for Labels

    I am using Sage X3 V11 with Crystal 2013 to create a new label. Is it possible to prompt for report parameters when using the Print Stock Labels function? I am hoping to enter values for the label that are not currently stored in Sage as parameters.
  • Sage HR Workflow Recipient Type

    I have to make adjustments to some HR Workflows, but most are set up using these new option. And I can’t make changes until I know what the current process is doing. The first 2 are standard, and I know what they do, but the next 3 I don’t know. …
  • How to print petty cash statement

    Hello, I want to use the report "Bank Account in Ledgers Report" for petty cash accounts as well. While printing the report under parameter section, i can see the petty cash accounts but when i click on bank selection it says record does not exists…