Seeking Solutions for Organizing Sage 100 Reports for Effective Analysis


I've been using Sage 100 since 2014. While the reports I pull from Sage are good for viewing and provide general information, they're not well-organized for analysis work. For instance, I have an Open Sales Order report sorted by Order Number, which makes it challenging to organize for analysis because it doesn't arrange data into rows and columns, preventing me from creating pivot tables in Excel. Sometimes, there might be a random 'customer PO' in the middle of the page, making analysis difficult without extensive formatting. I'd appreciate any help if someone has found a solution. Thanks!