By using this website, you agree to our Terms of Use (click here)
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!
Just posting again to see if anyone might be able to point me in the correct direction on this simple GI that i can't get to work.
nevermind, I had our new VAR prepare this for me. Thanks!
Hey Dan,
Just curious if it involved a join between ARInvoice and ARPayment, then a group on the Invoice number and a display of the Max on the Payment Date.