Browse By Tags

  • 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
  • How to call action flags in "Standard Processing" types of functions - FUNCLEAR (Close & Reopen Purchase Orders)

    Hello! I've added a field, ZMNSTA, to the CLE2 (Close & Reopen Purchase Orders) screen, in order to display a custom field from ITMMASTER for each product. However, upon entering my code into SPECLE2, it seems that no actions are being called at all…
  • Function cannot be called in this context

    Hello everyone I built a generic screen "ZTRANSPORTCO" for a customer. The screen is used in multiple windows. The problem is when I try to "Jump to" another window which also has a tab with the generic screen "ZTRANSPORTCO" I get the following…
  • Variable to show the transaction code used to enter screen

    I would like to take action in a screen based on which transaction code was use to enter the screen. Is there a variable available that will show which transaction was chosen when launching the function?
  • How to store Blob image's type in a table ?

    I created a custom screen where I am displaying images related to a driver. I am using a datatype of ABB, input of Display, and Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In the screen…
  • SageX3 - Left List Personalization

    Hi, how can I add custom view fields into standard (browser) object Left List ? It's easy to add other tables but , what about views ? Example:this is a standard object I've added my custom view into Viste tab: But in Selezione tab (Selection…
  • 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…
  • 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…
  • How to change record by code

    Hi, Anyone knows if it's possible to change a record by code without leaving and entering the object? For instance, a button on a window that forces the current record to other than the one currently loaded. Is there any standard call…
  • How to add dimensions in account pyramids

    Hello Everyone, Is it possible to add Dimensions in account/nominal ?? I am able to add dimension under account 31100 (on screen). However, when I click on SAVE button, it throw error " Error in pyramid 31100 " and records didn't save in database…
  • QC Soap Call

    I am trying to do a query soap call on the quality control screen (STQ Object). I keep getting this error message. Does anybody know what this error means? I only see one mask in our system so I am not sure where the system thinks there are 2.... …
  • Pick/Pack Report print via webservices issue

    I am running into an issue where the I can't print a pick report and packing report based on the delivery number that I specify. It seems like it is not reading the delivery number that I specify and just the STOFCY value I created a subprogram, and…
  • Release products out of Quality Control via Web Services

    Has anyone released products from quality control using web services? If so, can you provide some details on how you did it? Thanks, Chris
  • Recursive Funprog 4GL not working

    Hi all, i have a problem with this function: Funprog SUM_TOTAL(PROJECT,BUDGET) Value Char PROJECT Value Char BUDGET Local Decimal TOTAL If !clalev([F:PJBU]) Local File PJMBUD [PJBU] : Endif If !clalev([F:PJLB]) Local File PJMBUDLIG [PJLB] : Endif If…
  • Process[ZSOH] - No return code (status[6])

    What does this error message mean? I am getting this returned when I try to do a save call with my web services publication. (ZSOH is the name of my publication)
  • How to add a selection criteria for Sales Order in Delivery Window?

    Hello Guru's, One of our customers noted that Sales Delivery Module doesn't have the standard capability of filtering the Sales Order Selection like the function currently available in Purchase Invoice where the module has a line menu for Purchase Order…
  • Script to rename report in Preview

    Hi I have a customized report ZSORDERS I have a script that renames the pdf generated by report (SO#) and saves it in destination.But I need to modify the script so that when the user opens the report in preview the report is renames and the user…
  • 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?
  • How to get quotations in response using ASYRRESTCLI.EXEC_REST_WS

    I currently have this piece of code: Local Char YAPI(250), YURI(250), PCOD(100)(1..10), PVAL(100)(1..10), HCOD(100)(1..10), HVAL(100)(1..10) Local Clbfile YMTD(250), YREQBODY, YRESBODY, RESHEAD(0) YREQBODY ='{'+%22+'"SOHNUM:"'+%22+':'+[M]XSOHNUM+…
  • Clone record through 4GL

    Hi, I would like to clone an invoice after posting, but the "Child" record will have few changes. Would anyone have a piece of script that clones one record to share, as an example? Just to learn the best way to do it. Thank you. Best regards…
  • String to number - Array

    Hi all, I am trying to build a SPE to capture a number (Field is a text), split the digits, multiply each one, sum all and validate the result. I have some questions: 1 - Now, I am working with STRING and I need convert this String to a Integer, so I…
  • Insert new line in AOWSIMPORT web service

    Hello, I'm trying, on Sage X3 V11, to import a Task using the specific X3 Model with the help of AOWSIMPORT WebService. The X3 Model for Tasks defines the field separator as a new line (\010\013), but as soon as I put a newline inside the I_FILE in…
  • Create new record from another object in 4GL

    Hi, I need to create in Sage X3 V9 (patch 6) a new analitycal dimension (object CCE) on creating new Project (object OPP) with some data from the last one, my client request an automatic function on create so any new button are forbidden, in my specific…
  • creating a web app using mertial picking adc functionality

    Has anyone every created an external web app and that app uses the adc functionality or know of a way to do this? So basically, I am trying to create an an external web app, but I want it to behave in the same functionality when I am doing the material…
  • 4GL syntax for if this is a soap api call

    Is there a 4gl syntax that represents a if the process is by a soap api call? For example, let say im making a modification to sales order via the modify soap call. I have code in APRES_MOD, but I don't want that code to be executed when the modification…