Our customer wants to see the GL Account(s) and the respective dollar(s) for the invoices that appear on the Payment History Report and also to have the report sort by GL account. I haven't had great success using the AP_TransactionPaymentHistory and AP_InvoiceHistoryDetail files in Crystal Reports. If anyone has accomplished this, please let me know the secret to the solution.
Thanks...
8-19-2021
I have discovered that this type of report might or might not work! It won't be accurate if either of the following conditions exist:
- If the customer uses the Sage 100 AP Credit Card transfer feature, there isn't a link from the payment to the CC vendor and to the original vendor's invoice. This payment will not appear on the report.
- If there is a partial payment of an invoice, the posting to the GL will appear, but it will not equal the payment to the vendor.
There might be other scenarios causing the report to be inaccurate too, but if neither of the above conditions exist, it might work.