Follow

ID407 - Outstanding Invoice/Credit Past Due X Days Overview & Sample

A weekly alert showing outstanding invoices and negative balances due.

Overview | Samples | Variables | Alert Functionality | Best Practices & Tips |  Related Alerts

Click to Subscribe 

Overview:

To identify all open AR transactions older than the number of days specified where the amount due is greater than amount specified. Will optionally include unapplied credit memos as well. 

Run Schedule: Weekly Friday AM

Type of Output: Email

 

*  *  *

Sample

ID407Sample.PNG

 

 

*  *  *

Variables

ID407Variables.PNG

Variable W: Enter Number of Days Past Due for alert to consider, (Required)

Variable X: Enter Amount Due > $00.00, and applies to credit memo/negative minimum amounts due (please include decimals), (Required)

Variable Y: Enter 'Trans' to pull Sales Rep data from the specific invoice triggering OR enter 'Cust' to pull Sales Rep from Customer Record. This determines which Sales Rep to use when sending alert to Sales Rep and/or Sales Rep Manager. (Required)

ID407ToSales.PNG

Variable 1: Enter 'Exclude' to exclude credit memos; otherwise leave blank or 'Include' to include them (Required). Defaults to 'Include' if left blank

Variable 2: Enter string to filter Invoice Number "contains" or leave blank to include all Invoice numbers (Example: enter CW to report on any invoice with CW anywhere in the Invoice #)

Variable Z: Branch Numbers for alert to trigger on (leave blank for ALL)

 

*  *  *

Alert Functionality

-Alert only considers invoices, credit memos, it does NOT report on unapplied payments.

-If you've select to have Credit Memos included via Variable1, alert will actually consider any invoice where Due Amount is negative, not just Credit Memos. The minimum $00.00 you've listed in VariableX applies to Credit Memos/Amount Due the same. So if you have $100.00 for minimum dollar amount to consider, then alert will only include minimum amount due of -$100.00 or less and $100.00 or more.

ID407AR_Console.PNG

-Alert sorts by Bill To Customer Name, then Customer Name, then Invoice Number

-Any email address(es) listed in To/CC/BCC of subscription will be included when email also sending to Sales Rep / Sales Manager:

ID407Send_To.PNG

ID407ToSales.PNG

-Alert can be cloned, so you can have multiple subscriptions running at the same time enabling you to have different recipients receive the alert based on different variable settings. This will ONLY work if you have at least on variable set differently for each subscription. To create a clone, just select the plus + sign below your existing subscription:

ID407Clone.PNG

 

*  *  *

 

Best Practices & Tips

None needed at this time

  

*  *  *

Related Alerts

ID273 - Alert all Contract invoices past due > W Days

ID477 - Tracking Invoices Coming Due

 

*  *  * 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk