Sage 300

Sage 300 2014 - customer is using Sage Payment solutions for C Card Payments. They enter CC prepayments in order entry. We created a subreport on the invoice form to show prepayments on the invoice as some invoices have several prepayments and they want the customer to see the detail. Those prepayments are 'housed' in the OEPPRE table, however there is no indicator there to flag if the transaction is void, outstanding etc. The customer wants prepayments on invoices to appear on the invoice form, but only the non-void transactions. Most of the time just using the OEPPRE table works fine since 99% of the time there are no void cc payments. On a few occasions the credit card prepayment needed to be voided and that was done, but now I need to exclude those from the Prepayments subreport on the invoice form. Any ideas where that credit card prepayment rec status flag is stored??

@MarcCregan - good luck with this. That table OEPPRE is almost useless. They should take the payment and post it directly on the customer account (AROBP) so it can be linked with the resulting invoice easily in any crystal reports. I would at least look in the AROBP table for the payment. If the payment was voided from SPS they would need a way to clear out that record in that table.

Thanks Lloyd - i'll take a look there - I was on the bank tables mindset and didnt think about a/r. The AROBP may well be the key!