I am not sure if this is the right forum and apologize if it is not. Here is my issue. My company uses a manufacturer that is out of state and can get us data 2 different ways, through opening up a web service to us or sending a spreadsheet. These would contain packing lists of products they are drop shipping to customers. What I would like to be able to do is somehow compare this data with Open orders in Sage 100 to make sure we are invoicing and closing out those orders correctly. I would appreciate suggestions on how I might approach this.