Hi...

I have an existing cash receipt remittance that is in Excel.  This remittance gets imported into Sage Cash Receipts.  We are finding that some of the invoices are being updated to incorrect customers from the spreadsheet.  What would work best if we could use the invoice number to import to the correct customer.  You can't import without a customer number, so I tried to create an odbc connection in Excel to maybe link the spreadsheet invoice number to the invoice number in the open invoice file to find the customer to import to, but I can't seem to figure out how to link an existing cell to a field in a Sage table.

So for instance, I have invoice 100054 for $407.40 and 0000141 for $1178.69 on my spreadsheet.  Those two invoices are for customer ABF.  How can I link the existing invoice numbers to our Sage table to find that the customer was ABF?

Thanks for any way to do this...

B