• Is it possible create new keyboard shortcuts in Sage?

    I was asked about a shortcut to print a screen array to an Excel export, instead of the user having to click "Excel Export". Thanks, Zoey
  • Home Pages - Process flow

    Hi folks! I am working on landing pages and I am still not getting this right. Has anyone been able to customize pages? I would like to make this visible in my Test Page
  • Call script method from another folder

    Hello folks Is there any way I can call in folder A a method from a script in folder B? Something like this? I'm writing an entry point which must be written in X3 folder. We have library scripts in not X3 folder. Instead of copying those library…
  • 404 not found error when creating new request object

    In code block below I am getting a 404 error when creating the request. I assume i need to provide the full path but can't find the documentation as to what that path is. This began with the lastest patch level. It worked as is before this. Anyone…
  • Convert GMT datetime to local datetime

    Hello I want to delete database entries which are older than 15 minutes. datetime$ returns the date in GMT time zone. But the database entries are stored in CET time zone (CREDATTIM column). The comparison not work as intended because of the 2 hours…
  • 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"…
  • Confirming of Purchase Order

    Hi All :) Good day, what are the ways to confirm PO? I know there are many processes, such as supplier confirmation and signing workflow, but I would like to customize it by having a field called 'Confirmed to'.
  • Entry point when report is finished printing

    Hello We have the problem that sometimes the print server not prints out a report. Even though we started the print for a document (e.x. purchase order) in 4GL with the following code: For a custom development we are looking for an Entry Point which…
  • 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…
  • Editing Field to Screen

    Hi Everyone! I try to edit Column Type Input and chose Enter but after saving error will goes like this Does anyone know if I am doing this correctly? Thanks!
  • Code to query purchase pricing?

    We have a scenario where we direct ship product from a supplier to a customer. Because of this and because we want to see accurate sales margins on the sales order, we have a need to change the cost of goods on our sales order entry screen so that it…
  • Product selection fields in Stock Inquiries do not match definition in ITM object

    When using the Product selection icon in any of the STOCK inquiries (Stock by site used for example), the fields in the pop-up window for selection are not those defined by the Product ITM object selection. Where can I find the field definitions used…
  • Grid Screen

    Hello! I'm Sage X3 developer and I having issues with Grid development. Does someone have a documentation about NBLIG, nolign, counters and grid screen? Thanks.
  • Sage X3 V12 Shortcuts

    Hi everyone, I came across these excellent and useful to improve navigation on X3 V12. A. Right Panel Actions ESC + N – new ESC + B - save ESC + C - create ESC + D - delete ESC + E - cancel ESC + ALT + U - refresh ESC + ALT + P - print…
  • Field data not present until Update clicked

    Good morning I created a new field and used the type AUS since i am using this to look up employees, once you select the employee and save you will notice the selected user code is present. The problem is when you go back into the function and…
  • Force to open [M:ENM] to modify stock movement through code or configuration

    Is there a way to force the popup screen on a qty line modification of a purchase receipt?
  • Implementation problems with specific inquiry

    Hello everyone We have programmed a specific inquiry for our client. There should be a back and next button. Only a part of the data records should be displayed. When you click on next other records should be loaded. In the function GESGTC (Inquiry…
  • Adding Field to Screen

    Good morning Everyone and Happy Monday! I'm attempting to add PTHNUM to screen POH2, but I am receiving this error "Fields PTHNUM: Undefined parameter OBJZON ( Type VCR)." Does anyone know what I'm doing wrong and how to resolve this? Thanks!
  • Error adding Custom Description field to BOMs and Work Order Screens

    BOMs I am trying to add a custom long description field to our Manufacturing BOM screen (BOH0) and receiving this error - I've added a "Before Field" Action to the ITMREF field and added this as the script. Subprog AV_ITMREF(VALEUR) Variable…
  • Switching between edit and read only Mode with global variable GCONSULT

    Hello everyone, For our customer we developed a specific screen to manage plans. In order to edit a plan the user has to press a check out button. The user who checked out the plan can modify the plan. In the FILTRE action we use the global Variable…
  • How to change Screen Input type from "Enter" to "Display" via 4GL?

    I have a need to set the format of fields on a screen to "Display" when a certain value is detected in a field. I know how I could suppress it conditionally, but that's not what I want to do. Basically... if I were writing the suppress for it I would…
  • How import assembly doc?

    Hi everybody. I need import assembly doc, but now in X3 V12 this object hasn't active import check. I try to active and create import template, but all time system says that first line are not completed, and don't create doc. First, in BBY Object…
  • 4GL- Calling IMPORTSIL from grid contextual menu (GBOUT1) doesn't work

    Hi, I'm facing a weird behaviour. In my specific, I've developed a routine that uses IMPORTSIL to add a new line to an existing sales order. This routine is simple: Reads current SOH data and generates a text file Add a new text line from parameters…
  • Add certificate at pdf and send via email

    Hi Everybody IS there the possibility of adding a certificate when generating a pdf invoice, and automatically sendind it by email? Right now we send pdf invoices by email, but I don't know if can add a certificate to pdf before. Has anyone encountered…
  • Update Credit status field (CDTSTA)

    Is there a way to update the credit status field of a sales order on creation? I have tried setting the value on in APRES_CRE "[M:SOH1]CDTSTA = 4" without any luck. I have also tried using the entry point TRTVENCDT > CALCREDIT also without any luck. …