How to Find Orders That Have Been Pre-Authorized for Credit Card Charge

Release Date: 8/7/2018

Q - I am in the process of implementing Elliott online credit card charge processing with pre-authorization through the COP Order Payment window. I need to develop a separate process to identify orders that have been pre-authorized for credit card charges.  Could you suggest what would be the quick and easy way to identify a pre-authorized order?

A -For the order that has been preauthorized, you should be able to see the order_comment1 with text like:

                PreA *3546   $194.19 TX#179235969

See sample screen below:



So you could use the following SQL statement to find the pre-authorized orders:

    select order_no, order_comment1 from cpordhdr where order_comment1 like 'PreA%';



EMK

Feedback and Knowledge Base