Sage X3

Does anyone know where or how a cash requirement table TMPCSRQ gets populated? The report code that is used is NA-CSHREQ.

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, I am trying to get ITMREF into a workflow when sales order is deleted. Below is my setting, but it does not send any email. Any clue to troubleshoot this?

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…

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, The title says it all. I had a discussion with a Sage rep a few years ago that gave me the impression that true Sage X3 SaaS was around the corner in the US. Since then, I've talked to vendors in Canada and it seems like the only options…

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

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

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?

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?

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

The credit control section of the management tab is grayed out on the system and cannot be amended. Please assist with possible solution

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

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…