Invoices Due with the ability to see filter parameters based on subscription variables.
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
Notifies each weekday morning of all the sales invoices coming due based on your filters set in available variables. Can filter to only report on Blanket PO field or ALL POs. The intent is to be able to track invoices from the time of creation, whether for a manual credit card process, sales rep follow-up if unpaid, or any other 'extra-special' need.
Run Schedule: Weekdays AM
Type of Output: Email
* * *
Sample
Sample
* * *
Variables
Variables
Variable W: Blanket POs to check for (separated by a comma) or leave blank to trigger on ALL sales invoices.
Variable X: Enter Qty of Days start to Notify relative to Invoice Due Date (-5 for five days before, 5 for five days after)
Variable Y: Amount due > $ (whole numbers only, no decimals please)
Variable Z: Branch Numbers to trigger on, separated by comma, or leave blank for ALL.
* * *
Alert Functionality
Alert Functionality
1. Email is sorted by Branch Number, then by Amount Due.
2. You can list blanket POs to limit the invoices that the alert triggers on. If you limit the alert using variable W, the alert checks for the PO on the invoice:
To automatically populate a PO number on all of a customer's invoices, set the number in the blanket PO field on the customer record:
3. The alert is looking for invoices where the due date is Variable X days away from the date the alert is running. Note that it will also include invoices due prior to Variable X days to keep you informed of aging invoices.
A negative number in this variable will report the invoice at least that many days BEFORE the due date, a positive number will report when the invoice is that many or more days PAST the due date.
4. To only report on invoices with a specified amount due, enter that whole number in variable Y.
Note that Variable Y and Variable X have an "AND" relationship. In other words, for the invoice to be included in your alert, it must meet the criteria of both variables.
* * *
Best Practices & Tips
Best Practices & Tips
None at this time
* * *
Related Alerts
Related Alerts
ID273 - Alert all Contract invoices past due > W Days
ID407 - Outstanding Invoice/Credit Past Due X Days
0 Comments