Hello Kay:

I think it will make things clearer to separate the 2 processes you are looking for.

1) Creating the file to send to the CC processor:
GridView could be used to extract the information. An Excel macro could be used to manipulate the data and to create a file in the format expected by the CC processor. However it seems as if you have a Crystal report that is taking care of this for you so I won't go into it any further.

2) Importing CC "Paid" information back into Adagio Invoices:
I don't see how to truly import the "Paid" information. However it would be possible to do the following:
i) Export the batch (likely required for 1st process anyway)
ii) Modify a Comment field in the Excel file to indicate Authorization number
iii) Import the Batch (and delete the original batch)
iv) Print the Invoices displaying the "Paid by Credit Card" field
v) Create a cash batch that can be imported into AR (macro would help here)

Admittedly this isn't as good recording a true recept into the Invoice. If it's not aceptable, you would have to watch for changes to the Adagio Invoices Import process.

You don't need the Import process to "add" Payment information to an existing batch. Currently the Import process does not have the flexibility to import any Payment information at all. But when those fields are added to the process, you can load that information into the Excel file and import the entire batch, then delete the original batch.