Sage X3

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…

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…

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…

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…

when i click on the query cell to change it to yes it just jump for initial state, but for some others columns it's ok

Hello. How can I delete a specific row, from sales order rows list? Thanks. Regards. MS

I have 2 different reports one is a Statement of Financial Position while the other is an Income statement, how can I get calculated fields value from my Income Statement Into my Statement of Financial Position noting that the IS has it's Data Model just…

Hello, Before we installe the last Syracuse Version, when we are selecting a record in X3, the lign of the records were coloring on green. Now, it's very difficult to see when records are selected: It would be interesting to have a method which…

Hello All, If a Purchase Order workflow signature is not signed after 24hours can it be escalated to another person to approve? Thanks

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…

Hi Guys I've implemented create report functionality. The following part is calling report creator: Call ETAT("ZLETTREVIRR", "FILEPDF", "", 0, PROP, TPAR, TVAL) From AIMP3 Where "FILEPDF" destination - output file type pdf. I also added FICHER for saving…

Hi Everyone! Wish you all an great 2021! I'm new to SAGE X3. How can I refresh a query on "landing page"? I've tried with parameters "portview" and "frequency" but no success. Am I using the parameters correctly? Thank you, for your help.…

Hello, I would like to know if possible to Browse (Visualize) PDF in a X3 Custom screen. I successed with Image, it appears on the screen. Not with PDF, it is blank. Then the idea is to use a dynamic URL to visualize Docs on the X3 Server. My…

If my stored procedure contains the statement below. It works. select top 10 ITMREF_0 as ITMREF,ITMDES1_0 as ITMDES from ...ITMMASTER If I change to dynamic sql below, declare @sqlTextAll nvarchar(max) set @sqlTextAll='select top 10 ITMREF_0 as…

Trying to edit the URL field for type URL to link to Syracuse functions. Clicking OK I get "Error Invalid value", which I assume refers to the URL field. In this example I'm editing an existing function, and the link value is : /sdata/syracuse/collaboration…

In V12.0.21, and I'm trying to add lines via web services to POs that are partially closed, but I get the 'can't display a popup in webservices' error. It works on POs that are not partially closed, and it works when manually adding lines to the partially…

I am looking for information on who created and updated a screen and when? Thank you in advance,

The online help says.... Query, Detail, Edit, Lookup, Summary These columns represent the different facets in which the property can be used. When one of these columns is selected, the property is present in the corresponding facet. Otherwise, it…

Does anyone know the process for creating a SDS? How are the fields added or removed? How to choose what phrases are available?

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…

Dear Community, I have write following code snippet, After trying lot of time i cannot figure out why this error is coming . Z SEAKEY_0 is number. Subprog AM_ITMREF(VALEUR) Variable Char VALEUR() Local Char REQSTR1(250) REQSTR1 = "SELECT ZSEAKEY_0…

We're on V12 patch 21, with Syracuse 12.6. We use web services primarily for creating sales orders. I use the SOAP method, I've never tried REST. I have two servers that run Syracuse, one that has Mongo, and the other that's meant to stand alone as handling…

This is sort of different than another thread on null web service messaging, maybe they're related, I'm not sure. My issue is that in V9, when submitting a sales order via web services, if there was an error, the resultxml messages array would have helpful…

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 am currently extending a webservice. I did the mapping and the customization of the subprogram, but i just get the following feedback from the service [warn] WS execution failed on first attempt. A second attempt has been processed to force the reload…