Browse By Tags

  • How to connect Sage CRE Accounting with existing database

    Hello, i've database file. i need to load data in my sage cre 300. I've installed sage cre 300 in my local machine but not found database dump and database load application. Could you guys help here how to connect with this database? Thanks, …
  • Where is Sales Delivery line LOC field stored in database?

    From the screen I can see the value for LOC, but not in database, the value is empty.
  • What is the column name for AvailableStock->TotalRequirements in sql?

    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.
  • Deleting Sage X3 folder from database

    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…
  • Struggling to tie Lot # to Delivery Data

    Hello, It feels like I'm overlooking something simple, because tying lot numbers to our delivery records should be fairly straightforward. When I pull up a sample delivery record in Sage X3, I can select Stock lot and see which Lot number were included…
  • Alter database SAGE

    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…
  • X3 Access database

    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…
  • Failover Clustering/Mirroring for Sage EM

    Hi, One of our client is planning to setup a strong failover system for Sage EM, and we are planning to set up SQL clustering to achieve it. But I am not sure how Sage EM is configured to consider the SQL clustering. I would appreciate to have a guidelines…
  • Group by or distinct in for-loop

    Hello, Is it possible to make a for-loop with a SQL "group by" or "select distinct" statement? Br, Carl
  • Does Sage HRMS 2017 support SQL HA (High Availability) databases?

    We will be upgrading to Sage HRMS 2017 and Sage Employee Self Service 2017 soon. As our company has two data centers I am interested to know if these products support a SQL HA cluster so that I could offer failover capabilities that we've not had previously…