Sage X3

I was asked about a shortcut to print a screen array to an Excel export, instead of the user having to click "Excel Export". Thanks, Zoey

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…

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…

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…

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?

I am wondering if anyone out here has had any experience with the trolley build features with Datalinx? We are thinking of exploring "picking to slot", "Trolley Build", "picking to Carton" functions in our warehouse. Would love to pick someone's brain…

Hi, I would like to create more representations using Views/Tables. Requestors are very quick to create in X3V12 using Views/Tables, but very limited functionality specially on Landing Pages. The goal is to give user far more interactive dashboards…

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…

I have a custom field in the STOALL table that I would like to transfer to the STOJOU table when the transaction is validated/posted. I've been looking for an entry point to do this, but I can't seem to find it. Does anybody know if there is an entry…

Sage X3 allows a parameter to warn user for duplicate values in BPRVCR. How can this warning be change to an error?

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…

Hello All, If a Purchase Order workflow signature is not signed after 24hours can it be escalated to another person to approve? Thanks

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…

If my stored procedure contains the statement below. It works. select top 10 ITMREF_0 as ITMREF,ITMDES1_0 as ITMDES from ...ITMMASTER If I change to dynamic sql below, declare @sqlTextAll nvarchar(max) set @sqlTextAll='select top 10 ITMREF_0 as…

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, 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…

I've set up a custom field in the ITMBPC table to denote that a particular customer product needs to have a special dispatch label printed. It's a simple yes/no, so I have linked it to Local menu 1. How do I get it to display in the ITU screen so that…

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…

Hi, I was wondering of anyone has experience of uploading to the ACLOB table. We want to utilise the comments section in GESBPC and GESBPR for uploading Special Instructions on GESBPR and uploading Historical Sales Ledger / Credit Control comments…

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…