Inventory Low Stock Notifications (cont.)
Included with Notification Email: Two Files: Low Inventory (csv) and All Inventory (Excel)
Fields on the Low Inventory csv file:
Product ID, Product Description, Product Location, On Hand Quantity, Standard Package/Reorder Quantity, On Reorder Quantity, UoM, Item Cost, Min Inventory Level , Max Inventory Level, Product Category, Active/Inactive, Customer PO (for reorder uploads), Vendor SO (for reorder uploads), Suggested Reorder Quantity, Confirmed Reorder
Quantity (for reorder uploads)
Fields on All Inventory xlsx file
Product ID, Product Description, Product Location, Customer Part Number, Product Category, On Hand Quantity, Standard Package/ Reorder Quantity, On Reorder Quantity, UoM, Item Cost, Min Inventory Level , Max Inventory Level, Inventory Value, Reorder Needed, Refill to
Max