7/22/2020: client interested once again. quoted at $500-$1000.

6/1/2020: Could have possible client interest in this.Waiting to hear back.

3/20/20: Molly's client paid to have subs all (from invoice adv search) added to report list. At the time adilas said they would pay to develop the same report under Inventory. It would use the same logic that was already written. Bryan started this project, Brandon finished. Not sure how far Bryan got for inventory report.

8/14/19: From Brandon's notes:

Working with Bryan on a deep sub inventory report. The thing that makes this one crazy is a mixed bag of sub inventory attribute filters (from across multiple categories). That little piece of multiple categories throws some major variables into the mix.

This is more for me... but we need to go back and do a full mini project to prep the field (general sub inventory area) better on sub inventory. We need to record the sub reference id numbers on the po/invoice line items table (both po's and invoices). We also need to record the main part id's, app type id's (items=11), and the part category id on the custom texts, custom dates, and custom numerics tables. We can use the main_id, app_type_id, and sub_id columns on the custom tables. We need to spend some time going backwards before we can go forwards with any speed. It may be a big mini project but hopefully it would help us as we try to go forward.