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…
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,
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…
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?
Dear Mates. I am working on X3PU9 with a fully customized screen, however, a pen sign appear in the right list and blocking me to do any action on the screen. The message showing "You only have viewing rights...". I am accessing with 'ADMIN' Id, which…
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…
Hi to all brothers & sisters I am currently working on X3PU9 navigation function (Jump to) in table (NBLIG) from customized screen to Journal Entry. I did realized the GAS object is using HAE3 as index key. However, when i apply the code, it not able…
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
I created a custom field in table BPCustomer table.
Enabled the item in SPEBPC script.When I enter text it does get stored in TEXCLOB table.(The save button also doesn't get enabled)
When I enter text in this field I want to store it.How can…
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'm trying, on Sage X3 V11, to import a Task using the specific X3 Model with the help of AOWSIMPORT WebService. The X3 Model for Tasks defines the field separator as a new line (\010\013), but as soon as I put a newline inside the I_FILE in…
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 all,
I would like to know what is the best way (step by step) to create a rules/automation on a custom field.
I have a field on SIH0 screen, It is a type A field:
1 - When creating the register, the system populates the field with a sequential…
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…
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…