• WORKFLOW RULE-MESSAGE TEXT FOR IMPORT-EXPORT EVENT TYPE

    Hello Everyone I created a workflow rule for event type Import/Export to create journal documents. This works fine and sends out email notification to recipients The challenge I am having is that the text in the email does not include the created journal…
  • Broken connection between X3 and Apache after installing/uninstalling XAMPP in dev instance.

    Hello Symptom : what appears in X3 when I'm trying to lauch a function using a windows : Convergence Server comments - Error code : [500] Window definition 'OADI' could not be loaded for language FRA. quick_errorconnect ECONNREFUSED 127.0.0.1:55080 Additional…
  • How to query cancelled payments?

    Hello everyone, Does anyone know if there is a field in the PAYMENTH table that indicates that a payment has been cancelled(validation interrupted)? STA with local menu 689 has no value for it. STAFLG has several dimensions and is not really clear…
  • Import to ACLOB Table

    Similar questions have been asked but never answered directly. Simply put, I need to be able to create an import template to upload "comments" to product records. I do not want them in the purchasing text fields, rather the comment bubble. I know…
  • Back-to-Back order function grey out in Sales Order Screen

    Hi everyone, I got an issue where I was unable to create B2B order in sales order screen as the option is grey out I have checked my product setup and It has the 'back-to-back order' ticked However, I am able to use the Back-to-Back order function…
  • Default Locations

    I want to mass update all the existing products with their respective locations. However, when I am trying to export default locations along with the types, i don't know how to export multiple types. Upon exporting only receipt is getting exported. See…
  • Import of miscellaneous receipts for inventory

    We are importing inventory receipts into a new warehouse. We are using the import template FTIMSR. It works fine. The issue we are having is dealing with errors and the subsequent creation of multiple misc receipt records in Sage X3. If we build a long…
  • Set replenishment rule

    Hi all, I'm trying to set a replenishment rule on a location from another one. We have raw materials in let's say Site: S01, loc type: MAN, location: RM00. We would like to set replenishment rules on this location from another one from the same site…
  • Encounter error when running Stock Accounting Interface

    Upon running the Stock Accounting Interface interface, I consistently encounter the following error: SOOCKSE22006354 Nonexistent dimension value (STKIS Line 3) Miscellaneous issue VCRNUM=MIOCKSE23003691 Upon thorough investigation, it has come to my…
  • Finding Lot numbers on Unconfirmed Deliveries

    Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…
  • Excluding a Sales Invoicing Element from Credit Memo

    Hi, We have an automatic damage allowance set up as a sales invoicing element; this element value is set on the customer and is populating on both invoices and credit memos. Is there a way to exclude this invoice element from credit memos only?
  • Highlight shipment number after the record was loaded?

    We recently migrated to V12 and I'm looking for a way to simply have the shipment number be re-highlighted after loading a record...that way when scanning in another shipment it would overwrite the current shipment number and load the next record... Right…
  • 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…
  • Folder Creation error while copying from PROD and running the Import using Sage Management console

    Hi, I am receiving this below error while trying to create a new folder by copying the Production folder. Can some one help me resolve this issue please. Thank you!
  • What is the purpose of the following: Substitution product "Field SBSITM / Screen ITS [ITS]" VS Alternate product "Field RPLITM / Screen ITM2 [ITM2]" in "Product"

    Hello All, Can someone explain the reason for these two fields listed in the subject in "Products" screen. I've read the basic break down's from "F1" help, but we are looking for more real world examples and purposes of these two fields. Could either…
  • PURCHASE REQUEST WORFKLOW ESCALATION

    Good Afternoon, We would like to find out if anyone has ever setup workflow escalations on purchase request workflow approvals. under WORKFLOW FURLES, there is a ESC - ESCALATION option when the EVENT TYPE SIGNATURE is selected. However, despite testing…
  • CC Billing Contact Table in V12?

    Hello. Does anyone where credit card stubs are stored in V12? In version 6 it was XCSPSCNT. We are in the middle of a migration to V12 and I'm trying to understand how credit card stubs are stored; because I will have to update some of my integrations…
  • X3 V12 iframes are not working

    When creating a menu item that is just an external link, the iframe fails to load. I even tried just rendering a simple page from a local apache web server and i cannot get it to work, regardless of how I configure the meta CSP values. Browser shows…
  • Left Join with is null check

    Hello I want to write the following SQL Query as 4 GL Link instruction: As seen in above screenshot this returns a record. With the following Link statement I try to make this SQL in 4GL. In 4 GL I make a left outer join and check with [F:YCFPJOB…
  • After validating the graphical query, it automatically deletes the JSON file used to run the query

    The title says it all. Only happens in some folders, v12 Patch 31. The work around is to take a patch of the graphical query from Problem Folder, integrated it into a Known Good Folder, and after validating, copy the JSON file shown in the error from…
  • Trying to return a Using ASYRRESTCLI.EXEC_REST_WSCLB how do I get my RETVAL to bring back more than 250 Chars?

    Hi There I am trying to return a Using ASYRRESTCLI.EXEC_REST_WSCLB how do I get my RETVAL to bring back more than 250 Chars? Here is my code
  • [X3v12] Pressing Navigation Page lead to pure whiteout and blank screen after a new group and role creation

    Hi, Not sure the exact steps but this normally occurs after I set up Security Profile, Roles, Groups, and a user for a test run in Syracuse Administration module. Often occurs in Google Chrome. I normally use Firefox as an emergency when this occurs…
  • V11 to V12 upgrade timeline

    Approximately how long should it take to upgrade from V11 to V12?
  • SYRACUSE WS Unauthorized error

    Hi I'm trying to use X3 V12 webservices from PHP application, below the code I used to save a new order : $soapclient=new SoapClient($wsdl, $options); $callContext = array('codeLang'=>$code_lang, 'codeUser'=>$username, 'password'=>$password, …
  • Failed to open collaboration database: date constant not terminated:

    Context: I am moving over a X3 pu9p5 MongoDB over to X3 v12p32 as a test run. I have done the necessary grind from MongoDB from 3.0 (pu9) to 4.4.12 (v12p32) as per MongoDB requirements. I have also rerun the syracuse install to confirm Syracuse…