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

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