Simple Payment Date GI
I need a simple GI that gives me Invoice #, Method of Payment, and Last Payment Date. I've tried a bunch of iterations, and either don't get the correct information (often) or not all the payments (missing a ton). I've tried LastPaymentDate from AR.ARInvoice, and get nothing. I've tried linking to ARPaymentInfo and also ARPayment, but still can't get the correct data. Maybe I'm using the wrong file or a bad join?
I can't believe this is as hard as I've made it!