Rainbow - Shipment Slot

Business Requirement:

Rainbow requires all shipments planned for customers have a Shipment Slot to identify when the shipments must be executed at the warehouse. This is essentially a delivery Shipment Slot. The field needs to originate in the customer record and be carried over to the Sales Orders, Load(s) the order is applied to, and Warehouse Shipments.

Functional Requirements

New Table “Shipment Slot” and page

Add new table Shipment Slot with the following fields:

• Shipment Slot – Code10

Add Page Shipment Slot as List page searchable

Location Card Table 14 / Page 5703

Add Shipment Slot(Code10) field as editable lookup on new table Shipment Slot.

On page add to section General after Provincial Tax Area Code.

Customer Card - Table 18 / Page 21

Add Shipment Slot(Code10) field as editable lookup on new table Shipment Slot.

On page add to section Shipping Method after Agent Service.

Warehouse Request – Table 5765 / Page5793

Add Shipment Slot(Code10) field, non-editable. Add after last column.

Sales Header Table 36 / Page 42

Add new field Shipment Slot. On Insert of new record, default to value from Customer Sell-to.

Add editable field to page Sales Order(42) – same lookup on new table Shipment Slot. Add to section Shipping Method after Agent Service.

On Release of Sales Order, propagate the Shipment Slot field to the Warehouse Request table.

When using function Create Warehouse Shipment:

• set Warehouse Shipment Header.Shipment Slot = current Sales Header.Shipment Slot.

• Set Warehouse Shipment Line.Shipment Slot = current Sales Header.Shipment Slot.

SWL Load Subform Assinged / SWL Delivery Request

• Add Shipment Slot to Lines Subform in Loads

• Add Shipment Slot to SWL Delivery Request List / SWL Delivery Request

• Add Shipment Slot to SWL Load Order Lines in View Order/Lines from Loads

Transfer Header Table 5740 / Page 5742

Add new field Shipment Slot. OnValidate of field “Transfer-To Code”, set Shipment Slot = Location.Shipment Slot where Transfer-To Code=Location.Code.

Add editable field to page Transfer Order(5742) – same lookup on new table Shipment Slot. Add to section Shipment Tab after Shipping Agent Service Code.

On Release of Transfer Order, propagate the Shipment Slot field to the Warehouse Request table.

When using function Create Warehouse Shipment:

• set Warehouse Shipment Header.Shipment Slot = current Transfer Header.Shipment Slot.

• Set Warehouse Shipment Line.Shipment Slot = current Transfer Header.Shipment Slot.

Warehouse Shipment Header Table 7320 / Page 7335

Add Shipment Slot(Code10) field as editable lookup on new table Shipment Slot.

Default value OnInsert = <blank>

When using function Get Source Documents;

• set Warehouse Shipment Header.Shipment Slot = first Source Doc found.

• Set Warehouse Shipment Line.Shipment Slot = per each Source Doc Header.Shipment Slot.

Warehouse Shipment Line Table 7321 / Page 7336

Add Shipment Slot(Code10) field as non-editable.

Posted Whse. Shipment Header Table 7322 / Page 7337 & Posted Whse. Shipment Line Table 7323 / Page 7338

Add same fields and ensure same field numbers for automatic propagation of values to posted records.