/
Derived payment amount field from Invoice Entry

Derived payment amount field from Invoice Entry

Description of Issue

User would like to report on the payment amount field shown in the Invoice Entry

Context
  • All versions of Enterprise ERP

  • SSRS reports

  • SaaS, Tyler-hosted clients

  • OnPrem, Self-hosted clients

  • Invoice Entry

Cause

Payment Amount is derived

Resolution

Payment amount is a calculation of apih_inv_net - apih_hold_amt from the apinvoih view

Additional Information

 

Related content

Database view to get remit address on an invoice
Database view to get remit address on an invoice
More like this
Database view for total due amount in Account Customer Inquiry
Database view for total due amount in Account Customer Inquiry
More like this
YTD Budget Report - How to show invoice number in journal detail export for AP journals
YTD Budget Report - How to show invoice number in journal detail export for AP journals
More like this
GB Invoice Detail report doesn't allow free entry of non-numeric fields
GB Invoice Detail report doesn't allow free entry of non-numeric fields
More like this
Database view containing pay code for an payroll accrual record
Database view containing pay code for an payroll accrual record
More like this
Database view containing P-Card Invoice vendor name
Database view containing P-Card Invoice vendor name
More like this