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…
We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…
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…
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…
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 don't understand what does the keyword "setmode" do, there is no help available on eclipse or on the internet. Can someone please explain it to me?
Hello everyone
I built a generic screen "ZTRANSPORTCO" for a customer. The screen is used in multiple windows.
The problem is when I try to "Jump to" another window which also has a tab with the generic screen "ZTRANSPORTCO" I get the following…
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?
After increasing length of DES Data Type to 250 and Validating. After I close X3 and re-open I cannot get into any function. I receive these errors: Function not defined for the value given
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,
I need advice and pointers to identify the root cause of the import failure issue.
Sage X3: v12 Patch 31 (latest patch by time of writing) Database: SQL Server 2019 Standard All components are updated to match Sage X3 v12p31 requirements.
On…
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…
Good morning Everyone and Happy Monday!
I'm attempting to add PTHNUM to screen POH2, but I am receiving this error "Fields PTHNUM: Undefined parameter OBJZON ( Type VCR)." Does anyone know what I'm doing wrong and how to resolve this? Thanks!
Hello everyone,
For our customer we developed a specific screen to manage plans.
In order to edit a plan the user has to press a check out button.
The user who checked out the plan can modify the plan.
In the FILTRE action we use the global Variable…
So I have been presented with an interesting challenge.
In our company we've set X3 to batch allocate all available stock to meet all demand in the system.
We also heavily leverage X3's ADC functionality. Our warehouse users are able to override the…
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…
I posted two supplier Invoices and observed it does not create a journal. I checked the accounting task and the journal on hold shows two. I check recurring tasks for the active time and it's okay. I deactivated the accounting task. Restarted batch server…
Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might).
I have some ideas, but I'd like to know how others…
hi all
how do you write & debug code in V12 ?
I was told that I can only use eclipse and it is very slow to debug + performance is bad + weird to attach eclipse to a process.
eclipse also disconnect from unknown reason during debug.
thx
B…
Today I want to take a quick look at a function that is useful for development, Source Verification. This tool can be useful to check for common programming errors and anomalies that could outright stop the code from working or could lead to other issues…
The correct syntax for the selection criteria for a Sage X3 date field is: [DD/MM/YYYY]
Classified as follows "DD=Day", "MM=Month" and "YYYY=Year"
Example :
Criteria using CREDAT in table for records with a CREDAT less than March 12th, 2020. …
Cause :
There is failure to communicate with MSSQL server.
Fix
1. Ensure SQL services are running
2. Ensure the servers can communicate if the system a multi tier.
3. Check firewall settings
Cause:
There are various possibilities including a corrupt ACLASSE table or an outstanding folder validation
Fix.
1. Try to validate the ACLASSE table through Development > Data and Parameters > tables
2. Test
if the above fix fails, perform…
1. Login into X3 system
2. Navigate to Administration > Utilities > About
take note of the web server version
How to folder patch level
https://www.sagecity.com/za/sage-x3-south-africa/f/enterprise-management-formerly-sage-x3-south-africa-general…