We are looking for a better way to reconcile credit card payments. With our security context, we do not have access to SSRS.
The report "Payment Details for Refunds" is an excellent start because it has the "payment_no" field that appears on our merchant account statement. However, the report does not contain the "transaction_no" in order to relate the payment to a specific transaction. Constituents often have multiple transaction in a given month.
The "Transactions by Posting" report is our source for G/L postings, and we need to tie this to credit card deposits. The report provides the transaction number, and does not have the "payment_no".
Without using SSRS or a custom report, has the community found a way to relate the transaction number to the payment number?
Thanks!