← Portal
Embedded stock report · 04/27/2026 11:13 AM · GPO pricing can load separately
— items
↻ Update with new Item Stock Status report
▼ expand
Drop the P21 Item Stock Status Excel file here
or click to browse · .xlsx / .xls accepted · this is the main stock file
Hosted test version also tries to load stock-data.xlsx, gpo-pricing.xlsx, and uom-conversions.xlsx from the same protected folder. GPO parser reads Sales Rep Pricing Guide column A/D/F.
▶ Paste tab-separated report data instead
Matching Items
current filters/search
In-stock Matches
available qty above zero
Low / No Stock
10 or fewer available
GPO-priced Items
within current matches
Avg GPO Savings
avg savings on GPO items
Rep view: Available Qty uses NET QTY ON HAND. GPO columns are grouped next to regular Cost; item cells turn light green only when that product has GPO pricing. Use the GPO filter to show GPO-only products. Available Qty now shows a UOM breakdown where conversion data exists. Verify UOM before quoting.
Item lookup
Search anything from the stock report. Exact item matches open immediately; close matches are clickable.
Search item ID, description, supplier part #, manufacturer, supplier, product group, McKesson code, cost, or GPO pricing.
Customer sales history
Hosted version tries to load customer-sales-history.xlsx from the stock-search folder. Select a customer to see prior purchased products grouped by product type/category for quick reordering. Items added from history use the last price when available.
Item ID Product / Prior Purchase Summary Total Qty Last Ordered Last Price Add
Select a customer to view sales history.
Top suppliers by available units
Top product groups by available units
Suppliers with most SKUs
Product groups with out-of-stock SKUs