delighted to hear it.  Shopify has been pretty amazing for my business.  This is honestly the first real show stopper system-wise I've run into.  There's just no way to get an accurate pending fulfillment report from the orders export CSV because of ...

report toaster works quite well around this. free version (requires shopify basic) lets you run the reports but no export. reasonable monthly fee.   solved my reporting issue in 15 minutes.  not affiliated but definitely see the value.

this issue has been around for years and is still a problem

3 years later.  still the same problem.