Browse By Tags

Hi All, I was trying to delete a record from sage x3 using SOAP web service but I cannot see any online example of deleting through SOAP. Can we delete a record using SOAP web service from sage x3 ? If yes, can anybody please provide me with an example…

Hi folks! I am working on landing pages and I am still not getting this right. Has anyone been able to customize pages? I would like to make this visible in my Test Page

In code block below I am getting a 404 error when creating the request. I assume i need to provide the full path but can't find the documentation as to what that path is. This began with the lastest patch level. It worked as is before this. Anyone…

Hello, I want to make a simple specific script modification for the manual matching screen (SPELTR) however, it seems that actions do not work on the screen. The code is as follows: $ACTION Case ACTION When "AVANTBOUT" : gosub ZSOLCPT When default…

Hi there, I have a need to display the total debit [M:HAE2]TOTDEB and total credit [M:HAE2]TOTCDT screen fields seen in the bottom left of this screen (GESGAS) in the Accounting Entries browser object (GAS) shown on the left. You can see where I've…

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…

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 increasing length of DES Data Type to 250 and Validating. After I close X3 and re-open I cannot get into any function. I receive these errors: Function not defined for the value given

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…

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…

I am wondering if anyone out here has had any experience with the trolley build features with Datalinx? We are thinking of exploring "picking to slot", "Trolley Build", "picking to Carton" functions in our warehouse. Would love to pick someone's brain…

Hi, how can I add custom view fields into standard (browser) object Left List ? It's easy to add other tables but , what about views ? Example:this is a standard object I've added my custom view into Viste tab: But in Selezione tab (Selection…

Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…

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…

As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

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, I was manipulating the screens in the V12 (P24) and I have remarked that the # used in the beginning of formulas of the evaluated title is blocking the evaluation of the title in different languages. For example, in the screen BPR1, the evaluated…

Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…

I need assistance developing this workflow. What I'm trying to accomplish: When a customer return is created, I need the workflow to look at a TSICOD(1) and if it = 003, I need to update the lines of that return. The trigger works, so I can…

The correct syntax for the selection criteria for a Sage X3 date field is: [DD/MM/YYYY] Classified as follows "DD=Day", "MM=Month" and "YYYY=Year" Example : Criteria using CREDAT in table for records with a CREDAT less than March 12th, 2020. …

Cause : There is failure to communicate with MSSQL server. Fix 1. Ensure SQL services are running 2. Ensure the servers can communicate if the system a multi tier. 3. Check firewall settings

Cause: There are various possibilities including a corrupt ACLASSE table or an outstanding folder validation Fix. 1. Try to validate the ACLASSE table through Development > Data and Parameters > tables 2. Test if the above fix fails, perform…

Hi, from Sage X3 v12 web, i use the editor ADOTRT. Open my src program and run. local char zfile(255), CURLINE(20) zfile = "e:\temp\mb\test.txt" openi zfile Using [TST] Repeat Rdseq CURLINE Using [TST] infbox CURLINE until fstat <> 0…

Hi guys, I need help! My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis Please how can this be achieved? Hoping to get a positive response Thanks

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…