After entering the long tracking number, can that number be printed on any document?
 
Also, where is the number stored in the database?
 
We have developed a simple Access database query that inserts tracking, freightcost and shipping dates by accessing the UPS database and updating DBA. The problem is the lenght of the tracking number. right now we are appending it to the ship via field, but truncated.

Lynn,
How is this first line of the order comments flagged by the system to be cleared after invoicing??   Is it just the fact that it starts with the word TRACKING??
 
I would like to see a feature were we could flag any order header line to be a 'next invoice only' comment.  
This would be useful for using any comment line for 'per invoice' info like Credit Card Auth Numbers, warrenty info, special instructions, etc.
 
Maybe a single prefix on the line, like -, >, or whatever.
 

If we confined that special character to the first column only, it would further reduce an potential conflict.
 
Maybe the  |   ( shifted \ ) would be a good choice.
 
An * or - may be poor choices.