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

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

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…

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…

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've started doing some very basic scripts in house but I've run into a wall recently. I'm trying to emulate the same behavior that is seen with MANHLDREL tied with the manual hold button on the SO screen. That is, when the action is triggered, a window…

I am trying to make the Company Name field on a screen Capitals/Upper Case only. There is an Option column on the Screen dictionary that contains Capitals (selection A). When I set it to A and validate the CPYNAM field, it will covert any text entered…

We have set up the Purchasing dashboard for staff across the business to use and access orders. The issue we are facing is that the default gadget on the home page that displays the orders to receipt shows all available orders - this needs restricting…

Good afternoon. With the need of one of my clients on posting inter-company journal entry. During post inter-company journal entry, "inter-company NA10 / NA011" or "Inter-company NA10 " will display on the description field of counterpart of the transaction…

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?

Hi all, I am trying to build a SPE to capture a number (Field is a text), split the digits, multiply each one, sum all and validate the result. I have some questions: 1 - Now, I am working with STRING and I need convert this String to a Integer, so I…

Hello, I'm trying, on Sage X3 V11, to import a Task using the specific X3 Model with the help of AOWSIMPORT WebService. The X3 Model for Tasks defines the field separator as a new line (\010\013), but as soon as I put a newline inside the I_FILE in…

The requirement is to print the company name, address, and contact details of the party responsible for paying for duties/taxes on a delivery. This may be different than the BPC listed on the delivery record. I am trying to add a BP number and related…

When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL. When I execute the query in SQL, it returns the correct results. For example: When testing the same…

Has anybody created an API call for an ADC function? More specifically, I am looking at the ADC Material picking screen and looking for information on how to write a write api call for this. Thanks, Chris

I created screens and window which is shown below. The first problem I face is that when I clicked Save button, only the first row of the table in RFQ is saved. Both "RFQ1810002" and "RFQ1810003" did not save. Besides, the second question is that when…

Please any help will be appreciated. I am trying to clone a functionality from Customer BP Invoices under the AP/AR Accounting. In the Distribution field in Lines where you can perform analytical distribution I am trying to clone same functionality for…

I there, I'm new in Sage X3 V8 My Company has large Item descriptions with more than 30 chars lenght so we need to use both description fields, description 1 and description 2, but this 30 chars limit start to make a lot of troubles for the user becaus…