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…
  • 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"…
  • 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…
  • View Archive Folder scripts from the Web Service script editor

    Hello, I want to make some modifications to SPEITM, but I noticed that our Sage x3 provider has done some of their own in a custom file, YSPEITM which they've called at the action runtime in SPEITM: Unfortunately, this script does not exist in the…
  • 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…
  • 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…
  • 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…
  • 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…
  • REST Web service Pagination

    Hi everyone, I'm using representations to use the REST web services in sage x3 v12, and it's working fine, but some parameters it seems not to work. I want to do a pagination when I use the $details facet, but it's not working. looking this page…
  • 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
  • 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…
  • 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+…
  • Rest API Like command

    What is wrong with my syntax? Im trying to pull anything that begins with a J. sdata/x3/erp/ecommerce/ZBPC?representation=ZBPC.$query&where=upper(BPCNAM)%20like%20%27J%27
  • Hello friends, I would like to know how to add a bundle node.js to X3.

    I would like to make a bundle in node.js, for Webservice consumption and add to X3.
  • 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…
  • Web Services: actionObject examples

    Hi, Can somebody provide me examples of how actionObject is worked in web services? If you could also throw in actionObjectKeys as well, that would be awesome! Thanks, Chris
  • How to increase the number of button on the screen header

    Hi, I would like to know if there is a way to increase the number of buttons showing on the screen header. As example: On Suppliers, I added 2 new buttons, Test 1 and Test 2, but on the header there are only 3 buttons ----------------------…
  • How to use text datatype (ACB) with classes and representation?

    Hello, I am trying to use a text data type in a class/representation, but I keep getting the following error message when I run my API: {"$diagnoses":[{"$severity":"error", "$message": "X3 engine error: [Microsoft][SQL Server Native Client 11.0]Invalid…
  • 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…