Sage X3

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

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…

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…

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…

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…

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…

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…

Hello I would like to dynamically hide a column in a table (in the SOH4 screen). I manage to do it for a single field of the screen with the Chgfmt command, but not for a complete column. Is there another command or another syntax?! For info I am…

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…

I have a validated delivery to which I want to modify both the delivery quantities and the quantities of the stock movements made; I need to do it by code or template. Would anyone know what template to use or how could I develop it?

Hi, Please I need serious help, in solving this issue. I created a new field in the management tab called category that is jumps to the product category table. So I am trying to make the selection of itmref field in the line tab in order filter…

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…

Hi, I am trying to get a value display on a field on the PO line screen. This is the concept: field description data type [M:POH2]GROPRI entered md8 (internal type: decimal) [M:POH2]DISCRGVAL entered md8 (internal type…

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.... …

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…

Has anyone released products from quality control using web services? If so, can you provide some details on how you did it? Thanks, Chris

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)

Hello I have design the master detail for testing purpose. I am not able to save the data in the grid (details table) but master table data gets saved Can i get some help?

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…

Hi I created a custom field in table BPCustomer table. Enabled the item in SPEBPC script.When I enter text it does get stored in TEXCLOB table.(The save button also doesn't get enabled) When I enter text in this field I want to store it.How can…

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+…

I would like to make a bundle in node.js, for Webservice consumption and add to X3.

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…

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…

Is there a way to automatically print the order acknowledgement when somebody presses the create button on the sales order?