Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Yellow
Assigned To: Brandon Moore
Created By: Brandon Moore
Created Date/Time: 11/25/2019 10:11 am
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
Priority: 0
 
Time Id: 5231
Template/Type: Brandon Time
Title/Caption: Sub inventory searches
Start Date/Time: 11/25/2019 2:00 pm
End Date/Time: 11/25/2019 5:45 pm
Main Status: Active

Sorry, no photos available for this element of time.


Notes:

We started out talking about options. Both Steve and Alan were on the first part of the meeting. Around 3 pm, Steve had to take another call and dropped off. Alan and I spent the rest of the time working on the project. Here are some notes that we took. We ended up making a new corp-wide setting and coding a quick and fast sub inventory search option.

- Ways of speeding up the cart search, especially for sub inventory or known sub inventory scans and barcodes.

- We could use session switches - are we searching subs or parents?

- On the seaches... switch the order. Maybe start with subs and then parent items. Currently, the different pages do different routines to search for the inventory values.

- Indexing of the database tables.

- Possible other table to show a summary of the main packages. Millions of sub transactions could be summarized into hundreds and thousands of actual packages, not millions (all of the sub line items and details per invoice or PO).

- Too many likes & wildcards. We looked into the normal part/item number searches. Each one has multiple places where we do like or wildcard searches. That slows things down. It does make is super flexible, but it does slow things down.

- See corp-wide setting #37 about the cart quick search drop-down options. We ended up adding a new one called Sub Barcodes. It will be launched when the new code gets approved and released.

As a fun side note, Alan and I built this whole piece together. I was coding and Alan was coaching me and pair programming with me. Good stuff.