Sage X3

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…

Hello! I'm Sage X3 developer and I having issues with Grid development. Does someone have a documentation about NBLIG, nolign, counters and grid screen? Thanks.

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…

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

Dear all, I'm new in SAGE X3 and wanted to know if there is a possibility to change the default value for the field FMI in a Sales order line. I found in the entry points documentation that this can be done by using the entry point ALIFMI but not…

We are trying to make a pie chart off a data model using the "New View" option. We are getting an error message, "Index was outside the bounds of the array.". Have you seen this message and how do I correct it? Screen shot below.

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…

I added a new column to an inquiry screen. Since the field is from a table not included in the inquiry, I used SPE code to populate the field in the inquiry. This works fine, but when I export it via Excel, that field isn't populated. Does anybody know…

The client would like to request for a change in the logic of the Line Description of the reversals In Journal entry function (GESGAS), while clicking reversal from the right side button, the system will create reversal journal. In that Journal the…

Is there a way to force the popup screen on a qty line modification of a purchase receipt?

What I would like to accomplish is that ability to tunnel quickly to what a product looks like without sending our users to the Product screen. The screen I would like to implement changes is the Sales Order entry screen. Initially I was thinking that…

Hello everyone We have programmed a specific inquiry for our client. There should be a back and next button. Only a part of the data records should be displayed. When you click on next other records should be loaded. In the function GESGTC (Inquiry…

Good morning I have added a field to SORDER, and then added that to SOH0. I am then receiving a heap error, but not sure what to do next. Anyone have any advice?

What I am trying to do is write a query that will list all SEI processes and the Folders they are located in. I can't seem to find any table in the SEI database that contains the folder structure. Is what I'm trying to do possible? My organization is…

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…

Hi Everyone, I am trying to add a current date widget to an SEI dashboard. I have tried to add a KPI view with a calculated column containing @@CURDATE without success. Best regards, Tarik

I there, I'm struggling to get a verification if a Variable is empty or not on creation of a sales order. The Variable is in each line of the sales order, i need to emmit a warning and block te creation if one of the lines has the var empty Here is my…

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…

I have a need to set the format of fields on a screen to "Display" when a certain value is detected in a field. I know how I could suppress it conditionally, but that's not what I want to do. Basically... if I were writing the suppress for it I would…

I have a list of suggested and firm workorders in an SEI worksheet coming from the ORDERS table. Very straightforward. What is stumping me is I'm trying to make a column that counts the number of work orders that have the same product as the current record…

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…