• Planning work order material import for BOM change

    What is the best way to update planning work order material based on the updated BOM? There is no standard import template for MFGMAT. Users requested that they have three old components that is in 189 open work orders that "builds" phantom part# to…
  • Menu item - type: query - "where" parameter operators

    Good morning, I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says: Only simple conditions using "le", "ge", "eq", "lt"…
  • SageX3 - Selection List

    Hi, in a custom selection script like this: GSELFAC = 1 : # campo che deve ritornare Filter [F:YPROD] CRITERE = "[F:YPROD]YITMREF='"+[M:POH2]ITMREF(nolign-1)+"'" NBCOL = 0 NBCOL +=1 : COL(NBCOL) = "[F:YPROD]YCODPROD" : TIT(NBCOL) = "Cod.Produttore…
  • Customer Entry Transaction

    Good morning Does anyone know how I can view the entry transaction screen for customers? I can't seem to locate this in any of the setup function options (V11). Thanks!
  • 1) Mass delete BPS Invoices 2) DocLink/DocAlpha

    1) Is there a way to mass delete BPS Invoices? I have 1900 to delete. 2) Duplicate and triplicate Invoices have imported into Sage X3v12 p17 from DocLink/DocAlpha. This is the second or third time it has happened. Does anyone have advice on what might…
  • ADC location override

    So I have been presented with an interesting challenge. In our company we've set X3 to batch allocate all available stock to meet all demand in the system. We also heavily leverage X3's ADC functionality. Our warehouse users are able to override the…
  • Format data on export by Adding characters

    hi, When i export some data for exemple à LOT NUMBER, i want to add a "XX" at the beginning of it when we export the data with an export template i take from the table OUTPUTM : [OUM]LOT I'm trying to use =FORMAT$ But i'm stuck on how to express…
  • Azure Active Directory Application Proxy

    Hello, we'd like to use Azure Active Directory Application Proxy to take advantage of Microsoft authentication services and to protect the access to our on-prem Sage X3 v11 from the Internet. Currently we login into X3 from our LAN as http://erp.domain…
  • Journals on hold when accounting task active also

    Hi All, In my Sage X3 database journals are on hold when the accounting task active. When i post supplier invoice it does not go to GL. Any idea?? This is new database.
  • Add Line to Grid

    HI all, in Sage X3 v11 I need to fill a grid on click but I can't find a way to add lines to my grid, can someone share a script to help me, i'm currently working on Sage X3 SPE Script of that window?