DELR - Delivery Routes

4.79 - 11/21/22

• salesref field added to OPA

• barcode change for OPA

• Excel output option for manifest reprint from display routes
• previous shipment
  • displays old packer, pcs, and cod amount
  • option REPRINT or NEW ORDER

• maint moved out of job stack
• maint deletes old based on open date instead of close date
• extra cod envelope label now optional

• for OPA, if invoice has ship-to, use that for label, else use OPA db
• LABELS, NO LABELS option (do the OPA order setup but no labels)

• phone# added to REVIEW ADP/OPA CUSTOMER MATCHES
• checks ship to phone# for opa match
• prompts to cancel or continue if OPA route is UPS

• if cod, print one extra, simplified label for cod envelope

• pieces 1 of x, 2 of x, etc. put back on labels

• address added to close matches algorithm - now first 3 char of zip:name:address:city
• phone# matching fixed

• ship to address,csz fixed

• option to use phone cross-refs in OPA or not

• packers can be name type 4 as well as 7

• uses ship-to address if there is one first, then defaults to bill-to
• uses DS.PARSE.NACSZ subroutine

• checks for phone# match before doing the zip and close matches checking

• -k added to curl shipments

• For OPA, if shipment already exists, reprints labels only, no resend to OPA

• Ship Track url stored in DELR.DT instead of hard code

• change url for ShipTrack

• added prompt for SD (same day) or ND (next day), and added this data to OPA ShipTrack 4.5 - 5/23/09
  • added RELOAD OPA DATABASE to first menu
  4.4 - 5/9/09
  • CASH-ONLY flag added to label
  4.3 - 2/18/09
  • F9 PNOD does an invoice search if no Pick Track
  • REVIEW ADP/OPA CUSTOMER MATCHES
    • blank lines now properly displayed
    • no longer stores duplicates
  4.2 - 2/7/09
  • OPA login step eliminated
    userids and passwds are stored
  • algorithm for comparing names to opa database improved
  • REVIEW ADP/OPA CUSTOMER MATCHES added for reviewing mismatches between NAME-FILE and the OPA database
  4.1 - 1/25/09
  • REPORT PACKERS added
  • OPA option to send each shipment or in batches
  • multiple OPA logins
  4.0 - 10/19/08
  • OPA added
  • Noble setups removed
  3.7 - 9/13/08
  • new Noble Logistics ftp address
  • pp update added
  3.6 - 8/31/08
  • auto-send is optional
  • "inspect upon delivery" on Noble labels
  • pieces prompt is now before (above) route prompt
  3.5 - 7/21/08
  • auto-sends Noble file every 15 minutes
  3.4 - 3/23/08
  • now uses city, state only, plus city, state, zip for those with zip-specific routes
  3.3 - 11/21/07
  • changes to bar code
    
    AZ1234599
    | | |
    | | +- piece value (value of DELR.LINE attr 9 for this piece)
    | +------ DELR.NDX id
    +-------- store id
  • get Noble route updates automatically online
  • setup for certain customers to be dedicated to one Noble route
  • uses WIP-HISTORY instead of PDA for old invoices
  • new column on Noble file - Cust No
  3.2.1 - 10/23/07
  • in addition to NAME-FILE and WIP, now also checks SALE-FILE for:
    • CASH ONLY
    • NO CHECKS
    • CASH-ONLY
    to determine if cash only
  3.2 - 7/3/07
  • DELR.MAINT cleans out DELETES over 60 days old
  • tracking deleted invoices by requiring userid and passwd is optional
  • confirmation prompt if adding COD amount to a non-COD sale type invoice
  3.1 - 4/10/07
  • all maintenance moved to job stack
  3.0 - 4/7/07
  • archive route stops and other info like custs in DELR.STOPS
    id is ROUTEroute_name
  • added report ROUTE STOPS
    displays a month by month report on the terminal
  2.99 - 1/19/07
  • for Zebra labels:
    • added Packed By:  __________
    • if cust PO longer than 7 characters, font is smaller so it fits well
  2.9.8 - 1/11/07
  • If reprinting multiple closed routes, program no longer stops after only one when route is "OPS]"
  • Instead of just a password for deleting invoices or pieces:
    • enter userid and password when deleting invoices or pieces
    • setup screen has place for adding and deleting users
    • new report of the deleted pieces and invoices
  2.9.7 - 11/14/06
  • use of same invoice number works when pieces shipped from home and pieces shipped direct from sister store
    the new line is triggered when the second packer # is entered
  • -A, -B, etc. added to invoice number on Noble .csv if previous or second shipment for same invoice number
  • backups of .csv Noble files are kept in DICT DELR.MANIFEST and cleaned out by DELR using same retention as manifests
  • high dollar
    • now select part, then select piece# to attach it to
    • piece# added to high dollar log
    • load reconciliation shows high dollar related to correct piece#
  • version displayed in upper right
  2.9.6 - 8/15/06
  • COD log now includes negative amount invoices
  2.9.5 - 5/11/06
  • send file to Noble is done from the main program menu instead of with a Reflection macro.
  2.9.4 - 2/19/06
  • turned label sideways to make room for bigger fonts
  • for high dollar, prompts for how many of the labels print the high dollar amount
  2.9.3 - 2/11/06
  • *invoice entries now prompt for
    • customer information if customer # entered is not in NAME-FILE.
    • invoice total
    • is it a COD
  2.9.2 - 12/29/05
  • shipping a piece "together with" another piece now prints its own label
    bar code is identical to the piece it is being shipped with
  • invoice amount added to detail delivery summary
  • invoice number DO now picks up address correctly
  • "None" used for Noble file if address is null
  • alt ship now uses correct city on manifest
  2.9.1 - 12/14/05
  • Setup has "Require sending Noble file before closing Noble routes"
    If "Y"es then:
    • Manifest must be sent before it can be closed (printed)
      this is to insure sending of the file
    • a new invoice added will not go on an existing open manifest that has been sent, but will start a new one, just as if the existing manifest were already closed
  • routes display screen is re-arranged and includes Noble sent date/time
  • address is now stored in DELR.LINE so don't have to rely on WIP and PDA.WIP
  • if NOBLE, then routes are corrected as necessary to match Noble's master city list
    a comment is added indicating what route the dealer wanted to use
  • Shift-F12 at the first menu (not documented on screen) allows resetting of records marked as sent to Noble
  2.9 - 11/28/05
  • select which reports to print when closing routes
  • if city, state, zip, or route is overridden with a Noble record, an error is logged
  • if Noble route is prompted and packer overrides to non-Noble record, a comment is stored for including in Noble's file
  • no more error checking in Noble file creation
  2.8 - 11/9/05
  • now using file NOBLE-ROUTES to compare city, state, and zip to make sure correct route is used
  • alt ship-to is more robust forcing something on each line and CITY, STATE ZIP on 3rd line
  • can include dealership logo for labels
  • Noble file sending is updated
  • F12 in PRINT OPEN ROUTES shows total # pieces selected to ship
    you can use to just check, then cancel out with F4
  • confirmation before printing open routes
  • you can close manifests without printing them by entering zero at the # of copies prompt
  • state and zip are saved with DO, which makes the Noble route work right
  2.7 - 10/18/05
  • new label for Noble Logistics
  • Gladys setup to send .csv file to Noble
    includes verification screen for routes and city, states
  • DELR.ROUTE file eliminated - now use item ROUTES in file DS
  • no longer can setup to pull routes from salesmen field of NAME-FILE
    not yet implemented
  • DELR.STOPS file combines customer numbers beginning with "X" with non-X
  • total cost is stored in DELR.LINE
  • DELR.STOPS stores returns related to stops
  • invoice total includes freight and core
  • uses new file ROUTE.CUST for routes - setup for pulling from SHIP-TO, SHIP-VIA, or SALESMEN removed
    default route comes from line of invoice comment beginning "ROUTING:"
    if no such line, then tries to use first value in ROUTE.CUST
    not yet implemented
  • if invoice has ship-to, manifest automatically uses that for alternate ship-to
    not yet implemented
  • can manually add an invoice not on file by entering an asterisk followed by anything
    works like DO (drop-off)
    use SF3 (alternate ship-to) for address
  • bug fixed: was duplicating CLOSEBATCH lists if printing more than 1 manifest copy
  • COD log shows alt names and cities
  2.6 - 7/19/05
  • corrected high dollar logging in DELR.LINE item which also printed wrong amount on label
  2.5 - 7/6/05
  • made OPS Shop # on label even bigger
  2.4 - 6/22/05
  • recognizes and stops use of direct ship packer unless logged in from other store
    DELR.SETUP.SUB updated for
  • display fixed in DELR.SETUP.SUB
  2.3 - 6/16/05
  • change to the OPS bar code label to make the shop# more bold and obvious
  2.2 -
  • new file DELR.STOPS for use in BI program
  • new function DELR.MAINT for DELR.STOPS
  2.1 - 4/21/05
  • state and zip added to manifest printout
  • Jackson stuff removed
  • made changes to accomodate selecting routes to include in COD log (for sending to Noble)
  2.0 - 3-15-05
  • compatability with bar code printing
  • setup for count pieces by (C)ustomer or (I)nvoice
    if by invoice, labels print Piece x of y
  • setup for store id character
    this is the first character of the bar code
  • new cleanup routine:
    • updates date in DELR.DT, attr 7
    • cleans up orphans in HI.DOL
    • cleans out old HI.DOL logs
  • high dollar log shows scan date & time if scanned
  1.5 - 3/1/05
  • note for DO (drop off) is now saved correctly
  1.4 - 11-29-04
  • if invoice is only search criterion, it uses DELR.INVOICE instead of ENGLISH to find manifest
  • will not allow route names with asterisks
  • bug fixed - if you entered a cust# to search, it only looked up x-refs, not the # itself
  • hi dollar log now shows qty
  1.3 - 11-22-04
  • now choose a printer when entering DELR.ADD.INVOICES.SUB for printing labels
    previously was a setup for only 1 printer for all labels
  1.2 - 11-17-04
  • DELR.PRINT.CLOSED.SUB now sorts by BY-DSND CLOSEDATE BY ROUTE BY-DSND PRINT-TIME
    • did sort BY-DSND CLOSEDATE BY-DSND PRINT-TIME BY ROUTE
    • provides a more similar sort to DELR.PRINT.OPEN.SUB
  1.1 -
  • editing password no longer encrypted
  • ship direct method is new allowing more than two stores
  • route pull from ship-to, salesman, or ship-via is in user setups
  • cod log and hi dollar log get header name from manifest header first line (DT attr 8)
  • summary reports changed to reflect more than one possible ship-direct location
  • summary reports now show stops
  • ability to setup label printer in setups
    includes ability to setup separate printers for each ship-direct location
  • setup includes option for selecting routes to print in COD log