I've attached an image of a report we have. I'll list the upgrades below and let me know if you have any questions. This report helps us know which items we need to order in time so we do not go out of stock.
1 - The Nu Inventory column needs to calculate all the inventory tied the product. We have a table in our db which holds inventory for each lot in a product. One product may have multiple lot's tied to it so this just needs to add all lot's tied to that product.
2 - The Tied To section needs to tell us how many products that item is tied to & if we click on that # it needs to have a pop up with a list of which products they are tied to. For example Let's Say Alfalfa Powder is tied to 10 products it will show 10 under tied to & when clicked on it will show the names of which products they are tied to. On our product page we add ingredients to that product and the info is stored to product_herb and that is where you'll be pulling all of the info for this.
3 - The Status column needs to show us if we have a status on any of the items on our list. This will really help us so we don't order an item twice. All of the info below will come from 2 tables in our db which are called quote and po.
if We have created a quote for the item it will say Quote - Started
If the quote has been emailed it will say Quote - Emailed
If the quote has been updated it would say Quote - Updated
if We have created a po for the item it will say Purchased - Date
If the po has been updated it would say P.O. - Updated
If the po has been received it would not show anything
Please let me know if there is any questions.
If none of the items above apply then it wouldn be blank.