Follow

ID461 - Invoiced Customer has Unapplied Credit Overview & Sample:

Sends a list of invoices created today, and customer has an open credit/payment on their account.

Jump to a specific section by clicking a link

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

 

Click to Subscribe

Overview

Overview

This alert advises hourly of any invoice(s) just created for customers with an open credit/payment on their account. Best practice is to review before your eAgent task sends/prints invoices, allowing you to apply any credits to the open invoice/s.

 

Run Schedule: Hourly

Type of Output: Email

 

*  *  *

Sample

Sample

Screenshot 2025-08-06 at 2.48.51 PM.png

 

*  *  *

Variables

Variables

Screenshot 2025-08-06 at 2.53.49 PM.png

Variable W: Customer types to exclude from the alert. Enter any customer types to exclude from the alert, separated by commas. Leave blank to trigger for all customers.

Customer Types found via Tools / Lists & Codes / Customer Types:

CustomerTypes.png

Variable Y: Customer Numbers to exclude from reporting (not customer name), list multiples separated with a comma.

Variable X: Branch numbers. Enter the branch numbers for the alert to trigger on, separated by commas. Leave blank to trigger on all branches.

 

 

 

*  *  *

Alert Functionality

Alert Functionality

1. Advises hourly of any invoice(s) generated for customers with an open credit/payment on their account. Best reviewed before your eAgent task sends/prints invoices, so credit can be applied and reflected on the invoice balance. 

461_opencredits.png

2. Will report if ANY of these conditions exist: Unapplied Payment, Open Credit Memo, Negative Invoices, Misc. Charge Credit Memo, etc. (The account balance does not have to be negative/a credit).  Has a lookback of 5 days, so when any of these conditions occur, if there are open invoices within the past 5 days, alert will notify on those open invoices as a reminder that you can apply that open credit/payment to those invoices.

3. Definitions:

Total Open Amount is the total open on the account - all open invoices and credits.

Total Unapplied Amount is the total of payments or credits that have not been applied to invoices yet.

Total Credit Memos is the total of any/all unapplied credit memos on the account.

ID461Define.png

4. Alert considers Bill To Customer Number to look for open credits. If you use the pencil edit option in e-automate, this will break the connection of Bill To in e-automate's background tables, causing this alert to NOT identify.

Pencil1.png

Pencil2.png

*  *  *

Best Practices & Tips

Best Practices & Tips

1. This alert is capable of sending to branch roles, please see this link for details on setting up the branch roles.

SendtoBranchRole.png

 

 

*  *  *

Related Alerts

Related Alerts

ID597  - Payments posted but not applied to invoices by end-of-day

 

*  *  * 

 

 

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