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

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

The Open Sales Order Report has an option to "Only Print Unauthorized or Expired Credit Card Orders".

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!