Need:
1) Item # (internal), 2) Item Description, 3) Ship-To Location (internal company name of plant/company/location/warehouse), 4) Vendor Name, 5) Date (typically received date, last 12 months of orders at a minimum), 6) Quantity Purchased, 7) Quantity Unit of Measure, 8) Currency, 9) Extended Cost (Total Paid = Price x Qty)
Want:
10) Internal Category, 11) Pricing/Freight Terms (FOB / DLVD), 12) PO #, 13) Manufacturer (if different from vendor), 14) Ship-To City, 15) Ship-To State