AnsweredAssumed Answered

Finding Previous Invoice ID on starter solution

Question asked by JasonPenner on Aug 15, 2012
Latest reply on Sep 12, 2012 by philmodjunk

Title

Finding Previous Invoice ID on starter solution

Post

I've modified the invoice starter solution but I'd like to have a field in the Customer table that calculates their last invoiceID. So say Customer 3 has two invoices, #32 and #2 when I add a new invoice the "Previous Field" is calculated to be #32. I was playing with GetNthRecord but I can't filter it per customer. I'm trying to do this so I can have a portal on the invoice page that lists the previous purchase, using the filter on the portal.

 

Thanks

Jason

Outcomes