Sage X3

From the screen I can see the value for LOC, but not in database, the value is empty.

I am looking to get the sql column name for total requirements qty located in available stock. If anyone could point me in the right direction, it would be greatly appreciated.

Dear Fellows, As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…

Hi, Sqlserver2018 Sage database, who used the “notification query” function? does it create problems for Sage's normal work? Sage X3 Version 11.12 ALTER DATABASE NAME_DATABASE SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE; CREATE QUEUE PortalNotificationQueue…

Hello We share same infrastructure with another company. They got IT, not my company. Their IT refuse me to use crystal report and access database for security. So we do Microsoft Word for all Invoices, Orders, etc. Like t min per Word to do all…

Hello, Is it possible to make a for-loop with a SQL "group by" or "select distinct" statement? Br, Carl