Transcript PowerPoint Presentation - Wiki

Scheduler, File Transmissions, & Additional Tools
Topics Covered
• Scheduler
• Setup & general use
• Using the scheduler as an alert mechanism
• Transmitting Files
• SRS files
• EDI documents
• Coke Matrix
• Maintenance Tools
• FIFO recompute
• Database Size Reductions
Scheduler Setup – Installation File
• Installing the service
• Run setup file, follow prompts, finish installation
Scheduler Setup – CONFIG File
• Verify the connection string settings in the CONFIG file
Scheduler Setup – CONFIG File
• Server
• Location of eoStar DB
• Integrated Security
• Windows logon, True / False
• SQL User ID
• SQL Password
• Database
• Name of eoStar DB
Scheduler Setup – Windows Service
• Ensure service is set to start / run automatically
Scheduler Setup – eoStar Plugin
• Update License Information from Rutherford Tech Link
• Upgrade DB to include scheduler options
Mail Delivery Method – DB Mail
Mail Delivery Method - SMTP
Scheduler – General Usage
• ION Reports
Scheduler – General Usage
• SQL Reports
Scheduler as an Alert Mechanism
• Empty reports do not send
• Create reports to look for missing data
•
•
•
•
Missing Ledger Groups
Missing Tax Area
No Pricebook Assignment
No Territory(Can Buy)
• Create reports to look for important information
• Orders with cut items(Driver and OTL)
• Manual priced orders
• Pushed off orders
Transmission & Maintenance
• FIFO Recompute
• Receive EDI Documents
• Send Coke Matrix exports
• Send SRS exports
• Trim EDI export blobs
• Trim HH Logs
• Trim SRS export blobs
Maintenance Tools – Configuration Screen
• Interface to schedule tasks Demo
Bonus – Scheduler Testing Tool
• On-Demand processing of scheduled tasks
Discuss | Ask | Suggest
• Tom Veen
• [email protected]
• Chris VanRandwyk
• [email protected]