On a Zoom meeting with Kelly, Cory, Steve and I. We were going over a number of different topics. We started out on expense/receipts and logic on limited expense types per vendor. Kelly was saying that we should only limit things if we know enough information to actually limit things. There was an error where a vendor had been assigned to a single expense type, but then that expense type got made inactive. She couldn't get into the expense/receipt. We had her go to the vendor and remove the limit by expense type value and everything worked fine.

We then switched over to talking about sub inventory and sub inventory attributes (sub attributes). We spent tons of time and I took a bunch of notes. Here are my notes:

- Kelly went through things to find the gaps

- Parents and children are so separate - you have to know what goes where

- She started on the grouped inventory report (just shows counts from the parents).

-- She was hoping that those quantities and costs would be able to show the same values.

-- Investigating and auditing - Going deep

- Cost of sold adjustments - 2 sides on an invoice... one positive and one negative. ICC - internal cost corrections (future project) - cleaning up the dust - bulk tools are needed.

- On big reports, we need to look at the size, and maybe do backend data pulling and then showing data.

- She has to go to the usage on each one to look at what is going on.

- Accurate inventory values - this is a big lift

- She needs an extended cost per - cost * qty = extended. We just show the cost and the quantity, not the extended cost.

- Clients are saying that their reporting is way off.

- Disconnects between PO line items - parents and subs

- She was using Excel pivot tables to get super close details to what we were showing.

- Cost changes, rounding errors, some parents and some subs, negatives, etc.

- In order to find all of the possible problems, you have to get so deep in the usage and details.

- How do you help clients fix items, quantities, costs, and usage, etc.

- When auditing subs... it would really help to show which ones have which costs

- Part status - active and allow sub only - could be both.

- The knowledge level to do an audit.

- Multiple tabs open and pulling data at one time.

- Level of trust... - I could pull more data but is it even what I'm looking for?

- Pagination of the data - say 40 pages - I need it all summed up - with what was what... in/outs, cost changes, etc.

- In Excel, she had to do find and replace, build special comparisons, standardize the data, etc.

- She had to figure out what was off and then go in deeper. Basically, she would love to see the known issues or sub sets of the data. Maybe even comparing things and helping them find the issues.

- Some of the dates... in the past - you can't even fix something - How do you fix it without adjusting things going forward.

- It would be nice if there were alerts, notices, or somehow finding those problem children.

- It becomes so complicated that they skip it. It is very manual on the fully deep audit.

- Locking things down - ice-down dates - being able to lock/hide things. We need this on all of the main players.

- If there is a difference between po line items and subs, we could show the problems... all at once. Similar to the bank balance helper report.

- Read them and weep numbers - too bold

- Our basic user's comprehension is not very deep.

- There is a need for oversight, maintenance, etc.

- Helping all our users to know what the problems are. It seems like it is coming down to known issues and disconnects.

- The cost field is so important... we allow that to be changed. Kelly was saying, the cost runs downhill.

- We talked about the balance sheet homepage and that it should run a number of checks before it does it stuff, and/or we need to let people know that there is a possible problem (or problems).

- Talking about some other check fields (aggregated values) that could be held on the main to show problems, disconnects, or whatever.

- On E/R's and deposits, we allow posting and locking. Most of our PO's and invoices can lock lines, but never get to the posted level.

- We rely so much on PO's. We don't have a ton of control over them.

- People are looking for the easy button - things keep evolving and users are expecting the system to help them along that journey.

- More guardrails

- Huge need for aggregates, counts, sums, averages, maxes, mins, and other values. This is a huge need. Bigger than we can say... We are very good at getting all of the data (transactional level). We need the aggerate levels. We have so much data. We need to get it summed up and other aggerate levels.

- Controls - at all levels

- We have seen users create more issues trying to correct other issues... Tons of cause-and-effect relationships.

- Inventory that goes into the negative. Ideally, this shouldn't happen. If it does, we need to show it.

- Visibility - start here - helping our users see what is going on.

- Parent/child issues - looking for disconnects.

/////////////////////////

Switching over to sub attributes

- Kelly has a client that has sub inventory and existing categories and wants to re-categorize the inventory. Category to category moves, in sub inventory. This totally creates a disconnect.

- People want to consolidate their categories or break things into smaller categories. We didn't know that people would be flipping the categories. That's a higher level of flipping but it has cause and effect drop-down effect.

- Currently, all sub attributes are tracked on (or off of) the column number (not the sort order or name, literally just the column number), not the id number. This can make things go off the rails.

- Is there a quick solution? Personally, I think this is going to take some time.

- One of the biggest problems is - we can't get the reporting out that we are needed. Because of this, they start altering things to solve their need. That can cascade potential problems. They want quick reports, quick exports, etc.

- We need to be able to cross over categories.

- We think that we need a master list for sub templates. In Kelly's words, maybe build above it. Along with that, we may need to build on both sides, build above it (master list) or build below it (custom cross category mapping).

- Build and break - build and break - part of the cycle

- Steve was talking... what about the next version of sub inventory. What would this look like?

- What about bulk tools?

- Kelly's goal was to show the different sides of what we are learning.

- Software has to evolve! What is the next step?

- From Steve - It keeps feeling like our users are wanting the software to go to the AI (artificial intelligence) level.