Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Credit Card Authorization Expired - TABLE?

Posted By helmt01 over 8 years ago

Can someone please tell me which table and corresponding field I would use in a Crystal Report to show which credit card authorizations have expired? I looked at the SO_SalesOrderPayment table, but none of these fields correspond to what I looking for. I need this information for OPEN sales orders. Thanks in advance for any input you can provide.

T. Helm

0 TomTarget over 8 years ago

I think you have to calculate the date. The So_SalesOrderPayment table shows the date of authorization. The setup for the payment type has a value for the number of days before an authorization expires (for example 7 days).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 helmt01 over 8 years ago in reply to TomTarget

Thanks so much for your help. Still haven't figured out the calculation option, but at least we can now add that field to our report and see when the card was authorized. Thanks for your input!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TomTarget over 8 years ago in reply to helmt01

The table AR_PaymentType has the authorization period. This should correspond to AR | Setup | Payment Type Maintenance.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Credit Card Authorization Expired - TABLE?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING