Database view to get remit address on an invoice

Client needs to retrieve invoice and the corresponding remit address to build a custom report

• SSRS reports

• Crystal reports

• SaaS, Tyler-hosted clients

• OnPrem, Self-hosted clients

• Invoices

• Vendor remit address

Invoice remit address is different from vendor's primary address.

In ap_invoice view, the column a_vendor_remit_no shows the address sequence number.

• If this column contains 0, then the remit address is the primary address in ap_vendor.

• If this column contains a number greater than 0, then remit address is the address in ap_vendor where the a_vendor_remit_seq is equal to a_vendor_remit_no from ap_invoice.