Follow

ID707 - Vendor Record Information Created / Changed Audit Log

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 FiltersBest Practices & Tips |  Related Alerts |

Click to Subscribe

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

ID707_1.PNG

Excel document attached provides summary page:

ID707_3.png

Vendors Updated:

ID707_2a.png

Vendors Created:

ID707_4.png

*  *  *

Variables

Variables

ID707Variables.PNG

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

-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.

-Will send blank report if no qualifying records (this can not be changed).

-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.

-Tax code fields will be shown on alert only for those who have select the VAT option in eAuto:

ID707z.PNG

VAT option found under Tools / Options / Tax options:

ID707VAT.PNG

 

*  *  *

 

OnDemand Report Filters

OnDemand Report Filters

ID707SSRS.PNG

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

 

-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

 

 

 

 

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