Browse By Tags

Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…

Hi, We've been using Business Works for years and now need to integrate Order and Invoice data into our in-house proprietary external database that manages our operations. We have a few questions: Can we use SQL to set up an ODBC connection? …

Hola muy buenas! Estoy teniendo problemas añadiendo una entrada de menú con una consulta del peticionario SQL. Cuando ejecuto el punto de menú me dice que la consulta no existe, aqui adjunto un par de capturas para que veais. Que puede estarme fallando…

Hello, I am trying to build a data model based on the LOG_VIEW_USAGE table from the SEI database and I'm getting the error below when trying to add tables in the data model designer : Nectari.DAL +++: Index was outside the bounds of the array…

Bonjour tout le monde, suite à une mauvaise manipulation le dossier d'hitorisation (qui est par HDOSSIER) est supprimé de la base de données. pourriez vous m'aider vu que je dois valider la table STOJOU mais ça me donne une erreur comme quoi des vues…

Can someone help me with the below code? In the below which I have put in bold it only picks up if there is information in Analysis Code 9, but not if the column is left blank. Is it possible to update the below so it picks up where the Analysis Code…

I have just created a query which brings back sales order information but I am struggling to bring in the Stock Item Code as well - below is the current code I have done but could someone help me to add in item code? SELECT DocumentNo, DocumentDate…

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

Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS

Buenos días, Desde Sage obligan a mi empresa a migrar a Sage 50 y he solicitado una versión demo antes de migrar, ya que quiero comprobar que nos conviene ese cambio, si no seguiríamos en Contaplus o nos vamos a ContaSol que es muy parecido. El problema…

Hello, I want to ask about a custom report that I made using crystal report. So my custom report has been completed. The report uses a stored procedure because it saves time, compared to using a table / view. then I put the custom report into sage 300…

Hello, I was wondering if anyone else ran across this issue and if so, how it was resolved. We have identical item numbers that appear when we search for an item in item inquiry and item maintenance. Selecting one of the item numbers results in…

Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…

Important alert: Do not use SQL Server module version 22.x with Sage X3 until further notice. Use SQL Server 21.1.18256 only. PowerShell 7.2+ is a prerequisite for Sage X3, along with the SQL Server module for PowerShell. SQL Server module version 22…

Hi everyone. I'm hoping someone here can answer this, rather than having to jump into the support gauntlet. I work for an IT firm and a client of ours is presently running Sage 300 on a server VM, connecting to an MS SQL database on another VM, which…

We need to track all additions/changes/deletions in the AP_VendorElectronicPayment table. Has anyone used scripts to track the changes successfully? We are using Sage 100 Premium. I have not used scripting in Sage, but I believe this could be a solution…

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

Hi, I am looking at our backend tables and I am trying to determine what user did what. In our worktickets I see UserCreatedKey and UserUpdatedKey but I cannot find a table that links those to the employees table. I read that they might be stored…

A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…

Hello - I am struggling with the report writer and need some clarification (a long shot, since there is almost 0 documentation on the subject). I am proficient in T-SQL, so am confident in my ability to write queries, but can't get something very simple…

Hi. So I am not a sage engineer, but a Linux system admin, I work for a company that also has an external sage IT provider that handles a local on-site server with Sage/SQL etc. The current setup is a traditional DC and separate sage/sql combined…

One of our users runs a script in the evening to modify data. Once in awhile, they will receive an error that data is locked by user. I know that we can kick users by going into Help > Current Users, but I was wondering if there is a table containing…

I am trying to develop a query that involves aggregating invoice lines such that values for kits are the sum of their components. I can see there is a flag (LINTYP_0) to determine what is a kit and what isn't, however I am having a hard time figuring…

Bonjour à tous On a un serveur SageX3 et dans le même serveur le SQL est installé. On a créé un autre serveur SQL et on veut que SAGE X3 pointe vers ce nouveau serveur. On a essayé de modifier le fichier adxinstalls.xml en remplissant l'adresse…