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