Is there an interface within Adagio (AI or AR) or any 3rd party developer for online services such as "Authorize.Net" for processing CC payments? Preferably this kind of a facility has the capability for a batch or file submission as well as interactive.

This process is currently available within QuickBooks so this technology is not a new concept.

CounterSales for Adagio (point of sale) is setup to integrated credit card payments. Virtual Vendor (online B2B web store) also has this functionality.

Hi Kay,

There are also 3.5 Million QuickBooks users, so banks and credit card companies are anxious to provide integration (in fact, I believe that Intuit set themselves up as a bank to do their own credit card clearing).

As Doug mentioned, there are some external developers who have integrated this funcionality into their products. What types of payments are you trying to process?

Thanks for the response, but I could not find "CounterSales for Adagio".

I looked at Virtual Vendor and that is more than I want.

I have a file of Customer Credit cards, I want to submit those preferably in a batch enironment with current amounts, get the authorizations back and import into a QI batch matching invoices.

Sorry, I only refered to QuickBooks as a concept - I am not comparing or planning to convert to QB.

I looked at Doug's suggestion and was unsuccessful in tracking one of his suggesstions.

I provided a more detailed synopsis to his reply. Simply put, we have 30-300 credit cards on file most of which will be processed at least once per month through Quick Invoice. We would like to automatically submit the CC's with Invoice numbers (for documentation) and get back the "Approval Code" which would be posted to the invoice to show a "Paid Invoice".

Sorry, this discription nay be a little confusing but the process is very procedural.

Hi Kay,

Does your current credit card processor offer an electronic method to submit credit cards for authorization? If so, can you get the file layouts required from them? You might find that you can create the necessary upload file using GridView or another reporting tool.

We have implemented Pre-authorized Debit (PAD) processing for a few clients using Adagio Invoices who wished to directly debit their customer's bank accounts for payment (rent). I would expect that credit card processing would be similar, and we would be willing to look at this as a custom project for you.

Kay:

CounterSales for Adagio is developed by Island Micro Systems http://www.islandmicro.com

As a Point of Sales solution is processes credit card payments on an individual sales basis.

Andrew's suggestion of having Softrak modify PAD to meet your needs may be a more appropriate suggestion.

Bingo - this is exactly the issue.

Adagio already has the capability to store CC's. I am sure we could generate an upload file either with Gridview or Crystal. I currently generate an invoice information file which includes - customer numbers, invoice amounts, etc. which we used to, past tense, upload into an older system that just went away. Our current processor will accept a batch file and return a printed report or file which we can convert to Excel, etc...... This all is a piece of cake.

The only issue is, to the best of my knowledge, that there is no import in Quick invoices for the completed payment which would include some or all of the following - customer number, invoice number, amount, and authorization code.

Thanks for being patient with me. I think this is very similar to handling Debit cards.

You can import a cash batch into AR which, if it includes the invoice number will automatically match with the invoice when posted.

I have researched the application of CC's in AR Cash batches. That is not player for our invoice/payment process.

What I need is to apply the CC payment to the invoice in AI so that we can email an original invoice showing "PAID" as if it were a "Counter Sale" where CC is presented as payment. When you said you did something for Debit cards I was hopefull because I believe the process is similar.

Currently we hand enter CC payment information to the Invoice within a batch one invoice at a time. Works fine, just a little slow. I am hoping that someday there will be import that matches payment information to payment information in AI.

Is your PAD processing a standard feature of AI or an add-on? Why do you think this is not appilcable to my process?

Thanks

Hi Kay,

Is the desired process to include a credit card number and payment to existing invoices in a batch, prior to printing and posting? Essentially an 'import' method of updating existing batches with new information? So that the invoices are all entered/generated without payments and then later on the CC payments can be added en masse where applicable?

Certainly the standard way of importing transactions does not allow updating existing batches but only creating new batches. It would take some sort of customized process to match up payments to existing invoices after the fact, either to a batch or to the Historical invoice (after posting).

I don't know enough about the PAD processing (which is not standard) to comment, so I will leave that to others.

PAD processing was written on a custom basis for a client. I believe the process for credit cards would be simlar, but your budget should be between $5,000 to $10,000 depending on the file a processing complexity of your credit card processor.

You can record the cc in an archive batch and I believe the information is preserved when the batch is restored. Perhaps GridView or Crystal pointed at the batch can produce the file your cc clearing company requires.

Thanks for the consideration. After developing an explanation all I need is a standard import for AI. As AI matures we may get that facility.

Thank you. Closing this issue for now.

Just before you close the issue...

What would you be importing and how would the information be matched if not by invoice number?

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,

You can do this now as long as you can get the invoice amount and customer in the Excel sheet.

One way of doing that would be to use GridView to export the current transactions (or a SmartFinder view into the documents if you're running AR 9.0A) and export the invoice number, customer number and current amount to Excel. Then use the Excel =VLOOKUP() function to locate the row for the invoice number and retrieve the customer and amount to place in the Excel sheet you want to import as a cash batch.

I agree it's a bunch of steps, but it's free and available now. Why not come to the AOC and find out how?

Unless I am totally misunderstanding what you are outlining, the process you are proposing is in AR. Our process has to be done in AI before the invoices are emailed.

We have a mixture of paid and unpaid invoices in an archived/active batch that we are preparing to send to customers. It is the intermediate step of the process that we are trying to solve where we match offline CC payments and insert the payment information (1 field - up to 12 characters of text) into the matching invoice - that's it - period.

I don't know Gridview but have a gut feel that it can do the process.

Thanks

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.