Sage X3

Hello, My question is simple. We do cycle counts based on location ranges. However, when you select Location, the ABC selection becomes unavailable, and I've been unable to figure out a "Locations" Count formula to include the ABC class. Likewise…

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, I have written a simple SQL query that returns info about sales returns. I am trying to get the return code description to show up, from the ATABDIV table (Miscellaneous Tables) but it's throwing this notice that the column name, LNGDES_0,…

Bugs: Amazing how this graphical query doesn't compare to anything in the market - Crystal, Hyperion, Access, and I mean it doesn't compare to the1990's versions of these softwares. today I met another bug - i am sure someone has found it before but…

Is there a way to export or see the fields used on old Graphical Queries that are no longer visible. Will then use this to create new queries via the old graphical tool

Hi! I'm a newbie with Sage Enterprise Management (v.11) I've made a consultation, and put it in a home page, but does not refresh when clicking the button. At the opening of the homepage, sometimes is filled with record, other not and I have to…

Hi everyone I would like to know if it is possible to combine (concatenate) 2 or more fields in an Expression in Graphical Query? I have tried the basic SQL CONCAT function in the hope that it might work, but without success: Also tried rewriting…

Graphical Query only on Table BPCINVLIG -> RESULT: Receipt-number (Link) goes to Sales and not to finance --> ? dependig on the Fieldtype

Hi, there's a way to filter a picking left list of orders (SOH) by a new table field's value on Sage X3 V11?