Automated Item Requistion in Excel
Budget: $750 – $1,500 USD
I am needing an item requisition spreadsheet that contains a database of items(to be added later) with item number, item name, item description, manufactures and ordering location(s)
an inventory sheet that allows a calculation of number of each item to order based on current on hand count and order point data.
Using the inventory calculation populate the item requisition with the item number, item description, and order quantity.
The item requisition ought to collect the ordering location, the requisition number, date and status (open, backordered, closed) and save this in a separate database for retrieval later if needed.
an inventory sheet that allows a calculation of number of each item to order based on current on hand count and order point data.
Using the inventory calculation populate the item requisition with the item number, item description, and order quantity.
The item requisition ought to collect the ordering location, the requisition number, date and status (open, backordered, closed) and save this in a separate database for retrieval later if needed.