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.

It currently works... but the way around the park is up the slide, around the merry-go-round, and past the swings. There isn't a straight line right now. We could use some loving there.