Good morning,
I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says:
Only simple conditions using "le", "ge", "eq", "lt"…
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…
Hello,
I want to make some modifications to SPEITM, but I noticed that our Sage x3 provider has done some of their own in a custom file, YSPEITM which they've called at the action runtime in SPEITM:
Unfortunately, this script does not exist in 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…
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,
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…
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…
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....
…
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…
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)
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+…
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…
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…
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…
Hi All,
We are calling a REST Web Service via the classic 4GL code with " Func EXEC_REST_WS" .
I am using a simple GET to retrieve information.
The parameters that are described in the Online Help ( link here ) make use of a Return s parameter.…
Hi, I am having trouble getting the substatus to show in the recontrol box. I got the substatus to show as a select but when I select it, it shows the name of the parent status which is A. I want the box to show the sub status AR which I created. How…
Hi all.
Is it possible at all to customize the standard date widget?
For example, i s there a way that the week number displayed at the footer of the date picker can reflect the week of financial year rather than the calendar year?
Thanks in advance…