I would love it if we could do that myself,  but I'm not aware of a way to do it.  :(

This would be a good one to put on the suggestions site and get everyone to vote for it.

Update:

I just put it on the ideas site.   Go vote for it!

What version of the Sage 100 ERP product are you using?  Why do you need to rebuild sort files every night?  This is a utility to fix data that has issues so we should be looking for the source of the issue.  

We are using Sage 100 2014 Advanced ERP version 5.10.1.0. We don't necessarily have to rebuild them every night but usually once every 1-2 weeks we will notice that calculations are off, usually we notice this in Item Maintenance. The quantities on the main tab of item maintenance don't match up with the real data, quantity on sales order for instance has been off. We run a rebuild of the sort files and it does a recalculation and it fixes it. There are a ton of transactions done each day in the system and some of them are offsite done over a VPN so I have been assuming there are just occasional transmission errors.

We are using Sage 100 2014 Advanced ERP version 5.10.1.0. We don't necessarily have to rebuild them every night but usually once every 1-2 weeks we will notice that calculations are off, usually we notice this in Item Maintenance. The quantities on the main tab of item maintenance don't match up with the real data, quantity on sales order for instance has been off. We run a rebuild of the sort files and it does a recalculation and it fixes it. There are a ton of transactions done each day in the system and some of them are offsite done over a VPN so I have been assuming there are just occasional transmission errors.

I would definitely agree that finding the source of the errors in the first place is a priority.   Unfortunately,  these errors have been around for many years and since they are so intermittent,  no one seems to have managed to pin them down.  :(

We rarely had this issue with just one warehouse, but since we started using multiple warehouses it happens more often.  We do a lot of transfers and transactions between warehouses, and change the warehouse on a lot of Sales Orders, so we see this a lot more.

I rebuild the Sort Files once a month during closing unless someone notices an Issue, then I will rebuild them at that point too.

Joe

You're not the only one with the issue.  We looked at scripting a solution as well, but then paused because all of our users are not great about closing out.

Link for the idea: https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP/Idea/Detail/25513

This idea is virtually the same thing, but is asking for a solution to the issue. https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP/Idea/Detail/15357

I voted for the idea, hopefully they will add this functionality to future versions.