Sage 200 Evolution

Hi there, I was wondering if someone could point me in the right direction perhaps please? so I am trying to find out what group a stock item (inventory item) belongs. SELECT * FROM StkItem WHERE Code = <code> SELECT * FROM _btblInvoiceLineDetails…

Hi there, hope everyone is well. Quick Question if I may. Is there training or documentation on the SQL table structures and queries for Evolution 200's database? I mean with trail and error and the Database Dictionary one gets to a SQL query that…

Good day, I am in the process of buying SQL for our Sage Evolution package. We have 20 licenses at the moment for Sage (for our finance team who uses the front end). I know we need to get a Standard License, Media Pack, and then CAL's. CAL's are extremely…

Hi There. We are discontinuing a service with one of our Sage consultants. We wish to take on Transaction integration inhouse (SQL environment). What is the best way to go about this? Do we have to use a consultant, or can we adapt this technology…

Anyone ever installed Sage 200 Evolution in a SQL Cluster environment. Utilizing the "listener name " when populating the Licence details so that if one SQL server fails , it will switch automatically to the backup server with no issues with the licencing…