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…
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"…
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…
We have a scenario where we direct ship product from a supplier to a customer. Because of this and because we want to see accurate sales margins on the sales order, we have a need to change the cost of goods on our sales order entry screen so that it…
When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…
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…
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…
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…
I have created a UDF in A/P Invoice Header to hold a document number (separate from the invoice number) on our A/P invoices being imported from a 3rd party solution. That will work for invoices being created now. What would be the best way to update existing…
I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…
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…
Having added a UDF to the AR Invoice history Called Enhatch order Id. When trying to print a copy of an invoice from this record the UDF does not print and it has been added to the form.
Any ideas as to what link I am missing?
To see the invoice printout…
I added a tab to my Invoice Data Entry panel with UDFs
I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…
Hello, I'm curious to know if I can create user defined fields in Sales Order Entry and the same fields in Invoice Data Entry?
The fields are populated in the Sales Order Entry window, and then transfer to the invoice. The fields are in be added to…
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…
Hello Everyone,
Can anyone let me know that how to download SEPA (FRA legislation) XML file after posting payments through manual remittance. I am not sure whether any other software required to download SEPA XML bacs file or any special setup required…
Hi
I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank .
Later when there is an update on the Date…
Hello,
Can anyone help me with example code on how to get a User Defined Field in another object? I'm used to using oSession and oLines to get the header values and details for AP_ManualCheckHeader and AP_ManualCheckDetail. But I'm trying to get one…
HI all, in Sage X3 v11 I need to fill a grid on click but I can't find a way to add lines to my grid, can someone share a script to help me, i'm currently working on Sage X3 SPE Script of that window?
I have nearly 30 UDFs in PO Receipt of Goods Detail file and linked to posting/update files, work files and history files. These are working great.
Staff wants these same UDFs to appear in IM Transaction Entry for Receipts for those items without a…