Set the selection criteria to include a clause filtering your date field for < (currentdate - 7)

So is this the way the formula should look?

{SO_SalesOrderPayment.AuthorizationDate} > currentdate - 7

So is this the way the formula should look?

{SO_SalesOrderPayment.AuthorizationDate} > currentdate - 7

Close. If you want the expired authorizations, you'd want < (less than) not > (greater than).

Thanks. Yeah, I actually figured that out on my own right after sending the question. Sorry abou that. Thanks so much for your help!

Well, I thought I had it under control...but, I am missing a key element here. I need the report to show not only if the authorization date is older than 7 days...but also if that credit card transaction has expired. Is there an easy way to accomplish this? Thanks so much!

T. Helm

I had found the following from previous posts:
"use table: SO_SalesOrderPayment that holds data of expiring Credit card authorizations." There was discussion on the board previously that this may not include OPEN sales orders without the need to perform a calculation based on the PREAUTH DATE
another table recommended was: "AR_PaymentType" which is said to contain the authorization period." This should correspond to AR_SETUP_PaymentTypeMaintenance "

I must add, that I had not had the chance to check these out personally, but I have the same need to determine when pre-auths expire before we invoice as well.

I hope this helps.

Actually, the SO Open Sales Order report that another user mentioned previously in the post will work well, I believe. You choose to see those orders only with expired CC auths. This could be generated/printed to verify prior to invoicing your orders. Thanks for your input - 'tis much appreciated!