Try the Aging Detial by Contract in AR and range it to your customer.  It gives a detial of not only the invoice number but the description you gave that invoice. Example (Pay App #1)

Thanks for the suggestion.

This would work if I was starting with the invoice # and just looking for the payment application #. What I am trying to do is correlate payment applications with invoices. Starting with a payment application and then adding the invoice #.

I have had some of our clients request the invoice # to be included on the payment application. Which at this point I have to manually add after printing. I am attempting to automate the payment application process with a SELECT FROM WHERE statement, or similar statement, to return the Invoice # of the AR Invoice so it can be added to the application before printing. From there I would be able to create a custom Job Statement similar to 3-4-21 showing the payment application number, the invoice number and other invoice information in tabular form. This is my ultimate goal.

Any guidance would be greatly appreciated.

AIAFrm.LgrRec = AcrInv.LgrRec.  The progress billing must be Posted before you can grab the AR Invoice Number.  I will often create an If Then calculation that shows the posted invoice number if the Progress Billing has been posted and a "TBD" if the PB has not yet been posted.

This is exactly what I was looking for. 

Thank you!!! 

Hey shelasgoodfello, if this worked for you, please do mark it as verified thank you!

Worked like a charm.

Thanks again Walt!