Sage X3

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

Hello, in the attached picture there is an issue with tax variance. Does anyone know if there is a location to set features/parameters for this or perhaps another way to solve it? Thanks in advance, Petras

Good Afternoon, We would like to find out if anyone has ever setup workflow escalations on purchase request workflow approvals. under WORKFLOW FURLES, there is a ESC - ESCALATION option when the EVENT TYPE SIGNATURE is selected. However, despite testing…

Hello, I am getting started with web services. I'm attempting to follow along with various introductory articles, however, our X3 only has 4 web services scripts listed where the list in most of the tutorials have way more. Here's our list: Any thoughts…

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…

We have a problem with one of our sites where, every now and then, a payment doesn't seem to match properly and we can't figure out why. For the latest case, the symptoms visible in GACCDUDATE were: - Payment: PAYLOC/CUR = 0, TMPCUR/LOC = 0, FLGCLE =…

Good day all, Reaching out to find out if there are any smart people who can assist with a possible solution / parameter regarding the following scenario. The process is as follows: PR (purchase request) is created with a QTY of 10 units and submitted…

Hi there, I successfully added the "internal reference" field from the purchase order to the "Order lines inquiry" screen. Now we want to add the field to the filter. I already added and "linked" the header and cirteria fields in the "CPP" inquiry…

I feel this should be simple. But can't find any information on it. I have a purchase order for 20pcs, I received 26pcs, but I was only invoiced for 20pcs. How do we get the matching to go away?

I am wanting to show a custom field in Pick ticket PRH1 from Item Master ITM. The field is showing, but it is duplicating the last line to all lines above. I have added the affzo, but I think I am missing the NBLIG and am not sure how to use it. The…

Hello, everyone! We are in the process of selecting barcode printers compatible with the X3 for our shop floor. We have 2 options so far: ZEBRA ZD421, DIRECT THERMAL, 203 DPI, USB, USB HOST, ETHERNET, BTLE5, EZPL TSC TX210, LCD, WIFI READY,…

I need to produce a Multi-level BOM report with costing details and totals. The "Print BOMs" report under common data gives the correct BOM structure, but I'd like this with Material, Labour, Overhead costs - and totals... Does anyone know of such…

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 don't understand what does the keyword "setmode" do, there is no help available on eclipse or on the internet. Can someone please explain it to me?

Hello, I'm trying to hide some fields from the Purchase order lines. Exemple: LINOCNDAT and LINOCNNUM. I tried to look in Setup → purchasing → Entry Transaction → Order But I can't find my fields in there. I tried to set the field as "hidden"…

Created a SNX webservice for SNX object and calling actionObjectKeys method with Action Code: b and key: CUNSSSNUM and value: SCS0007969 (a valid stock count session). Running the generation button manually generates the list successfully but on the…

Context: I am moving over a X3 pu9p5 MongoDB over to X3 v12p32 as a test run. I have done the necessary grind from MongoDB from 3.0 (pu9) to 4.4.12 (v12p32) as per MongoDB requirements. I have also rerun the syracuse install to confirm Syracuse…

I am trying to import/export BPs from one endpoint to another. However, when I import the file the BP numbers are chronologically assigned instead of keeping the same BP numbers from the exported file. Where do I go to adjust this?

Hello Sage City, As a Sage partner, I have heard numerous horror stories about the "PURGE" function in older v5, v6 and v7 versions of Sage X3. A customer of mine will be migrating to v12 shortly and asked about purging old data from the database…

Hello, Is it possible to restrict a user to acces a folder? I'm trying to give acces to only one of the 2 folders we have but the workaround i've done is to create a new group and give acces only to said folder. Is this the correct way or i am doing…

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…

Hi, I am building an app, and my goal is to interface with my clients product information (they are using X3). Most of them have custom fields in master data -> product. Right now, we didn't find a way to query custom fields via GraphQl implementation…

Hello All, So I'm trying to setup a BoM for a process driven product formula which would look similar to this: Phase 1 Instructions (Component type: Text, Type: Active) Input 1 Weight (Component: Normal, Type: Physical) Input 2 Weight (Component: Normal…

Hi, I'm trying to make various queries in X3 using graphql, and I'd like to retrieve, say, items from the 300th to the 400th. I know I can use "first:100" and "after: sometag" to get 100 items starting from sometag, but I have to know the tag. Meaning…