Hello!
I've added a field, ZMNSTA, to the CLE2 (Close & Reopen Purchase Orders) screen, in order to display a custom field from ITMMASTER for each product.
However, upon entering my code into SPECLE2, it seems that no actions are being called at all…
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…
Good morning
I created a new field and used the type AUS since i am using this to look up employees, once you select the employee and save you will notice the selected user code is present.
The problem is when you go back into the function and…
Hello,
i want to add a field in my MGB screen that contain avaible stock , so i added a field type QTY but i have no idea how to write function in spe script that calculate availble stock !!!!!
please help!!
i'm under X3 V11
I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…
BOMs
I am trying to add a custom long description field to our Manufacturing BOM screen (BOH0) and receiving this error -
I've added a "Before Field" Action to the ITMREF field and added this as the script.
Subprog AV_ITMREF(VALEUR) Variable…
Good day everyone, I am looking for the sales FOB field in sage x3. If there is no field in x3, is there a column in sql? So far I have been unsuccessful in finding said field. Any guidance would be greatly appreciated. Thank you in advance!
Hello everyone,
I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions:
Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
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…
Good afternoon.
With the need of one of my clients on posting inter-company journal entry.
During post inter-company journal entry, "inter-company NA10 / NA011" or "Inter-company NA10 " will display on the description field of counterpart of the transaction…
Hi
I have a task where I have to add a Text Field(CLOB) on the customer screen as a menu item(on right side)
So far this is what I accomplished
1.Added menu item and Enabled it in SETBOUT
2.Created a new screen(ZACLOB) with a CLOB field
When…
Has anybody tried printing a crystal report via web services by creating a subprogram? If so, could you please send some examples so I can take a look at what was done to get this accomplished? If not, anybody got any ideas on the best approach for this…
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…
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?
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…
Has anyone every created an external web app and that app uses the adc functionality or know of a way to do this? So basically, I am trying to create an an external web app, but I want it to behave in the same functionality when I am doing the material…
Hi everyone.
I am struggling to export the bank details I spent hours loading into Sage one. You can extract Allot of details but not what I need. I tried creating a user field which I named Bank account, Br code and bank name and was hoping there…
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…
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…