There’s a limitation on Sage 100 data file size of about 2 GB in size.  One or more segmented files are generated automatically upon reaching this size limit. The segmented files are extensions of the original file, with the same fields and file structure. 

If a segmented file takes up to 2 GB of space, an internal process creates an additional segmented file. This process repeats for each file segment reaching the size limit.

• Example:
  1. IM_ItemTransactionHistory.M4T
  2. IM_ItemTransactionHistory.M4T.001
  3. IM_ItemTransactionHistory.M4T.002, etc.
• Example:
  • GL_DetailPosting.M4T
  • GL_DetailPosting.M4T.001
  • GL_DetailPosting.M4T.002
  • GL_DetailPosting.M4T.003, etc.

 NOTE: When running Rebuild Key Files, all segmented files must be in sync and present for the rebuild process to work properly.  Selecting 'Optimize Files' in Rebuild Key Files creates a new file. The process places rebuilt records into the new file, while clearing the blank records from the file. 

 NOTE: The maximum number of segments is 16. This includes the original *.M4T file. Around this number, Error #16 or other errors present when attempting to migrate or convert data, or when attempting to work with data (posting a journal or registry update, etc.). 

How to remove data files to conserve hard disk space and reduce backup storage volumes?

Error: "12 SY_RebuildFile_Bus.pvc 499" when running the Rebuild Key Files utility