We would want to match on Invoice number and provide a check number in text format because our format is "CC xxxxxx" which shows a CC company abreviation and authorization code (alpha-numeric). This information is provided in Excel format (2-fields only).
No verification on amount would be required because we provide the amount to the batch transaction process with the CC processor. We run a Crystal report to generate a batch transaction file for the CC processor.
Sorry, I think I answered the question in reverse order. CC processing is an external process to Adagio because we may use more than 1 servicing agent that is why an import works the best for us.
Thanks,
_________________________
Kay N. Paboojian, Jr.