Sage X3

I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

I am trying to use the SCS object as a web service to do a stock status change. Has anybody had any luck with this? It accepts the XML with no errors, but it doesn't do the updates. I am trying to move stock from a status of "Q" to "A".

Does Sage X3 has import/export template for Sales Return. Since we have integration to third party Sales application, this is becoming a challenge on the Sales Return front. Currently its integrated directly using Web services. System is having performance…

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…

I want to save data from sage to my sql database, the problem is in soap i get a group structure. example: "ITM0_1": { "TCLCOD": "ASSET", "ZTCLCOD": "Invest", "ITMSTA": "1", "ITMSTA_LBL": "Actif", "ITMREF": "ASS001", "DES1AXX": "Serveur informatique"…

Hi everyone, I'm looking for the description of this field: Table - FXDASSETS field ACGGRP_0 Example: ACGGRP_0 CM The description must be similar, but I have not been found a table yet with this description, please someone has an…

Hi! I'm trying to call an web service using Visual Basic in a spreadsheet but it returns me an error: xsi:type="xsd:int">0</traceRequestSize></technicalInfos></runReturn></wss:runResponse><multiRef id="id0" soapenc:root="0" soapenv:encodingStyle=…

Hi all, as you can read i'm trying to import an invoice in my Sage X3 V9 PATCH 6 using Web Services, in my specific script(SPESIH) there is an action that i don't want to perform if i'm importing using web services. I wonder if there is a method to…

Can sage send data to a webhook? If so, could you elaborate on the process for this? Thanks, Chris

Hello guys, Someone can tell me please if it's possible to invoke an external webservice (soap) using 4GL ? I don't find any information here about this subject. Thanks

Hi all, I'm integrating with EM via the REST API and trying to get more information to show for SORDERs when using the query representation. Most fields are fine, but when trying to set the Query visibility of any totals (Gross, Net Price etc.) it doesn…

I'm curious to know if anyone has been successful creating new purchase invoices via web services. The process works as expected as a file import via the PIHFL import/export template. I made a new web service based on the PIH object, and it works in…

Hi, I'm trying to create projects (GESOPP) through REST Webservice.. I can create into OPPOR table but when I try to create for OPPORCRM (needed to be visible in GESOPP function) get the error message: "A Pre-sales or After-sales step must be…

Am interested in writing / developing an application that will export data from Sage x3. I want to do it from the application level not from the database level. Would really like help in getting the solution. Possibly if i can get documentation to read…

Hi All, I am getting error (AIN~ ~COR~(C) ~Field CPYCRY : Countries : US Record does not exists) while importing data in Sage X3 for customer with contact tab using web service. If I am not passing Contact tab in XML it works. Anyone know about…