Browse By Tags

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)

Hello Guru's, One of our customers noted that Sales Delivery Module doesn't have the standard capability of filtering the Sales Order Selection like the function currently available in Purchase Invoice where the module has a line menu for Purchase Order…

Hi I have a customized report ZSORDERS I have a script that renames the pdf generated by report (SO#) and saves it in destination.But I need to modify the script so that when the user opens the report in preview the report is renames and the user…

HI all, in Sage X3 v11 I need to fill a grid on click but I can't find a way to add lines to my grid, can someone share a script to help me, i'm currently working on Sage X3 SPE Script of that window?

I currently have this piece of code: Local Char YAPI(250), YURI(250), PCOD(100)(1..10), PVAL(100)(1..10), HCOD(100)(1..10), HVAL(100)(1..10) Local Clbfile YMTD(250), YREQBODY, YRESBODY, RESHEAD(0) YREQBODY ='{'+%22+'"SOHNUM:"'+%22+':'+[M]XSOHNUM+…

What is wrong with my syntax? Im trying to pull anything that begins with a J. sdata/x3/erp/ecommerce/ZBPC?representation=ZBPC.$query&where=upper(BPCNAM)%20like%20%27J%27

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…

I would like to make a bundle in node.js, for Webservice consumption and add to X3.

Hi all, I am trying to build a SPE to capture a number (Field is a text), split the digits, multiply each one, sum all and validate the result. I have some questions: 1 - Now, I am working with STRING and I need convert this String to a Integer, so I…

Hi, Can somebody provide me examples of how actionObject is worked in web services? If you could also throw in actionObjectKeys as well, that would be awesome! Thanks, Chris

Hi, I would like to know if there is a way to increase the number of buttons showing on the screen header. As example: On Suppliers, I added 2 new buttons, Test 1 and Test 2, but on the header there are only 3 buttons ----------------------…

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…

Hello, I am trying to use a text data type in a class/representation, but I keep getting the following error message when I run my API: {"$diagnoses":[{"$severity":"error", "$message": "X3 engine error: [Microsoft][SQL Server Native Client 11.0]Invalid…

Is there a 4gl syntax that represents a if the process is by a soap api call? For example, let say im making a modification to sales order via the modify soap call. I have code in APRES_MOD, but I don't want that code to be executed when the modification…

Hi, I created a specific table to store some information.. One of the columns is a photo (blob)... How can I consume them via web service to show the photo on an external HTML page? In the picture below, BLOB_0 is my field where the photo is. How…

We have a representation of purchase documents, and in the list we want that by default we appear ordered by date in descending order. How can we do it?

The requirement is to print the company name, address, and contact details of the party responsible for paying for duties/taxes on a delivery. This may be different than the BPC listed on the delivery record. I am trying to add a BP number and related…

When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL. When I execute the query in SQL, it returns the correct results. For example: When testing the same…

I created screens and window which is shown below. The first problem I face is that when I clicked Save button, only the first row of the table in RFQ is saved. Both "RFQ1810002" and "RFQ1810003" did not save. Besides, the second question is that when…

What is the criteria for the xml file for the modify call for a soap call? Would I be adding the fields that I want to modify only to the xml? Thanks, Chris

Hi, We are coming into an issue where soap call will still submit an order of the remaining products even though the overall order has failed. For example. say a customer order 3 products. The first product is good, the second product is bad, and…

Is there a way to automatically print the order acknowledgement when somebody presses the create button on the sales order?

Please any help will be appreciated. I am trying to clone a functionality from Customer BP Invoices under the AP/AR Accounting. In the Distribution field in Lines where you can perform analytical distribution I am trying to clone same functionality for…

Is there a way to group all products in a sales order to show under one sales order number rather than having the rest api in the following format: sales order 123456 product #1 sales order 123456 product #2 I want it show this way: sales…

Is it possible to do a soap call for a non object screen? If so, how would I do that?