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 Sage X3 Folks! Can the 'Tax' be inputted/edited in the Customer BP invoice? I am not sure about this process.
I already changed the input to enter, but still no luck. Any of you know this process?
Hey All,
My company has purchased a wave picking function in Datalinx. During our first brainstorming session we've brought up Zones(zoning our warehouse). We believe we need to set zones as we go down this road. Problem is where to start? My question…
Hi.
I have v12 (2023 R2 (12.0.34)) and I create new window type Miscelaneus and Display = Full screen.
I add two new buttons with code z an i , one validating and another no validating.
In SETBOUT ACTION, I add this lines:
Call VIREBOUT(CHAINE…
Hello everyone
In X3 documentation it is described that it is possible to use a table from Folder A in Folder B.
https://lvexpertisex3.com/x3help/ENG/V7DEV/4gl_file.html
I tried it like this:
Unfortunately it doesn't work with the period between…
Hi,
Is it possible to create an specific script, in model export, in order to filter by code some registres to be exported?
I need it to check a value from a table that is not linked to the model's object
Thnkx
Hello everyone
I try to implement the entry point https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR.htm#APE_30_10 with action REQUETE.
I created the entry point and the processing script in the X3 folder…
Hello everyone
We sometimes have problems when a batch job runs more than once.
In order to prevent this we want to use the entry point SERVEUR with action REQUETE https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR…
I have a integration service do so a series integration. If there is any error, when create quote SQH, it will give error:
@X3.TRT/SUBSFIT$adx (149) Error 7 : Class Non-existent [M:SFIT]
0 : Sage X3 errors
After restart the X3 SOAP Web Service then…
Hello,
Im looking for solution to add default component value in function GESDBY Disassembly.
I tried to use something like this:
$APRES_CRE For i=0 To max([M:DBY1]NBLIG -1)
if [M:DBY1]ITMREF(i) = "X" [M:DBY1]PRIORD(i) = 17 Affzo [M:DBY1]PRIORD…
Need help with new custom field formula. I create custom field "Net Available Stock"
I have added the custom field to below screens, functions. now I need the field to work accordingly. I create a custom script for net availability and still having…
Hello,
I want to make a simple specific script modification for the manual matching screen (SPELTR) however, it seems that actions do not work on the screen. The code is as follows:
$ACTION
Case ACTION
When "AVANTBOUT" : gosub ZSOLCPT
When default…
Hello
I want to delete database entries which are older than 15 minutes.
datetime$ returns the date in GMT time zone.
But the database entries are stored in CET time zone (CREDATTIM column). The comparison not work as intended because of the 2 hours…
I'm trying to add the total deposit on the left list on the Manual Remittance Screen. This value is a summation from the PAYMENTH table on the field AMTCUR and is present on the screen as "Company Total." I'm struggling with how to go about this because…
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 write the following SQL Query as 4 GL Link instruction:
As seen in above screenshot this returns a record. With the following Link statement I try to make this SQL in 4GL.
In 4 GL I make a left outer join and check with [F:YCFPJOB…
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…
Hi togehter,
we successfully modified an inquiry screen (added columns, changed order of the cloumns...). Now we want to share that inquiry screen with another X3 system.
Unfortunately we cannot choose inquiry screens as an object in the patch creation…
Hello,
I've created a custom drop-down list in the WT03TSA1 (Stock Change Intersite) screen, but when trying to use it, none of the options are displayed. Instead, it says "No Match":
The menu is set up as follows:
The field is set up as follows…
Hi,
4GL Development question. Not sure the keyword to find for these.
In 4GL, I know I can just manually put in the hardcode filepath to open through SYSTEME2 raw OS cmd call but it is very annoying to maintain (about 5+ scripts to update) every time…
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…
After reviewing the product status options under product setup (Active, Obsolete, not usable, on shortage.. etc), we have decided that certain options are not applicable to our business process. To avoid confusion to our users, we'd like to hide some…
Hey Everyone,
About a year ago, someone had set up a "Fuel Surcharge" invoicing element that applies a $5.00 charge to every order. However, it was supposed to have tax excluded. To this day, the $5.00 charge is actually $5.60 because it is being charge…
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…
$VERIF_MOD
Local Char ZPRODCOD(30)
Local Char ZPRODCODOLD(30)
Local Integer YESNO
YESNO =2
For i=0 To max([M:POH2]NBLIG -1)
For [F:ITM] Where [F:ITM]ITMREF = [M:POH2]ITMREF(i)
ZPRODCODOLD = [M:POH2]ZPRODCOD(i)
ZPRODCOD=[ITM]ZPRODCOD
if…