I've searched through various posts and cannot seem to find an answer to a simple, specific question. Hopefully, someone can provide some input.
I have created a very simple Crystal report, using the SO_SalesOrderPayment table. I want the report to tell me which open sales orders have credit card authorizations that have expired. However, I cannot figure out how to have the report show me only those records (orders) that have an "AuthorizationDate" GREATER than 7 days (our system-set PreAuth term). Thoughts? Thanks!
T. Helm