Excel document showing details for new Vendor Record created or changes to existing Vendor Record information.
Jump to Overview | Samples | Variables | Alert Functionality | OnDemand Report Filters | Best Practices & Tips | Related Alerts |
Overview
Overview
Sends Excel document showing details for new Vendor Record created or changes to existing Vendor Record information.
Like many of our other audit reports (ID174, ID325, etc) this alert will advise you of changes to or newly-created Vendor Records. This allows you to give your main Vendor Relations admin the opportunity to review all changes to the records they are responsible for maintaining.
Run Schedule: Weekday Evenings
Type of Output: Email
* * *
Sample
Sample
Excel document attached provides summary page:
Vendors Updated:
Vendors Created:
* * *
Variables
Variables
Variable W: Critical Fields Only Mode? Enter Yes or No
These are critical fields only:
VendorNumber
VendorName
Address
City
State
Zip
Contact
Phone
Email
Hold
Active
OnHold
TaxCode
TaxExemptCode
Taxable
* * *
Alert Functionality
Alert Functionality
1. Like other audit reports, we provide the name of the 'Last Updator' but do not guarantee that this is the person who made the change (See THIS LINK for why Last Updator needs to be taken with a grain of salt). Be sure to subscribe to alert ID221 to ensure eAuto Employee Records are set as needed.
2. Will send blank report if no qualifying records (this can not be changed).
3. We are not able to provide you historical data on changes to records from prior to day we install our alert because eAuto does not store this information from which we can pull from. Once we install the alert, then we start building our own comparison table to be able to report back to you from.
4. Tax code fields will be shown on alert only for those who have select the VAT option in eAuto:
VAT option found under Tools / Options / Tax options:
* * *
OnDemand Report Filters
OnDemand Report Filters
Report has no date filters, we do not hold previous changes in our logs. Results of report will be from the last time the alert ran. Alert runs weekday evenings. So if you run On Demand on Monday, the report will include anything updated since Friday night. If run on Thursday the report will include anything updated since Wednesday night.
If there were no changes or new records created, the report will be blank.
These are critical fields only:
VendorNumber
VendorName
Address
City
State
Zip
Contact
Phone
Email
Hold
Active
OnHold
TaxCode
TaxExemptCode
Taxable
* * *
Best Practices & Tips
Best Practices & Tips
1. See THIS LINK for why Last Updator needs to be taken with a grain of salt. Be sure to subscribe to alert ID221 to ensure eAuto Employee Records are set as needed.
* * *
Related Alerts
Related Alerts
ID83 - New Vendor Created
ID169 - Item Change Audit
ID174 - Contract Record Change Audit
ID221 - eAuto Users Not Set Up Correctly
ID325 - Customer Record Change Audit
ID611 - Equipment Change Audit
0 Comments