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

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.