Take a look at Sage 100 Premium (SQL db).  You won't loose any sleep over speed or size issues.

Greetings,

As of Sage 100 Version 4.40 and above for Sage 100 Standard and Advanced, the files can be as large as approx. 28 gig.  Sage 100 does this by creating file segments for individual files when the files grow larger than about 1.8 gig.  At this point, you will see the files segment so there will be the primary file and then the segmented files like:

AR_InvoiceHistoryDetail.M4T

AR_InvoiceHistoryDetail.M4T.001

AR_InvoiceHistoryDetail.M4T.002 and so on up to 15 total segments

For operating purposes, Sage 100 treats the segmented file(s) as if it is one large file so there is nothing special that needs to be done.

For files that grow this large, you may notice some delays with certain processes if trying to access all the data like running a history report for all invoice detail.

If it is just a couple files that you expect to be over 2 gigs, then Sage 100 Advanced should be fine for you but if you have multiple large files or you want to ensure best performance as BTMLINESOFT mentioned, Sage 100 Premium may be the better option.

Thank you,
Kent

Thanks for the input, much appreciated.  Instead of going to Sage 100 Premium, I would like to think we should go to Sage X3 or Acumatica.  Anyone have an opinion on either one of these?

Changing ERPs is a huge undertaking. 

Changing to Premium mainly just needs SQL licenses (+potentially new Sage 100 licenses)... and the technical switch is a similar amount of work to an upgrade.  Users won't see any functional differences (aside from things like Excel queries).

Thanks Kevin.  But we are a manufacturing company that is growing quickly and Scanco's OM is quite cumbersome to work with that X3 and/or Acumatica seem like they'll be able to handle our growth and workflow better.  But I am open to any suggestions you or anyone else may have on the matter.

This is a Sage 100 forum and you'll probably not find much expertise here related to other ERP's.

Understood Kevin, but I've seen some consultants I've dealt with over the years that I'm hoping may have some insight into this matter.  It's going to be a big jump whichever way we go.  Thanks for the SQL information though.

The devil is always in the details and the salesmen know how to make it sizzle.  Just ask a MAS 90 user I am working with who was convinced that Netsuite was the way forward.  18 months later and $100K down the drain, he is rethinking that decision and is seriously looking simply upgrading Sage 100.  Upgrading to Sage 100 Premium is as Kevin says, getting Premium licenses (usually NC) and migrating to the SQL database.  Your users will hardly notice the change and your original issues noted above will be resolved.  

Now you bring up Scanco OM issues.  My first thought is does your reseller EXCEL at OM?  If not, perhaps you should find a quality OM specialist to sort through your concerns.  A good specialist makes all the difference in OM.

Just my .02.  It will be well worth your while before throwing the baby out with the bathwater.