ID71 - 1099 Vendors Missing Required Information Overview & Sample

Reports on AP Vendors needing review for 1099 submission.

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

Click to Subscribe 


The alert will show any vendor that has qualified for a 1099 by reaching the threshold you set in VariableW and report any missing data in the fields critical to create 1099s. 

Run Schedule: Quarterly - March 15, June 15, Sept 15, Dec 15 AND January 15

Type of Output: Email


*  *  *


No samples yet as still in development


*  *  *



Variable W: Threshold-Set minimum amount of dollar purchases made by vendor for alert to consider (REQUIRED)

Variable X: Custom Property1 - create Custom Property Attribute for alert to show contents of (OPTIONAL)

Variable Y: Custom Property2 - create Custom Property Attribute for alert to show contents of (OPTIONAL)

Variable Z: ZCJ1099OptOut - on Vendor Record set this Custom Property to YES if you'd like alert NOT to consider this vendor. Set as No (or leave blank) to have alert consider



*  *  *

Alert Functionality

-Alert will consider all of your Vendor Records, check for Purchases so far this year (per minimum threshold set on VariableW) and will show Fed. employer ID and if 1099 required per your Vendor Record: 


As also seen in eView Vendors:




*  *  *


Best Practices & Tips

-Use Vendors eView to export data to create your 1099's as needed:



Creating Custom Properties

1. Opt Out Custom Property

This alert provides you ability to opt out a Vendor Record from being considered. This Custom Property must match that listed in VariableZ - ZCJ1099OptOut

To create this Custom Property"

Step 1:

Create attribute via Lists & Codes / Attributes / New:

**Be sure Data Type is Yes/No**


Step 2:

Add this attribute to your Vendor Configuration via Lists & Codes / Configurations (custom properties):


Click in Available Attributes box to find ZCJ1099OptOut:



Select Quick Add and be sure to leave NO default value:


Then you will see listed in available Attributes:



2. Optional Custom Properties to show you any text you'd like included on alert email.

You will need to create your customized Custom Properties and list on VariableX and VariableY as needed (neither required). If you do opt to create, please be sure to populate your subscription variables with the exact name of the attribute(s) you create.

For example: 


Be sure these Custom Properties are configured to your AP Vendor Configuration:




*  *  *

Related Alerts

None at this time


*  *  *

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


Please sign in to leave a comment.
Powered by Zendesk