Sage 300

Hi all, I want to make the email field in AR Customer unique, means only 1 email for 1 customer only. How can I do that? I assume I just set the email to be unique in database level, is there any implication to expect? Thank you

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.

Our Sage users constantly keep getting there errors throughout the day spontaneously * Database error (operation=GET . error=****) [Microsoft] [SQL Server Native Client 11.0] Communication Link Fail. Please refer this error to your database administrator…

Random error received by numerous workstation users at all different times of the day. Some when they first go to open sage, some while they are in the middle of working in Sage. This has been happening following the most recent Sage 300 2016 Product…