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 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 ...

• Invoice Reports Video

  See linked video for complete information. The linked video provides a brief overview of invoice related reports with an emphasis on delinquency and customer service. Click here for the 10 minute video.

• Transaction Code Post Date Logic

  When transaction codes are configured an Accounting Method is selected that will determine if general ledger entries are created at the time of invoicing and what post date is used when the entries are posted. Cash Basis - No G/L entries are created ...

• Scheduled Billing - Invoice Regeneration & Redistribution

  See the attached document for details The attached document steps through the process of regenerating invoices on the Tasks > Scheduled Billing screen.