Browse By Tags

  • Web service returning "Process[WS_NAME] - No return code (status[6]) "

    I'm getting the following message on some web services responses. Just in some times.

    "Process[ZWS_NAME] - No return code (status[6]) "

    The web services its a Subprogram web service.

    Has anyone known what is it? And how to fix it?

  • Trying to read the products of Magento from X3 using rest api integration and Node JS Error

    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…

  • Field error "Reversal date" Change of fiscal year prohibited

    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 is triggering…

  • Click refresh harrows by code 4gl

    Hi,

    i need to click refresh harrows by code 4gl, is it possible?

    Thanks!

  • 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 for this…
  • Convert datetime to date via 4GL

    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. 

  • Can I create a delivery with multiple lots allocated to the sales order via import?

    I have a sales order that has multiple lots allocated to the first SOQLIN. 

    When i try to create a delivery via importing it, it is creating the delivery for one of the lots, and leaving the other lot allocated to the sales order. 

    For example, if i have…

  • Disable Menu Print Icon

    I was wondering how it would be possible to disable the print icon so that documents may not be printed in a specific window. I have tried using Call VIREBOUT(CHAINE,E) but it unfortunately doesn't work. Is there a different subprogram that handles icons…

  • Script Syntax Question

    Please excuse my ignorance, but I'm trying to read some scripts in X3 and I'm wondering what the '!' before a function or command means. Also, can anyone confirm if the : is an end of line notation? 

    I'm looking for 4gl language references…

  • Custom Subprogram and web service - how to return nested arrays

    I'm trying to return data for an array of parent/child items in a custom X3 web service (Version 12).  Specifically, I'm trying to get invoice data.  Normally, I would just publish the appropriate object as a web service, and I could make a call…

  • Subtracting ADATIM

    I created a alpha numeric field on the screen that is suppose to calculate the time difference between UPDDATTIM and CREDATTIM. In the 4GL i wrote this, but it is throwing an incompatible type: [m]myfield = num$([F]UPDDATIM  - [F]CREDATTIM)

    I am assuming…

  • How to modify the quantities of a delivery and its movements of stock through code or import / export template

    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?

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

    WGWOSTQSTD…

  • Difference between ETAT and ETATN?

    What is the difference between ETAT and ETATN when it comes to automatically printing out reports?

    ETAT () from AIMP3

    ETATN () from ETAT

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

  • Loading Paper feed when using ETAT in 4Gl

    I wrote some 4GL code to have paper automatically print via 4GL code. When the job gets sent to the printer, the printer is asking to select the manual feeder with plain paper letter on the physical device. The user would have to press the automatically…

  • Using an ICON to link to a web page

    I have a icon and I have set up a script to make it clickable. When I click on the icon, it isn't loading anything. This is the code I have. Is this not possible with icons?

    Subprog CL_ZPICDOWNLOAD(VALEUR)
    Variable Char VALEUR()

    Callui RETOUR="" With…

  • 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 

  • How to make date > than a date value in 4GL

    How do I write the following statement in 4GL?

    if date$ > 05/01/2019 

      do this

    endif

    Thanks,

    Chris 

  • 4GL for creating a quality control

    Has anybody tried to create a new quality control record via 4GL?

    If so, can you give me some guidance on how to do 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)

  • Button on Misc. Screen

    How do I go about having a button execute on a misc. screen? I have added the button on the right list, and I usually use the AVANTBOUT action to get the button to work, but that action is only executed on an object driven screen.

    I am not sure how to…

  • Is it possible to have sage run javascript code?

    Is it possible to have sage run javascript code? Maybe write the code in the 4GL script? Anybody have any ideas that may work?

  • blob file storage

    Where are blob files stored on the sql server? (Like the actually physical image)