x Want to participate? Join the group to interact

  • Filter of registers to be exported by Script from model export

    Hi, Is it possible to create an specific script, in model export, in order to filter by code some registres to be exported? I need it to check a value from a table that is not linked to the model's object Thnkx

  • Convert GMT datetime to local datetime

    Hello I want to delete database entries which are older than 15 minutes. datetime$ returns the date in GMT time zone. But the database entries are stored in CET time zone (CREDATTIM column). The comparison not work as intended because of the 2 hours…

  • Left Join with is null check

    Hello I want to write the following SQL Query as 4 GL Link instruction: As seen in above screenshot this returns a record. With the following Link statement I try to make this SQL in 4GL. In 4 GL I make a left outer join and check with [F:YCFPJOB…

  • Protect SQL Triggers from table validation and new releases

    Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…

  • Code to query purchase pricing?

    We have a scenario where we direct ship product from a supplier to a customer. Because of this and because we want to see accurate sales margins on the sales order, we have a need to change the cost of goods on our sales order entry screen so that it…

  • [X3v12-4GL] In Script editor, how to open a X3 Storage Area folder to reads its filelist names?

    Hi, 4GL Development question. Not sure the keyword to find for these. In 4GL, I know I can just manually put in the hardcode filepath to open through SYSTEME2 raw OS cmd call but it is very annoying to maintain (about 5+ scripts to update) every time…

  • Implementation problems with specific inquiry

    Hello everyone We have programmed a specific inquiry for our client. There should be a back and next button. Only a part of the data records should be displayed. When you click on next other records should be loaded. In the function GESGTC (Inquiry…

  • Generic Object Read

    I need to create a generic function to read an object in X3. I'm thinking some of the standard object functionality could be used, or maybe even a dynamic query, but I'm not completely sure how to approach it. For example, I want to pass a table name…

  • To open a new browser with file path

    Hi All, We are using the CALLUI function to open the URL in the next browser. Buts as per the requirement, we need to open the network file path in the new browser: file:\\Sage\folder\Test\tmp We are able to open the http path, but when we implement…

  • why i can't set query of VACITM facet to yes in ITMMASTER representation

    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

  • Using Choose to filter field

    Hi there, Im trying to filter a field based on CHOOSE as I read on greytrix ( http://www.greytrix.com/blogs/sagex3/2014/08/31/adding-selection-window-for-any-action/ ) My code is working but If I use the search (as highlited in the screenshot…

  • 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 select a transaction with CALL OBJET

    I'm using CALL OBJET in this way to open a sales order: GBIDC1 = [M:ZC3D0]SOHNUM Call OBJET ("SOH", GBIDC1, GBIDC2) From GOBJET Can I set the transaction that should be used and avoid the selection screen?

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

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

  • Using teams (standard class/ representation)

    Hi, How do I use the TEAMS entity to filter a specific object? I think the data is stored in MongoDB so I can't Filter / select this table to use critere with a for cycle. Any suggestion? Best Regards

  • CRITERE not filtering user input

    Hi there, When I filter a left list in a specific with CRITERE, the filters imputed by the user are ignored. I'm trying to filter left list in a specific. This is my code: $CLE_GAUCHE Default File [YCRG] If currbox = "GAU_CHE1" CRITERE = …

  • I was wondering if anyone has information on calling SQL stored procedures from within X3 code?

    I have a stored procedure I would like to call to populate a work table as a preprocessor to an SQL client requester. Syntax would be helpful. Thanks SQL stored procedure call from X3

*Community Hub is the new name for Sage City