Has anyone ever created a report where a field shows up based on the payment ""number"" from the customer? I have a report where we need to calculate the sum of freight and tax but only if it is the first payment from the customer for each individual invoice.
We are using the AR_CashReceiptsHistory table and linking to AR_InvoiceHistoryHeader to get the freight and tax. Occasionally there are credits done to the invoice prior to a payment as well, so I will need to add the AR_TransactionPaymentHistory table in as well for the transaction type (P). Any thoughts on how to determine what the first actual payment is?