Report Showing AR Invoices Associated with Payment Applications

SOLVED

I am trying to generate a report that lists not only the AR Invoices for a project but the number of the payment application (if applicable) that invoice is for. Example: Job # 9999, Invoice # 20001, Payment Application #1. I can not determine which fields join the 2 tables, aiafrm and acrinv . Can anyone offer guidance on this? 

Parents Reply Children
  • 0 in reply to Yvonne Bianco

    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.