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 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 ...
    • 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.
    • Credit Report/Update Legal Name from Business Credit Report

      Overview of testing results: The intent of this feature is to retrieve the Legal Name from the credit report and update the legal name field in ASPIRE when pulling a DNB report from either MicroBilt or Liquid Credit.  It intended to update the Legal ...