Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Blue
Assigned To: Bryan Dayton
Created By: Bryan Dayton
Created Date/Time: 11/29/2016 3:26 pm
 
Action Status: Completed
Show On The Web: Yes - (public)
Priority: 0
 
Time Id: 2025
Template/Type: Brandon Time
Title/Caption: inventory
Start Date/Time: 11/29/2016 3:45 pm
End Date/Time: 11/29/2016 5:00 pm
Main Status: Active

Sorry, no photos available for this element of time.


Notes:
On a GoToMeeting session with Bryan. We were looking into ways to pull quick inventory quantity reports. We built some simple queries and then did some testing. Bryan needed queries that pulled full inventory counts and other queries that only pulled usage or sold items for a specific time period. The goal will be to show current inventory levels and then forcast and/or trend what the burn rate is on those items. This will help us produce the estimated "run out" date for the different items.

I find it interesting that our clients are beginning to push more and more on getting accurate live data, and then pushing things forward to help with just-in-time buying, selling, and inventory management functions. Reorder dates, thresholds, burn rates, life cycles, aging, etc. Good data is king.