Sage Alerts and Workflow and DataSelf Business Intelligence come to mind.  Both can do web based dashboards.  Note that when a sales order is shipped and the invoice posted then the Order no longer exist in the Open Sales Order files, only in the history files.

Thank you - from what I can tell Alerts and Workflow looks like it's mostly intended to help with Accounts Receivable, however, I haven't looked into it enough. What I'm really looking for is something to help manage open orders - do you happen to know of anything or know if the systems you mentioned already will do a good job of this? 

SA&W is an ODBC reporting tool, and can query SO tables just fine.

What business problems are you trying to solve?

I don't know how I missed this response - I'm sorry. I'm trying to help keep orders on track, since we have a lot of problems and our manufacturing process is complex, involving a lot of overseas purchasing, as well as processing in our facility. Often times, an order isn't able to be fulfilled, or the facility ships incorrectly in some way or other. These are problems on their own, but I need to be able to have a tracking sheet that clearly shows where each order is and what's going on with it.

I don't know how I missed this response - I'm sorry. I'm trying to help keep orders on track, since we have a lot of problems and our manufacturing process is complex, involving a lot of overseas purchasing, as well as processing in our facility. Often times, an order isn't able to be fulfilled, or the facility ships incorrectly in some way or other. These are problems on their own, but I need to be able to have a tracking sheet that clearly shows where each order is and what's going on with it.

To be honest this type of situation cannot be answered on this forum. This is a situation where someone like Kevin, a reseller consultant comes on site and works with you. Someone who knows Sage Alerts and Work Flow, ScanForce and other third party options and can arrange demos. Where are you located.

Exactly what BigLouie said.

It sounds like you actually need to get a handle on the workflow, not the orders.  You might want to reach out to a manufacturing specialist.  Production Management / Operations Management (JobOps) deal with those considerations and you should have a detailed discussion with someone.

If you just need help managing raw material inventory, take a look at Sage Inventory Advisor.

I understand - I'm in southern CA. We have a reseller, but they just ramble so much, charge a TON and accomplish nothing. It's not been a good experience, which is why I'm here trying to sort things out myself the best I can.

Thanks - we're doing much better now than before, but we're still at the mercy of what happens (or doesn't happen) overseas. It's difficult to operate in California, let alone the US. I'd like to see how the inventory advisor helps with raw material, which is often difficult to track. Cheers