Flow Chart of Payment/Invoice Tables in SQL Database

Flow Chart of Payment/Invoice Tables in SQL Database

Courtesy of Dan Dawson, attached is a useful flow chart when understanding how SQL manages payment/invoice data in the database.
    • Related Articles

    • 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 ...
    • Cash Management – Payment Batch Posting

      See attached document for complete details. The Cash Management screen allows payments to be applied to open customer invoices. Invoices can be found by searching based primarily on Customer, Contract, Amount or Invoice. Attached Document Table of ...
    • Scheduled Billing - Invoice Generation and Regeneration

      See the attached document for complete information. The attached document will provide an overview of the steps a user, with no security restrictions, will take in order to generate scheduled invoices (billings) within ASPIRE. The concept of a ...
    • 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 ...
    • 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.