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 ...
Using Invoice Groups
See attached document for complete and additional details. ASPIRE offers multiple ways to group invoices for the same customer. This is intended to simplify invoice processing for a customer that has multiple contracts with the finance company. The ...
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 ...