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"…
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…
Hello everyone
When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched.
Is there any way to create SQL triggers so that they are protected? Like activity codes…
Hi everyone, I came across these excellent and useful to improve navigation on X3 V12.
A. Right Panel Actions
ESC + N – new
ESC + B - save
ESC + C - create
ESC + D - delete
ESC + E - cancel
ESC + ALT + U - refresh
ESC + ALT + P - print…
I would like to take action in a screen based on which transaction code was use to enter the screen. Is there a variable available that will show which transaction was chosen when launching the function?
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 everybody.
I need import assembly doc, but now in X3 V12 this object hasn't active import check.
I try to active and create import template, but all time system says that first line are not completed, and don't create doc.
First, in BBY Object…
Hi Everybody
IS there the possibility of adding a certificate when generating a pdf invoice, and automatically sendind it by email? Right now we send pdf invoices by email, but I don't know if can add a certificate to pdf before. Has anyone encountered…
Hi everyone,
I'm using representations to use the REST web services in sage x3 v12, and it's working fine, but some parameters it seems not to work.
I want to do a pagination when I use the $details facet, but it's not working.
looking this page…
I'm looking for ideas as to the best way to consume packaging in work orders.
We sell products in various packaging....totes, drums, pails, etc.
Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…
On X3 V12, I want to add a button or menu item that opens an attachment on an object without opening the attachments popup window. I know all of the parameters of the attachment and want to know what the code is for viewing the attachment. I see GOBJTXT…
Hi,
Please I need serious help, in solving this issue. I created a new field in the management tab called category that is jumps to the product category table.
So I am trying to make the selection of itmref field in the line tab in order filter…
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…
Hi,
I am trying to get a value display on a field on the PO line screen.
This is the concept:
field
description
data type
[M:POH2]GROPRI
entered
md8 (internal type: decimal)
[M:POH2]DISCRGVAL
entered
md8 (internal type…
Hi,
does anyone know how to change a browser label dynamically?
At the moment, I´m using the variables TITLIS and TITSEL(1) at $TITRE action.
Both variables change values but don´t display the new value.
Best regards,
Afonso Carvalho
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…
I am trying to prevent the signature circuit from restarting when the supplier is set or changed.
Most of the end users will not know or care who the supplier is during the initial stages of the request. However, the purchaser is required to assign…
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…
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 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?
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…