1 / 16

Scheduler, File Transmissions, & Additional Tools

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.

ivy-michael
Download Presentation

Scheduler, File Transmissions, & Additional Tools

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Scheduler, File Transmissions, & Additional Tools

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

  3. Scheduler Setup – Installation File • Installing the service • Run setup file, follow prompts, finish installation

  4. Scheduler Setup – CONFIG File • Verify the connection string settings in the CONFIG file

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

  6. Scheduler Setup – Windows Service • Ensure service is set to start / run automatically

  7. Scheduler Setup – eoStar Plugin • Update License Information from Rutherford Tech Link • Upgrade DB to include scheduler options

  8. Mail Delivery Method – DB Mail

  9. Mail Delivery Method - SMTP

  10. Scheduler – General Usage • ION Reports

  11. Scheduler – General Usage • SQL Reports

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

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

  14. Maintenance Tools – Configuration Screen • Interface to schedule tasks Demo

  15. Bonus – Scheduler Testing Tool • On-Demand processing of scheduled tasks

  16. Discuss | Ask | Suggest • Tom Veen • tomv@eostar.com • Chris VanRandwyk • chrisv@eostar.com

More Related