Skip to content

Latest commit

 

History

History
24 lines (15 loc) · 1.33 KB

README.md

File metadata and controls

24 lines (15 loc) · 1.33 KB

Date Verification Utility

Screenshot

About

This utility automatically updates dates in a Promise Date Verification file using estimated completion dates provided by a scheduler. When updates cannot be made automatically or for exceptions, dates are left empty for manual review.

Installation

Download and run the latest release.

Instructions for Use

  1. Click the first 'browse' button, navigate to, and select the spreadsheet file containing estimated dates from the scheduler.
  2. Click the second 'browse' button, navigate to, and select the spreadsheet file containing the Promise Date Verification template from the customer.
  3. Enter the number of days to add to the estimated completion dates provided by the scheduler to account for transit time and select whether weekends should be included in the transit time calculation. Note that transit time does not include the estimated ship date.

Example:

  • Entering three (3) in 'Transit Time Days' and unchecking 'Include Weekends' will result in a shipment that is shipped on 5/6/2022 being promised for delivery on 5/11/2022.
  1. Click 'Update report'. Updates will be made over the selected Promise Date Verification template.

Issues or Feature Requests

Please submit issues here or email the author directly.