The application would offer the functionality to log and edit data with details as below
Part# QTY Cust Date
K071665 6 Ken Mex 1/9/2012 AP
Searchable/Filterable List View of the logged entries
Reports based on the filter criteria provided.
Add/Edit/View functionality for Customers and Categories
Pivot information view and report based on it.