Sage 300

Hi, I hope you and your family doing well in this pandemic situation. I am doing a course in udemy on Sage300erp and I face some problem. course link: https://www.udemy.com/course/sage-300-erp-installation-and-setup-guide-for-beginners/learn/lecture/1757264#questions…

I would like to know if there is a way or a tool that can be use to reduce Sage300 database. I have a company database of 90GB size with data since 2000.

I have been troubleshooting a performance issue with Sage 300 ERP 2018 (Bulid 0). It is exacerbated when more users are on the system which for us is only about 10 people. If one or two are on then its tolerable. Nothing has really changed in the last…

Looking for someone who knows their SQL tables here. How can I use SQL to identify the active fiscal period? I see the CSFSC table but what is the best way to determine which fiscal period start date to use? Looking at BGNDATE1, BGNDATE2, BGNDATE3,…

Sage 300 2017, MS SQL Server 2016 A customer moved their Sage database to a new SQL Sever. User performance is dismal when they take the old server off-line, but it operates within acceptable parameters when the old server is online. Any ideas? What…