Say Y to the first prompt, use printed ship date as Invoice date.
 
John

Problem with that choice is that invoice dates are all over the place. This is (for us) a problem when the shipdate overlaps into the previous month at the beginning of a month. we like to have a clear cut 'month end" figure on our reports.
 
As for the UPS link;
I have been following the various postings with great interest. My solution is a batch end of day export to a csv file. After UPS picks up, that csv file gets imported and modified by a series of access queries:
1.) I eliminate duplicate references and end up with 1 tracking number in a table for each shipment (UPS allows tracking of multiple packages through one tracking number)
2.) I modify (through a queriy) the date to a format that is accepted by DBA (UPS includes minutes and seconds etc in the date)
I finally do an update query to write the info to the BKARINV database.  
(there is a little bit more to it - too much to fit it all in here)
The whole update is automated by using the scheduler from within windows at 9pm (that is why I need the ship date to stay as submitted by UPS - Invoicing takes place the following day with the invoice date of that day)
Anybody interested, write me an email at helmut@generalpencil.com
I am more than willing to share the Access mdb file