• Sage X3 Distribution ANYONE?

    Does ANYONE on this website use Sage whom is in Distribution? I'm looking to make connections on warehousing and understanding or learning from others whom have the same challenges I do. Thank You in advance as I'm not holding my breath that I'll get…
  • The folder version is different from the version of the root folder V11

    Hello, I had to reinstall the application server due to some reasons. After installing I got an error message "The folder version is different from the version of the root folder" Pilot folder patch level is PU14. I have seen e article saying that need…
  • Rest WS

    Hello, I am trying to create a Signaturit request (GET/POST), but I cannot find documentation. I am trying with ASYRRESTCLI.EXEC_REST_WS but in the WS test in Sage. Thank you so much.
  • Balance Incorrect l and General Ledger Incorrect l

    Please I need help in resolving this issue, I have been battling with it for almost 2 weeks now because while trying to close the last fiscal period of the year I kept getting these 2 error messages with the GL account and Date Balance Incorrect l 69730…
  • Default value for specific components

    Hello, Im looking for solution to add default component value in function GESDBY Disassembly. I tried to use something like this: $APRES_CRE For i=0 To max([M:DBY1]NBLIG -1) if [M:DBY1]ITMREF(i) = "X" [M:DBY1]PRIORD(i) = 17 Affzo [M:DBY1]PRIORD…
  • Create product as per response table & product Line

    I have define 1. Product Line Attribute 2. Response table 3. Product Line See the screen shot-1 Below information I need in Product 1. Construction: 1X1 Rib 2. Composition: 100% Polyester 3. Open/Tube: Open 4. Design Type: Solid …
  • How to disconnect web client session via 4GL?

    I am looking for the possibility to terminate a web client session via 4GL code. If I am doing so via X3 GUI, there's a REST POST fired using the representation "sessionStates" with the endpoint "disconnect". Is there any chance to do this by code? I…
  • 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…
  • Projected stock for all raw materials

    Hello Community! My company has a large database of raw materials, currently the purchasing plan is done manually using MRP results along with checking Projected for each raw material , one at a time. As such it's a very tedious and inefficient process…
  • 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…
  • delete product site

    I want to delete product-site records that they do not have transactions in that site. when I use transaction mass update, it dose not check it has transaction or not and delete it directly and it is wrong because I want to delete the same record from…
  • 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…
  • 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"…
  • 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…
  • Display a screen field as a searchable entry in the browser object - is it possible?

    Hi there, I have a need to display the total debit [M:HAE2]TOTDEB and total credit [M:HAE2]TOTCDT screen fields seen in the bottom left of this screen (GESGAS) in the Accounting Entries browser object (GAS) shown on the left. You can see where I've…
  • 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…
  • Error 26 : Internal error Inconsistent reference value (11026)

    Hello I get the error Error 26 : Internal error Inconsistent reference value (11026) at @X3.TRT/REQUETES$adx (153) when trying to read a custom table in a custom batch job script. Part of the key from the custom table is a counter variable which is…
  • How to ship 0 units? SAGE X3

    Hello - we are new with Sage X3, never worked in it before. We have an order where the customer ordered an item, but we are out completely. So we need to short the order to 0. SAGE will not let me change the ship qty to 0 in the pick ticket screen…
  • @X3.TRT/GACTION$adx (1342) Erreur 39

    hello every one I get this error when I try to validate delivery is there a way to fix it?
  • Protect SQL Triggers from table validation and new releases

    Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…
  • PO MODIFICATION RE-OPENING PR

    Good day all, Reaching out to find out if there are any smart people who can assist with a possible solution / parameter regarding the following scenario. The process is as follows: PR (purchase request) is created with a QTY of 10 units and submitted…
  • Creation of New Non-Financial Site that should only be warehouse and have no financial impact on existing company or sites.

    We need to create a warehouse site (Non-Financial Site), that should not have any link to the company's financials and inventory once the delivery is done. on the other hand, the site should only receive the items, and send the partial deliveries upon…
  • Titles on Sage Users

    Hi I am just going to leave this here for Sage to hopefully acknowledge. I know its not mission critical or stopping the system working but seriously that I have to tell users Sorry you have to choose one of these is becoming quite offensive …
  • Process wise stock location auto selection

    Hi i need to setup a process so that locations are auto selected based on type of transaction and process for ex. Here if I select the receipt type as "Return receipt", then system should auto select the location code as "RETURN" Is there…
  • Allocation & Issue Rules

    Please HELP! Problem: Currently, we can't allocate sales orders at a detailed level according to "unit of measure". At one point in a selling season we have sales orders for items that ship parcel (eaches) & those same items also ship LTL/ Full truckload…