Transportation method mandatory on Transfer orders

Transportation method is now mandatory on all transfer orders to align imported transfer orders with the Supply Planning hierarchy definitions.

These new FK constraints have been added:

  • BASE_SC_TRANSFER_OPEN_TRX_FK_TRAROU --> BASE_SC_TRANSPORTATION_ROUTE_BK
  • BASE_SI_TRANSFER_OPEN_TRX_FK_TRAROU --> BASE_SI_TRANSPORTATION_ROUTE_BK
  • BASE_SC_TRANSFER_HIST_TRX_FK_TRAROU --> BASE_SC_TRANSPORTATION_ROUTE_BK
  • BASE_SI_TRANSFER_HIST_TRX_FK_TRAROU --> BASE_SI_TRANSPORTATION_ROUTE_BK
  • BASE_SC_TRANSFER_CNCL_TRX_FK_TRAROU --> BASE_SC_TRANSPORTATION_ROUTE_BK
  • BASE_SI_TRANSFER_CNCL_TRX_FK_TRAROU --> BASE_SI_TRANSPORTATION_ROUTE_BK
  • BASE_SC_TRANSFER_PLND_TRX_FK_TRAROU --> BASE_SC_TRANSPORTATION_ROUTE_BK
  • BASE_SI_TRANSFER_PLND_TRX_FK_TRAROU --> BASE_SI_TRANSPORTATION_ROUTE_BK
  • BASE_SC_TRANSFER_PLAN_FK_TRAROU --> BASE_SC_TRANSPORTATION_ROUTE_BK
  • BASE_SC_TRANSFER_PLAN_FXD_FK_TRAROU --> BASE_SC_TRANSPORTATION_ROUTE_BK
  • BASE_SC_TRANSFER_PLAN_PLND_FK_TRAROU --> BASE_SC_TRANSPORTATION_ROUTE_BK
  • BASE_SC_TRANSFER_PLAN_RSCH_FK_TRAROU --> BASE_SC_TRANSPORTATION_ROUTE_BK

These new validation rules have been added:

  • BASE TRAOPENTRX FK Transportation Route
  • BASE TRAHISTTRX FK Transportation Route
  • BASE TRACNCLTRX FK Transportation Route
  • BASE TRAPLNDTRX FK Transportation Route

These new validation rules check, if a transportation route is defined between the source and destination locations using the transportation method as specified on transfer orders. As a transportation route is always defined by transportation method, effectively, these new validation rules make transportation method mandatory on all imported transfer orders. Foreign-key constraints and validation rules that became obsolete after this change have been removed.

These existing FK constraints have been removed:

  • BASE_SC_TRANSFER_OPEN_TRX_FK_ITMLOCD
  • BASE_SC_TRANSFER_OPEN_TRX_FK_ITMLOCS
  • BASE_SC_TRANSFER_OPEN_TRX_FK_TRAMET
  • BASE_SI_TRANSFER_OPEN_TRX_FK_ITMLOCD
  • BASE_SI_TRANSFER_OPEN_TRX_FK_ITMLOCS
  • BASE_SI_TRANSFER_OPEN_TRX_FK_TRAMET
  • BASE_SC_TRANSFER_CNCL_TRX_FK_ITMLOCD
  • BASE_SC_TRANSFER_CNCL_TRX_FK_ITMLOCS
  • BASE_SC_TRANSFER_CNCL_TRX_FK_TRAMET
  • BASE_SI_TRANSFER_CNCL_TRX_FK_ITMLOCD
  • BASE_SI_TRANSFER_CNCL_TRX_FK_ITMLOCS
  • BASE_SI_TRANSFER_CNCL_TRX_FK_TRAMET
  • BASE_SC_TRANSFER_HIST_TRX_FK_ITMLOCD
  • BASE_SC_TRANSFER_HIST_TRX_FK_ITMLOCS
  • BASE_SC_TRANSFER_HIST_TRX_FK_TRAMET
  • BASE_SI_TRANSFER_HIST_TRX_FK_ITMLOCD
  • BASE_SI_TRANSFER_HIST_TRX_FK_ITMLOCS
  • BASE_SI_TRANSFER_HIST_TRX_FK_TRAMET
  • BASE_SC_TRANSFER_PLND_TRX_FK_ITMLOCD
  • BASE_SC_TRANSFER_PLND_TRX_FK_ITMLOCS
  • BASE_SC_TRANSFER_PLND_TRX_FK_TRAMET
  • BASE_SI_TRANSFER_PLND_TRX_FK_ITMLOCD
  • BASE_SI_TRANSFER_PLND_TRX_FK_ITMLOCS
  • BASE_SI_TRANSFER_PLND_TRX_FK_TRAMET
  • BASE_SC_TRANSFER_PLAN_FK_ITMLOCD
  • BASE_SC_TRANSFER_PLAN_FK_ITMLOCS
  • BASE_SC_TRANSFER_PLAN_FK_TRAMET
  • BASE_SC_TRANSFER_PLAN_FXD_FK_ITMLOCD
  • BASE_SC_TRANSFER_PLAN_FXD_FK_ITMLOCS
  • BASE_SC_TRANSFER_PLAN_FXD_FK_TRAMET
  • BASE_SC_TRANSFER_PLAN_PLND_FK_ITMLOCD
  • BASE_SC_TRANSFER_PLAN_PLND_FK_ITMLOCS
  • BASE_SC_TRANSFER_PLAN_PLND_FK_TRAMET
  • BASE_SC_TRANSFER_PLAN_RSCH_FK_ITMLOCD
  • BASE_SC_TRANSFER_PLAN_RSCH_FK_ITMLOCS
  • BASE_SC_TRANSFER_PLAN_RSCH_FK_TRAMET

These existing validation rules have been removed:

  • BASE TRACNCLTRX FK Item-Destination Location
  • BASE TRACNCLTRX FK Item-Source Location
  • BASE TRACNCLTRX FK Transportation Method
  • BASE TRAHISTTRX FK Item-Destination Location
  • BASE TRAHISTTRX FK Item-Source Location
  • BASE TRAHISTTRX FK Transportation Method
  • BASE TRAOPENTRX FK Item-Destination Location
  • BASE TRAOPENTRX FK Item-Source Location
  • BASE TRAOPENTRX FK Transportation Method
  • BASE TRAPLNDTRX FK Item-Destination Location
  • BASE TRAPLNDTRX FK Item-Source Location
  • BASE TRAPLNDTRX FK Transportation Method
Note: This feature is enabled after loading the base template (base.zip) for this version. You are not required a new role or privilege access to use this feature.

Action required prior to activation:

When transfer orders are used: The standard M3 integration already populates the transportation method on all imported transfer orders; hence no action is required. If transfer orders are imported from another ERP or from M3 but using a custom import, either the custom integration must be extended to populate the transportation method on transfer orders or the new validation rules must be disabled.