Sage X3

Hi I try to use zonsui to move cursor in a grid. In After modif subprog field, I added zonsui = "NAMEFIELD", about another field from grid. This optioon no works. I try too zonsui = "NAMEFIELD("+num$(nolign-1)+")" , but no works too. Version…

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 have a need to explore the usage of "preparation codes", however, when I try to set one up, I get an error: How do I bypass this, or set up a preparation code at the site as mentioned? I cannot click in the preparation code box. A site…

Hi. I have v12 (2023 R2 (12.0.34)) and I create new window type Miscelaneus and Display = Full screen. I add two new buttons with code z an i , one validating and another no validating. In SETBOUT ACTION, I add this lines: Call VIREBOUT(CHAINE…

Hello Hello to all the Sage Community, I introduce myself i m from TUNISIA and i work on Sage Solutions since 1998 so about 26 years and i wonder if in this Community of philantrop and experience is there a Virtualmachine or Plateform to access to…

Hi there, I have a need to add a custom field to the grid array in screen PAY1, but I noticed the screen itself it is marked as "Templ. screen" and the verification button is greyed out. I tried adding the field anyways and verifying entry transaction…

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…

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 every one I get this error when I try to validate delivery is there a way to fix it?

Hello, I don't understand what does the keyword "setmode" do, there is no help available on eclipse or on the internet. Can someone please explain it to me?

After reviewing the product status options under product setup (Active, Obsolete, not usable, on shortage.. etc), we have decided that certain options are not applicable to our business process. To avoid confusion to our users, we'd like to hide some…

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…

Is there any easy way to exclude the weekend from my date calculations in X3? For example, my delivery is suppose to arrive on Monday. It takes 3 business days to get to the customer. If I do Monday - 3, I would get ship date of Friday when I actually…

Hi All, We are trying to read the product of Magento from Sage X3 using integration methods such as Rest webservices, Node.Js for one of our client. The Magento API endpoints uses 'OAUTH1' type of authorization for authentication of the Rest API requests…

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…

Hi, How do you subtract time with the 4GL language? Thanks, Chris

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…

Good Morning, We are getting an error message when we try to set the reversal date to 01/01/2021. (The accounting date is 12/31/2020). This is only happening to some of our journal entries. Would anybody be able to tell me why this error message…

On the delivery screen, when I work with web services, when I save a record, it asks web service the following message and web services responds with a yes. The carrier, shipping address, or weight/volume was modified: Search for the carrier price?…

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…

I'm curious to understand the difference between using a trbegin - commit - rollback sequence to update a value(s) on a table vs. using an Update With statement . the Trbegin statement would look like this: Trbegin [TBL] If !fstat Write [F:TBL]…

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 can I show a quote in a string? I am not looking for answer like you can have a single quote and then the quotes inside the single quotes. Is there a 4GL command that will add a " into a string without ending the string In java, we would put…

Is there a way convert a Datetime value to Date type in the 4GL language? I need to compare a date with a datetime variable in 4GL but it does not work. Therefore, I would need to convert the datetime to a date.