Follow

ID623 - Customer Tax Exempt Certificate is Expiring, Overview & Sample

 

Notifies when a Customer Tax Exempt Certificate is due to Expire

Jump to a specific section by clicking a link

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

 

Click to Subscribe

 

Overview

Overview

For clients who wish to track their customers Tax Exempt Certificate expiration date, to ensure an up to date certificate is on file at all times. Requires that you assign the current expiration date on the customer records that you want to track.

 

Run Schedule:  Daily

Type of Output: Email

 

*  *  *

Sample

Sample

Screenshot 2025-02-26 at 3.54.43 PM.png

 

*  *  *

Variables

Variables

Screenshot 2025-02-26 at 3.50.22 PM.png

Variable W: Custom Property that is used to track the expiration date of the certificate on a customer record

Variable X: # of days you want to be notified before the certificate expires, default is 30 days

Variable Y: Enter Branch Number(s) to trigger on, separate by comma, or leave blank for ALL branches

 

 

*  *  *

Alert Functionality

Alert Functionality

This process monitors the expiration date set in a customers record for any customer you wish to track their certificate date.

  • Set the expiration date in ZCJTaxExemptExpiration

If this property is missing as an option, see this link for setup instructions

Screenshot 2025-02-26 at 4.10.32 PM.png

  • A customer must be set to active in order to report on the alert.
  • The alert does not consider any Exempt Code identified or other Tax Code data recorded on the customer record to exclude from reporting. The alert does include that information on the alert purely as a reference only (per above example in the Sample section).

Screenshot 2025-02-26 at 4.14.13 PM.png

  • Use Variable X # of days to identify when you want to be notified. If you set 30, and the expiration date on a customer record is set to 1/31/25, that customer will start reporting on 1/1/25 and will keep reporting until either one of the below happens:

a) the date is extended out for another year, once you receive a new certificate, or

b) the date is deleted from that customer record, as you have no need to track it anymore

*  *  *

 

Best Practices & Tips

Best Practices & Tips

 

Custom Property Set Up

Custom Property Set Up

If you do not see that the custom property has already been created in eAutomate, you will need to create it one time in eAutomate, in order for it to be an option to add on a Customer Record

In Tools / Lists & Codes - go to Attributes / New and create per below example.

Copy/Paste the Attribute Name ZCJTaxExemptExpiration

(This is per your Variable W default setting, if you renamed it in Var W, you must copy/paste that name in below)

Screenshot 2025-02-26 at 4.15.37 PM.png

Once the Attribute is saved, you now need to add it to the Custom Property.

Under Tools / Configurations(Custom Properties) - Add to Existing Customer Custom Property, if not available create one

Screenshot 2025-02-26 at 4.18.15 PM.png

Now your Custom Property is ready to be applied on any customer record as needed

 

 

*  *  *

Related Alerts

Related Alerts

NONE

 

*  *  * 

 

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