Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
Hi
I try to use zonsui to move cursor in a grid.
In After modif subprog field, I added zonsui = "NAMEFIELD", about another field from grid.
This optioon no works.
I try too zonsui = "NAMEFIELD("+num$(nolign-1)+")" , but no works too.
Version…
Trying to create a query based on items that are out on loan to customers.
My query includes an Expression calculation based on what has been delivered to a customer minus what has been returned. So using two tables QTY on SORDERQ-RETURND, therefore…
Hello Community!
My company has a large database of raw materials, currently the purchasing plan is done manually using MRP results along with checking Projected for each raw material , one at a time. As such it's a very tedious and inefficient process…
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
I get the error Error 26 : Internal error Inconsistent reference value (11026) at @X3.TRT/REQUETES$adx (153) when trying to read a custom table in a custom batch job script. Part of the key from the custom table is a counter variable which is…
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…
When using the Product selection icon in any of the STOCK inquiries (Stock by site used for example), the fields in the pop-up window for selection are not those defined by the Product ITM object selection. Where can I find the field definitions used…
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?
Hello all,
Is there a way to get the components that are shown on the Production Tracking to be sorted by the BOMSEQ #, as it is shown on the Work Orders/Production BOMs instead of being sorted alphabetically?
Thank you,
Steve
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…
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…
Hello,
We are still using version 7. We have an export template we use to export invoices to be sent through EDI. Currently the export template creates a single text document with information from every invoice that needs to be sent. Is there a way…
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,
Before we installe the last Syracuse Version, when we are selecting a record in X3, the lign of the records were coloring on green.
Now, it's very difficult to see when records are selected:
It would be interesting to have a method which…
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,
I am trying to do a misc issue by import the data in. I changed the file type for the import to be delimited and the date formatting, but everything else for the template is the same. Below is the error message i am getting returned when I try to…
Hello
I would like to dynamically hide a column in a table (in the SOH4 screen).
I manage to do it for a single field of the screen with the Chgfmt command, but not for a complete column. Is there another command or another syntax?!
For info I am…
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…
Has anybody put the stock valuation report (FUNSTVA) on the batch server.
I was wondering what the file box is used for and if somebody could give me an example path so I have an idea of what would go in there.
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…
How can I show a quote in a string?
I am not looking for answer like you can have a single quote and then the quotes inside the single quotes.
Is there a 4GL command that will add a " into a string without ending the string
In java, we would put…
Is there a way convert a Datetime value to Date type in the 4GL language? I need to compare a date with a datetime variable in 4GL but it does not work. Therefore, I would need to convert the datetime to a date.