• 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…
  • Manufactured Cost using Purchased cost rather than standard cost

    Hi, We both purchase and manufacture (it is a by product) the same product, however the WO costing always defaults to the Purchased cost, is there any around this to force the manufactured product to use the standard cost rather than the cost of the…
  • How to update exchage rate autmatically

    From Relases note, from 2022R2 Update currency rates on demand. Use the Update currency rates function (FUNCURRAT) to update rates for all or a specific currency based on a selected date. How to setup the webservice to receive exchange rate with this…
  • VALUER Action Parameter Empty via Import

    On MISC RECEIPT screen SPE: Subprog AP_LOT(VALEUR) Variable Char VALEUR() The VALUER variable is empty when I use a import template, but not when I use the UI. Help please
  • Folder restriction to single user

    Hello, Is it possible to restrict a user to acces a folder? I'm trying to give acces to only one of the 2 folders we have but the workaround i've done is to create a new group and give acces only to said folder. Is this the correct way or i am doing…
  • "Division by 0 error"

    Good afternoon, I have a similar problem when posting an invoice by Supplier BP Invoices: After comparing the PINVOICE table with another invoice that is already posted, I see that it does not fill the LED_0 and CURLED_0 fields. When you exit…
  • How to solve ‘Accounting destination’ error while creating payments in Sage X3

    Hi all, I got the issue of Accounting destination error while creating payment receiving from an open item, we are in Sage X3 V12 Does anyone here know how to solve it? Thanks for any advice,