Prepaid Invoice Report Logic

Prepaid Invoice Report Logic

The Prepaid Invoice report (in the Dashboard Reports -  Invoicing folder) is limited to invoices where the payment Effective Date is less than the Due Date, the payment has been posted and not returned, and the invoice detail record OpenClosedOid is marked with either the value for Cash Payment (11021) or Cash Reapplication (11025). 

If the invoice has a current due amount, the invoice detail record OpenClosedOid is set to Open (11020) due to it not being paid in full.  The intent is to show payments paid full where the payment Effective Date is less that the Due Date.

 

Once the invoice is paid in full the portion that was paid prior to the Due Date will then appear on the prepaid invoice report.


As an example, Invoice 15295 prepayment of $18,717.48 will not appear on the Prepaid report until this invoice is paid in full. 

The amounts of $931.85 and $1,883.90 will appear on the report for invoice 15003 as the entire invoice is paid.




    • Related Articles

    • Standard Contract Earnings Report - Calculations and Logic

      See attachment for details. The attached document details the Contract Earnings logic used on the Contract Earnings report in the Dashboard Reports Earnings folder. The document defines the Contract Earnings logic for a Capital (Direct Finance) ...

    • Standard Book Value Report - Calculations and Logic

      See attachment for details. The attached document details the Book Value logic used on the Book Value report in the Dashboard Reports General Ledger folder. The document defines the Book Value logic for a Capital (Direct Finance) Lease, Operating ...

    • Comments Not Displaying on Aged Invoice by Contract report

      The "Latest Comment" field on the Aged Invoice by Contact was not displaying any information. To populate that field on the Aged Invoice by Contract report, do the following: 1. Go to the Administration menu - Codes and Types - Comment Type 2. At the ...

    • Tagging Invoice Messages into Invoice Doc Templates

      Please refer to attachments (Follow "Invoice Consolidated notes" document for instructions) In the event that you would like to have your Invoice Documents include a comment specific to the Contract at hand in the Invoice Documents, there are a few ...

    • Locating the Printable Invoice Batches in the Global Repository

      Please refer to the attachment for more detailed information. This document is aimed toward retrieving the printable documents from Scheduled Billing Invoices batches. The Global Repository is standard functionality, and is the location you will go ...