Sage X3

Hello, can anyone tell me how can I setup the maximum stock quantity for a product site. I tried adding it in product site but don't know how it works, the system still allows me to receive more stock. I need such a setup that once the maximum quantity…

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

Hello, One of our user groups randomly started experiencing this warning upon logging in. Does anyone know a fix? Thank you, Zoey

Trying to create a query based on items that are out on loan to customers. My query includes an Expression calculation based on what has been delivered to a customer minus what has been returned. So using two tables QTY on SORDERQ-RETURND, therefore…

Hello Hello to all the Sage Community, I introduce myself i m from TUNISIA and i work on Sage Solutions since 1998 so about 26 years and i wonder if in this Community of philantrop and experience is there a Virtualmachine or Plateform to access to…

Hi there. There seems to be a de-synchronization between the product and its location. The product shows null quantity in the location. The location shows a quantity (59) but a null product and is "empty" Misc. issue and receipt is also messed…

Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…

Hello, Is there an easy way to duplicate an existing Function/Menu Profile? I want to take an existing Function/Menu Profile and duplicate it so that I can restrict the new one by specific sites or less access. Thank You

Hello, I am trying to calculate one invoicing element off of another and I seem to be running into a road block. I have tried using the "Calculation order" field, but this did not work. The next step would be using the "Action" and "Processing" fields…

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…

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…

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?

Hi all, We are having problems with the total import from the Analytics. The logs on the sedApta side show that a request is made but doesn't get an answer from the Sage Server. It does`t happen all the time, since sometimes the import process finishes;…

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…

We are hosting Sage X3 on Amazon server and very time when the sever restart, it's losing the SSL certificate. The external link will not be working, every time this happens, I have to reload the SSL certificate in SageX3 under Administrator. Then after…

Hi team, I am facing a challenge in returning a stock where as I have deliveries and I was able to create credit notes among the steps in returning the stock but I am facing an error as in below screenshot as soon as I select the delivery number so…

Hello, Please, how could I put the quantity requested to be 1 automatically as you get on the line. thanks to those who answer, Greetings!

1) Is there a way to mass delete BPS Invoices? I have 1900 to delete. 2) Duplicate and triplicate Invoices have imported into Sage X3v12 p17 from DocLink/DocAlpha. This is the second or third time it has happened. Does anyone have advice on what might…

I got an error while choosing the endpoint of the imported folder v12.0.21 on the X3 version 12.0.26. "Create session error : The folder version is different from the version of the root folder." , As shown in the screenshot below : Has anyone…

Hello, We are still using version 7. We have an export template we use to export invoices to be sent through EDI. Currently the export template creates a single text document with information from every invoice that needs to be sent. Is there a way…

Good day everyone, I am looking for the sales FOB field in sage x3. If there is no field in x3, is there a column in sql? So far I have been unsuccessful in finding said field. Any guidance would be greatly appreciated. Thank you in advance!

Good Morning, We are getting an error message when we try to set the reversal date to 01/01/2021. (The accounting date is 12/31/2020). This is only happening to some of our journal entries. Would anybody be able to tell me why this error message…

Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…

My company has encountered an issue where we can no longer enter any new Ship-To addresses for our account. It seems Sage X3 (v7 patch 8) sets a limit at 200 ship-to addresses per BP. ^200 Address Limit vs 1 Address^ Is there a parameter I can change…