Laddawn.com : Trucker Orders - Programming Outline

Created by Judy Ascensao, last modified by User df0f1 on Feb 05, 2016

Refer to Design Specs in separate Wiki Page for overview.

 

Shipping Method Popup/Bundling - Add new fields w/Validations:

  1. (UI) When the VIA Code = "TR" (Trucker)
    1. Update the Shipping Method Popup.
      1. Trucker Name - Free Form optional field
      2. Contact Name - Free Form optional field
      3. Contact Email Address - Required if no Trucker Name was provided else Optional.  Check for Email Address  "@" or phone number format (even though watermark says Email Address)
    2. Add these properties to CheckoutShipmentBundle to carry these fields around while in the bunding screen.
  2. (DB/UI) Bundling Routine: Pass the Trucker name back and fourth as BUNDLE.TRUCKER.NAME
    1. (DB) Create a new Named Param for BUNDLE.TR.CARRIER (trucker name), BUNDLE.TR.CONTACT (contact name), BUNDLE.TR.CONTACTVIA (contact email/phone#)
  3. (DB) Update the SHOPPINGCART.USR record with these new fields on Save of bundling screen (associated with each bundle) .
    1. Update the Dictionary and SYS3002 (SYSFILES)
    2. RPC$SHOPPINGCART_SAVE
  4. (DB) Fix - Don't included TR in carrier list when FOB = P&A:
    1. RPC$SYSTEMTABLEITEM_GETBYFILTER
    2. Using SHIP.FOB, don't include TR in the large or small carrier list when FOB is P&A (add to invoice) 
  5. (UI) Fix - Change current validation error box for Missing Account Number from "Validation Error" to "We need a little more info" format - see Susan's Design Spec

Order Creation:

  1. (DB) When the bundle Ship Via is TR, add an INTERNAL order comment to SOHDR<38>/SOHDR.USR<22-24> that will be printed on the picking slip (see format below):
    1. Reformat existing comment# 121 via SYS9012 to the format shown below - must include 3 "\" for inputs (Trucker Carrier Name (BUNDLE.TR.CARRIER), Trucker Contact Name (BUNDLE.TR.CONTACT), Email/Phone(BUNDLE.TR.CONTACTVIA))
    2. During order creation, add this comment to the sales order (RPC$SHOPPINGCART_CREATEORDER)
  2. (DB) - When creating orders for each bundle, take into account these new Trucker fields before merging multiple bundles into a single sales order.  Today, we check that the ship date, FOB Code, Via Code, comments, etc are the same before we will combine multiple bundles into a single order.  These 3 fields must be the same for all bundles that you are merging together into a single order.  Modify RPC$SHOPPINGCART_CREATEORDER.
  • Comment 121:

    Trucker: <Trucker name>; Laddawn Warehouse Manager: Please contact <person to contact> at <email address or phone> when order is ready.

        If there's no trucker and/or no person to contact, it will look like this with "(blank)" in parentheses printed:

    Trucker: (blank); Laddawn Warehouse Manager: Please contact (blank) at mike@crownpackaging.com when order is ready.

 

Picking Slip:

  1. (DB) No change to the Ship Via box - leave this as TR
  2. (DB) Should automatically show the internal order comment that was added above - make sure that we are printing internal header comments