Sage X3

Looking for an explanation on what "Last Receipt" field means in detailed stock?

Hi everyone, The current report name in the email : jobrpt_YNA-CUSSTA2.pdf (The YNA-CUSSTA2 is the name of the report) Expected report name: if the user selects one business partner : SOA_BusinessPartnerName.pdf If the user selects more than one…

Good day Everyone I am trying to make an email notification trigger (not the problem this time) and one of the fields is formatted to RTF. Therefore when the system sends the email it includes the RTF formatting. Is there anything I should be putting…

Is it possible to change a field title in Sage X3?

I'm trying to create a report and need customer contacts. Does anyone know if there are customer contacts in SEI?

Hello, I am trying to include empty locations in my location count but it doesn't seem to work. I have tried using a 'Locations' count formula of "[F:STC]OCPCOD = 1" but it still doesn't work. Is there a way to include empty locations in an annual stock…

Hello, I am building and SQL query with itm ref and standard cost. We use simple manual standard cost (FY, dates and cost). I can join ITMFACILIT and ITMMVT, but what is the ITMMVT register applied to the aricle-site?

Good Afternoon, I need to know if it's possible to export the BOM structure massively and with a connection to the my Sales Products for consulting the consumption history of components, and if possible, also export the Operations for consulting the…

Hi Guys, We are trying to use the DMT V2 templates (we have also applied the October Hotfix) . When we try and validate the XADMTAUD query (for the audit check/logs) this validates ok, however when we click on Search we get the following errors …

Hi. I have v12 (2023 R2 (12.0.34)) and I create new window type Miscelaneus and Display = Full screen. I add two new buttons with code z an i , one validating and another no validating. In SETBOUT ACTION, I add this lines: Call VIREBOUT(CHAINE…

Hi all, We are using Homepages to create dashboards for users with our Sage X3 solution. I've been asked to find a way to filter the existing dashboard data by 2 different axes: by Site and by service. - we have 3 physical sites with multiple sites…

Hello, Im trying to filter invoices left list based on two entry transactions. Here is what I came up with: $ACTION #************************************************************************************************************** Case ACTION When…

Hi, I have a custom screen with a Create Sales Order button. As soon as user clicks on the button, I am calling a webservice to create Sales order. How do I write the Header and Footer text from my Custom screen to Sales order screen using the web…

Hello, I have some questions about stock queries: Is it possible query all the stock in a site (and not always filter by an article reference) ? And the other question Is it possible to query the stock with separate lines for each serial number…

Hi there. I've created a custom Funprog that returns an integer value between 0 and 4, when an item reference is passed into it. The intended use is as a filter for the stock count 'Product' Formula, to only generate a count with items where this Func…

Hi there Is there some way to generate a pick ticket through code using only a sales order number? Ie. what the "Preparation" button does in a sales order? Thank you Zoey

Hi, Is it possible to create an specific script, in model export, in order to filter by code some registres to be exported? I need it to check a value from a table that is not linked to the model's object Thnkx

Hi there, My navigation bar changed overnight. Just wondering if anyone knows what happened. Everyone else's seems to be normal. Several items displays alternative text that does not align with the rest of the users. "Inventory" instead of Stock…

Hello community, i'm trying to modify a bom object using web service object bom ( bomp : transaction ) but it's always returnig "fiche inexistant : record not exist "

I need to create inbound(expose) rest api in sage x3. one of the property related to joing table can not filter in rest api url? How to filter the joining table proprties

Group, A question from a co worker was asked of me a couple weeks back, and I'm late asking this question. Does Sage have report cards, vendor grading capabilities? Doesn't have to be anything too complicated. The basics would be a great start. I really…

Hello All, Kindly help, I am getting error message when I try to validate payment screen (PAY00) I increase the description field length to 150 characters and when I validate the PAY00 screen, I am now getting the attached error message. How can…

Hi there, I have a need to add a custom field to the grid array in screen PAY1, but I noticed the screen itself it is marked as "Templ. screen" and the verification button is greyed out. I tried adding the field anyways and verifying entry transaction…

Hi, I'm doing try install version 12.0.27 and when I start create "Customization and Menus initialization" the aplication returns "econnrest read" like picture below: Any suggestion ? Thanks

Good day all. I want to write a small specific with an action on a field. If Field A = 'condition' then Field B = Mandatory user input. Mandatory user input, users cannot move away from the field until they enter the data. What is the command in…