Sage X3

I have define 1. Product Line Attribute 2. Response table 3. Product Line See the screen shot-1 Below information I need in Product 1. Construction: 1X1 Rib 2. Composition: 100% Polyester 3. Open/Tube: Open 4. Design Type: Solid …

I am looking for the possibility to terminate a web client session via 4GL code. If I am doing so via X3 GUI, there's a REST POST fired using the representation "sessionStates" with the endpoint "disconnect". Is there any chance to do this by code? I…

Hello, am wondering if someone can explain the logic behind Product Site Default Location setup? Problem: Snap shot above is how we are picking our apparel for replenish to work, but I don't think it's setup right 100%. Does anyone have any expierence…

Hello Community! My company has a large database of raw materials, currently the purchasing plan is done manually using MRP results along with checking Projected for each raw material , one at a time. As such it's a very tedious and inefficient process…

Hello, I want to change the workflow sender depending on the workflow code [F:AWA]CODE. The workflow code in question is ZTEST However, in a custom ZAWRKMEL script, the [F:AWA]CODE value does not seem to pass through. The result is an email sent by…

I want to delete product-site records that they do not have transactions in that site. when I use transaction mass update, it dose not check it has transaction or not and delete it directly and it is wrong because I want to delete the same record from…

Hello All, Can someone explain the reason for these two fields listed in the subject in "Products" screen. I've read the basic break down's from "F1" help, but we are looking for more real world examples and purposes of these two fields. Could either…

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

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…

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 write the following SQL Query as 4 GL Link instruction: As seen in above screenshot this returns a record. With the following Link statement I try to make this SQL in 4GL. In 4 GL I make a left outer join and check with [F:YCFPJOB…

Hello I get the error Error 26 : Internal error Inconsistent reference value (11026) at @X3.TRT/REQUETES$adx (153) when trying to read a custom table in a custom batch job script. Part of the key from the custom table is a counter variable which is…

Hello - we are new with Sage X3, never worked in it before. We have an order where the customer ordered an item, but we are out completely. So we need to short the order to 0. SAGE will not let me change the ship qty to 0 in the pick ticket screen…

hello every one I get this error when I try to validate delivery is there a way to fix it?

Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…

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…

We need to create a warehouse site (Non-Financial Site), that should not have any link to the company's financials and inventory once the delivery is done. on the other hand, the site should only receive the items, and send the partial deliveries upon…

Hi I am just going to leave this here for Sage to hopefully acknowledge. I know its not mission critical or stopping the system working but seriously that I have to tell users Sorry you have to choose one of these is becoming quite offensive …

Hi i need to setup a process so that locations are auto selected based on type of transaction and process for ex. Here if I select the receipt type as "Return receipt", then system should auto select the location code as "RETURN" Is there…

Please HELP! Problem: Currently, we can't allocate sales orders at a detailed level according to "unit of measure". At one point in a selling season we have sales orders for items that ship parcel (eaches) & those same items also ship LTL/ Full truckload…

Hi, Not sure the exact steps but this normally occurs after I set up Security Profile, Roles, Groups, and a user for a test run in Syracuse Administration module. Often occurs in Google Chrome. I normally use Firefox as an emergency when this occurs…

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?

After reviewing the product status options under product setup (Active, Obsolete, not usable, on shortage.. etc), we have decided that certain options are not applicable to our business process. To avoid confusion to our users, we'd like to hide some…

Hi, We have been recently receiving the following error below and it's almost all are Web Service calls to fail, can't figure out what is causing the issue, any help would be appreciated. {"code":"SAGE_X3_ERROR_MESSAGE","defaultMessage":"X3 Error…