Follow

ID800 Email Past Due Invoice Overview & Sample

Automatically emails past due invoice(s) to your customer

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

Click to Subscribe 

Overview

Overview

Emails copy of any past-due invoice(s) (Sales, Misc, Contract, Proposal, Service) to your AR Contact on BillTo Customer Record. You can select if this alert only sends to specified customers OR to all (via VariableZ). Invoices email when days past due reached per your VariableW setting and again when days past due matches that in Variable2.  Note there is one email per invoice type. Ensure the from address is an email your customer can reply to, we will send you a daily report of emails sent/not sent. 

Emails listed in TO receive emails sent to customers, Emails listed on CC receive Daily Summary ONLY, Emails listed in BCC receive both actual emails and daily summary.  

 

Also consider ID213, a past due mini statement with no invoice attached. ID387 will ensure you are getting email contacts for your customer's AR Contact.

Run Schedule: Weekday Evenings

Type of Output: Email

 

*  *  *

Sample

Sample

Default verbiage:

ID800SampleStandard.PNG

 

Daily Summary:

**Customer Name and Number is Bill To Customer

ID800Summary.PNG

Sample Task Entry in AR Console:

ID800TaskSample.PNG

 

*  *  *

Variables

Variables

*Variables listed in RED are required; otherwise alert will not work**

ID800Variables.PNG

Variable W: Number of DAYS PAST DUE DATE on invoice at which to e-mail invoices.

Variable 2: Number of days AFTER VariableW to send escalation email. For example, when VariableW = 45 and Variable2 = 30, then escalation will be sent at 75 days past due. This escalated email can have alternate (possibly harsher) verbiage. Just let us know at help@ceojuice.com exactly what that verbiage should be. If this variable is left blank, then only one letter will be sent at days past due per VariableW.

Variable Z: Enter 'ALL' to send invoices to all Bill To Customers OR enter 'SELECTED' to send only to customers included via Custom Property. All mode will send to ALL customers to receive qualifying past due invoices and you can set exceptions via Custom Property. Selected mode requires you to set Custom Property on Customer Record for those customers to receive qualifying past due invoices. 

Variable X: Custom Property on Bill To to custom set customers days past due by overriding VariableW days set (1st escalation).

Variable Y: Type of invoices to send - options Sales, Misc, Contract, Proposal, Service 

Variable 1: Customer Type(s), if any to exclude from process (i.e. Lease)

ID800CustmerType.PNG

Variable 3: Minimum $XX value of invoices to send (whole numbers only, no decimals). If this variable is left blank, alert defaults to 10.

Variable 4: Contact Task Type used to write to AR Console indicating e-mails have been sent, leave blank for NO Task Type to be created. This is only available with version 2020625, email help@ceojuice.com to update your version. 

 

*  *  *

Alert Functionality

Alert Functionality

-The alert will NOT send any past due invoices if your customer has any unapplied payment on their account.

-Any partial payments applied to an invoice should reflect on total amount due left on outstanding invoice sent.

-If you have customized invoice formatting, then this alert process will NOT be able to pull in your customized invoice format. Rather it will default to eAuto's standard invoice format. 

-As of version 20200625, we can now write an Completed/Solved Task to your AR Console showing email sent. User will always show as CJID800 and task will always be marked completed:

ID800TaskSample.PNG

-Changes to VariableW or 2 will not effect any past due invoices already sent. Once a given escalation has sent (first, second, etc per VariablesW & 2), the alert will not send again for that escalation. 

-Alert Variables W and 2 consider days past due, from invoice due date (not days since invoice issued):

ID800DueDate.PNG

-Must have an A/R contact setup and that contact listed must have a valid email address.  See screen-shot below for where to set the A/R contact.  This is from within the customer's profile and you would want to select the contact from the drop down.

Use ID387 to remind you to add an AR contact if one is missing

ID800CR.PNG

-Alert does not consider the Invoice Method, if it finds an e-mail address to send to (from AR Contact), it will email. Alert will forward invoice for printing only when Contact is marked -decl- 

ID800IM.PNG

-If the alert tries to send a notification to a contact who does NOT have an email, it will be listed on the daily summary as Not Sent / No AR Contact.

-If an email address on AR Contact Record is invalid, any emails past that failure will not send. We HIGHLY RECOMMEND using ID305 to ensure Contact Records are set correctly. Bad email addresses will cause the alert process to fail.

-If you have a customer you'd like invoice printed, not emailed, then list -decl- or -3rd- in Contact Number field of their Contact Record. Alert will forward an email to the email listed as the 'FROM' on your alert subscription so that it can be delivered via another method.

ID800ContactRecord.PNG

 

 

Selected vs. All Mode

Selected vs. All Mode

SELECTED mode means you set which Customer will receive emails from this alert.

ALL mode means you set exceptions for those NOT to receive while the rest of your customers will receive emails from the alert. **Remember you can also set exclusions by Customer Type listed in Variable1.

**If you wish to change your mode AND you are no longer in Test Mode (emails actually now sending to your customers), please reach out to help@ceojuice.com before changing as this will GREATLY effect what your customers receive.**

 

Selected Mode:

ID800Selected.PNG

If VariableZ is set with SELECTED Mode, you set a given BILL TO Customer Record to receive FIRST email by setting the Custom Property ZCJPastDueInvoiceDays to a number other than zero or blank. Alert will only send for those customers you've set Custom Property for. **See below for details on Custom Property functions.**

 

ALL Mode:

ID800ALL.PNG

If VariableZ is set with ALL mode, then customers will be emailed invoice(s) based on Days Past Due set in Variables W and 2. VariableW determines when first email is sent and Variable2 determines when second email is sent. Use the Custom Property ZCJPastDueInvoiceDays set to 9,999 to exclude a customer from the alert emails.

**See below for details on Custom Property functions.**

 

ZCJPastDueInvoiceDays

ZCJPastDueInvoiceDays - Function of Custom Property

This Custom Property is intended to either (1) to set a customized days past due at customer level rather than using your standard days past due settings set in VariableW and Variable2 OR (2) prevent customer from receiving any/all emails from the alert.

(1) Using Custom Property to set different days past due level for individual customer:

**PLEASE NOTE, how this Custom Property depends on which version of the alert you are running (ask us at help@ceojuice.com if you're not sure).**

Version 20200625 or later:

Custom Property replaces value set in VariableW. 1st letter/email is sent when value in Custom Property is met, regardless of VariableW. 2nd escalation letter/email is sent when days past due = Custom Property Value + Variable2. 

For example IF:

VariableW = 10

Variable2 = 15

Custom Property = 30

THEN, first letter/email is sent at 30 days past due. Second letter/email is sent at 45 days past due (Variable2 + Custom Property).

Version 20160203 or earlier:

Alert will trigger when the Days Past Due is that listed on Custom Property. However, how that number of days past due relates to the total of VariableW and Variable2, determines which letter/email (first or second) is sent. 

VariableW is completely ignored and sends 2nd escalation letter at days past due per Custom Property value. 

For example IF:

VariableW = 10

Variable2 = 15

Custom Property = 30

THEN, first letter/email is NOT sent. Second letter/email is sent at 30 days (VariableW and Variable 2 are ignored). Second letter/email is NOT sent because Custom Property value (30) is larger than total of VariableW and Variable2 (25).

OR 

For example IF:

VariableW = 10

Variable2 = 15

Custom Property = 20

THEN, first letter/email is sent, second letter email sent at 25 days. Custom Property value (20) is lower than total of VariableW and Variable2 (25).

(2) To prevent a Customer from receiving any / all emails from ID800, set Custom Property ZCJPastDueInvoiceDays to 9,999 on BILL TO Customer Record: 

ID800CP9999.PNG

 

 

 

Daily Summary

Daily Summary

Escalation Level (1, 2 , 3 notice, # times email sent)

Not Sent? Indicates why invoice not sent - No AR Contact and/or Unapplied Payment

If column is blank, then email was sent

ID800Summary.PNG

 

 

*  *  *

 

Best Practices & Tips

Best Practices & Tips

-If you need to exclude a customer temporarily from receiving these emails, then set Custom Property ZCJPastDueInvoiceDays to 9999. Be sure to make a note for yourself to switch it back as we do not monitor those for you.

-We will set this alert up in test mode first as it is a customer facing alert for you. While in test mode, alert will only send to any email(s) listed on the to/cc/bcc of your alert subscription the Top 8 for each invoice type. While in test mode, if running alert in SELECT mode, you MUST still set Customer Record up with Custom Property. 

Once you've reviewed sample emails and feel comfortable with the alert's functionality, then you can let us know at help@ceojuice.com you're ready to go live. At that time, we suggest removing emails from to/cc as their email will show on emails sent to your customers and those emails will likely be bombarded with emails.

*Please note: If first email (VariableW) triggered while in TEST mode and then alert flipped to LIVE mode, that invoice will only ever qualify for second (and further, if used) escalations. If needed, when we flip LIVE we can wipe the alert logic so all output goes out again. But please beware as that means an invoice could trigger for first escalation today and second escalation tomorrow, depending on how many days past due.

-List yourself in the CC to receive the daily summary only, if you want to also be on copy for the output invoices being sent add yourself to the BCC. Any email listed in TO will receive emails sent to customer, but not the daily summary.

Send_To.PNG

-Consider the FROM email on your alert subscription since this will be sending to your Customers. We suggest using an email like accountsreceivable@, so should your customer reply to the email, your staff will receive. You can change on subscription, BUT FIRST check with your IT Department to ensure ceojuice user has permissions to "send as" (not on behalf of) the email address listed here on your subscription (otherwise emails won't actually get to your customers and we have no way of knowing that is happening). Then let us know so we can test to make sure.

CLICK HERE for instructions on needed permissions for ceojuice user.

Send_From.PNG

 

-Our variable settings allow for a first and second notice; however, if you'd like, we can add up to a 3rd escalation. We don't do more than three escalations as at that point other collection efforts would be needed since emails don't seem to be doing the trick! Please email help@ceojuice.com with exact verbiage and days past VariableW for each subsequent escalation letter/email to be sent.

-If you need different text into the signature line for different branches, please email us at help@ceojuice.com and we can program the alert accordingly. We are not able to accommodate different graphics though. Please provide us details by branch number.

Creating Custom Property

Creating Custom Property

To create needed Custom Property please see these steps:

Step 1:

Create Attribute via Tools / Lists & Codes / Attributes

Attribute Name: ZCJPastDueInvoiceDays

Description: # of days at which to start sending past due invoices ID800

Data Type: Numeric

ID800-1.PNG

Step 2:

Add Atrtribute to Customer Record Configuration via Tools / Lists & Codes / Configuration (Custom Properties).

Select Customer Record Configuration type, use Quick Add to add ZCJPastDueInvoiceDays and be sure to leave default value blank

 

ID800-2.PNG

Creating Task Type

Creating Task Type

If you wish for alert to create task in AR Console (version 20200625+ only), then create Contact Task Type to be used only for this alert process via Tools / Lists & Codes/ Contact Task Types:

**this Task Type must be populated in Variable4**

Sample:

ID800TaskType.PNG  

 

*  *  *

Related Alerts

Related Alerts

ID213 - AR Collection letter with past due bucket Amounts (First & Second Notice)

ID305 - Validate Email Address Field on all Contact Records

ID461 - To Notify if Invoiced Customer Has Unapplied Credit

ID387 - Ensure you have a Contact with email

ID767 - Sends a list of all customers with no AP contact/email

ID717 - CEO Juice Custom Report Unapplied AR Payment Review

 

*  *  * 

 

 

 

 

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