Hi Samantha,

This might be much easier to generate/debug using GridView (which you have).

The IC transaction history file will not have a Vendor Code for Shipment transactions (sales). It will have a Customer code. Receipts have Vendor codes associated with them. You will have to link the shipment transactions to the inventory item master to look up the vendor for the item. All sales of an item will be associated with a single vendor (the one on the item file currently), regardless of who the vendor was when the item was sold.

I've added a GridView workspace that would be a start to getting the information you need.



Attachments
ICVendorSales.zip (101 downloads)



Edited by Andrew Bates (01/19/16 03:21 PM)
Edit Reason: Added Workspace
_________________________
Andrew Bates