Once Daily Update
The Once Daily Update is a process that runs on your server each day. This process is designed to automate several tasks to keep your data fresh and system healthy.
Establish the update time
To set the time when this routine runs, navigate to Administration ➤ System Setup ➤ Tools & Custom tab and enter the time in the Update Time field.
The best practice is to avoid allowing the update to coincide with events such as daily operations & data entry, system backups or scheduled scripts. Setting the update to occur overnight is most common.
Daily update tasks
The following tasks are processed with each daily update.
- Web Server temp file cleanup: Some temporary files related to the AV web server will be deleted.
- Inventory Quantity Reserves: All quantity reserve values will be recalculated.
- Custom Scripts: Scripts which are scheduled to run during the update will run now.
- Credit Hold: All clients' credit hold status will be evaluated and credit hold will be enabled/disabled as indicated.
- Access Check: Verifies the key file is not expired.
- Inventory Statistics: All inventory statistics will be recalculated.
- Lead Time: Lead times will be recalculated for products that have this feature enabled.
- Client YTD: YTD sales will be updated for all Clients.
- Sales Summary: Data will be updated in the Sales Summary table.
- Days Past Due: Open A/R items will have Days Past Due updated.
- Quote to Order conversion: Any Quote that is set to auto-release will be converted to an Order.
- System Log cleanup: Some old system logs will be deleted.
- Web Integration Log cleanup: Some old web integration logs will be deleted.
- ModifyDateTimeISO check: Modify Date & Time will be checked and populated if missing.
System Logs
To view the System Logs, navigate to Administration ➤ System Logs and use the Filter By menu to find Once Daily Update logs.
Example system log
