Browse By Tags

  • SAGE X3 UP 9

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

    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?
  • How to store Blob image's type in a table ? / Comment stocker le type d'image Blob dans une table ?

    I created a custom screen where I am displaying images related to drivers. I am using a datatype of ABB, 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 ITM1 there is the…
  • How to store Blob image's type in a table ?

    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…
  • 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 requests…
  • 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…
  • 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…
  • 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…
  • 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.... …
  • 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…
  • 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)
  • Printing a crystal report via webservices

    Has anybody tried printing a crystal report via web services by creating a subprogram? If so, could you please send some examples so I can take a look at what was done to get this accomplished? If not, anybody got any ideas on the best approach for this…