RKL eSolutions Blog

How to Resolve Slow Performing Work Order Reports in Sage 100 ERP

Written by RKL Team | Jul 2, 2015 3:43:02 PM

If you're a client using theSage 100 ERP Work Order, you may have noticed that standard Work Order printed documents, such as the WO Traveler, take longer and longer to process and print over time. The reason for this is due to localized data caching in the Sage work order Crystal "work" tables, which are only used at report printing run-time.

But don't worry, there are ways to speed up this process. Keep reading to find out how.

 

Do NOT Reinitialize Sort Tables!

We found a related Sage knowledgebase article which instructs Sage 100 users to reinitializing a series of tables, including three “sort” tables which actually should not be reinitialized. That’s because this process purges work order data that you’ll later have to re-enter - and does not actually help the printing issue.

How to Resolve Slow Performance

RKL eSolutions recently documented a solution for slow-performing Work Order module reports in Sage 100 ERP (such as travelers, etc.).

To reset work order document printing:

  1. Reinitialize WO_21, WO_22, WO_24, WO_25, WO_28, WO_29, WO_30 (work tables)
  2. Rebuild work order sorts

If there are still issues and you are prepared to re-enter all work orders that were in work order entry:

  1. Reinitialize WOV, WOX, WOY (sort tables)
  2. Rebuild work order sorts

If you're not familiar with the technical aspects of Sage 100 ERP Work Order, don't worry. This issue can be complex and difficult to navigate, which is why we recommend reaching out to RKL eSolutions Support for help. They have the expertise and knowledge to guide you through the process and answer any questions you may have. Don't let slow-performing reports and printing issues hold you back - get the assistance you need to optimize your system and streamline your workflow.

I Need Assistance