Logistics TrainingRoutes ManagementPresented by SBSDecember 2013NOH Belgium
●Routes Management Introduction ●Routes Codification and Description
●Data and Tool required to maintain Routes

●Single creation of Route
●Single creation of Route Determination
●Mass upload for creation of Route
●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.
Introduction to the Routes in the ERP●Route: Distance to be covered between a shipping point and a destination point. A route can be made up of several legs.

○ The Service Provider. It is the carrier who will execute the shipment.
○ The Duration and Calendar: Lead Time and Transit Time, Factory Calendar. ![]()
○ The Stages created for border requirements, with their corresponding Connection Points.
■ The Connection Points identify railway stations, ports, airports...
Introduction to the Routes in the ERP■ They are used in Route stages to determine a transportation leg where specific costs are generated (loading/unloading, duties, customs clearance etc.)
○ The Relevant for Transport flag. This indicates that Route can be used for creating Shipments.
○ Stage Category - 3 Types:
■1 - Transportation
■2 - Load Transfer (loading/unloading)
■3 - Border Crossing
■1 - Preliminary leg
■2 - Main leg
■3 - Subsequent leg
■4 - Direct leg
■5 - Return leg
○ Special Processing indicator (stage level): Determines the tax rules for the costs in the stage when the country of Tax is different from the departure country.
Introduction to the Routes in the ERP○ Pricing Procedure (stage level): determines which tariff schema must be assigned to the shipment costs, when it differs from the standard one assigned to the shipment type.
○ The Country and Transportation Zone of the Ship-to party
○ The Shipping Condition (coming from the Order)
○ The Transportation Group (coming from the Material Master)
Order or the Stock Transfer Order (if route/shipping point are empty in M3/M5)
○ Multimodal cases: to avoid complexity, we consider Multimodal as Road. Only the Shipping Type differs to select the right tariff line.
○ Point to Point Road routes: depends on the Incoterm -DAT, DAP. The final destination is different from the Ship-To. A leg is created with the Departure Point (always identify the delivering plant in these cases) and the Arrival Point (Border crossing, City etc.). The second part of the Incoterm must be created as a Connection Point.
○Depending on the railway company, the route can be unique for a Ship-To (with a specific Transportation Zone)
Route Structure○ The distance has to be inserted in the Direct leg and issued from DIUM for Europe. Units allowed are KM and MEI for US rail routes.
○ When the carrier takes in charge the transport from the Departure Plant to the Departure Airport: 2 Direct legs are created, only 1 is relevant for Shipment costs.
○When 2 separate shipments need to be created (1 preliminary and 1 main), the legs are defined accordingly: Preliminary leg + Main leg.
○If Route is used for Stock Transfer Orders, the Import Duties are paid with the Order, and are not included in the stage (not cost relevant)
●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes

●Single creation of Route
●Single creation of Route Determination
Route Codification●Mass upload for creation of Route
●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.
First digit: main Mode of Transport (1-Sea, 2-Rail, 3-Road, 4-Air, 5-Mail & Parcel, 7-Pipeline, 8- Inland Water)
Second digit: Country of departure
Third digit: Business Code or random digit
Fourth digit: Random digit, or specific business rules. Ex. for Rusvinyl:
Shipping Type (A container 20, B container 40, L liquid, P powder, 0 standard - R return)
Route Description for ROADFifth letter: Random digit, or specific business rules. Ex. for Rusvinyl: S for salt/salted water or number
Sixth digit: random digit
Ex: 3OV001 - 1T0529 - 2D0513 - 4IC004 etc.
○ 2 digits to indicate:
■ Dangerous or Non-dangerous goods. ■ Physical nature of the goods:
■ Bulks: Liquid, Gaz, Powder
■ Packed: E
Road Route Examples○ A separator: "-"
○ 3-4 digits with a short description of the product. Ex: PVC, LSC, SALT ○ A separator: "-"
○ The arrival zone. For short routes, give the average distance of the relation.
○ 2 Digits to indicate the Transit duration : nbr of days + T
○ 2 Digits to indicate the Transportation Lead Time : nbr of days + L ○ Etc.
●Examples of Road Routes and their description:
○ 3U1055 : WN-DE-H2O2-BOWKER-Transit 6 Day- Europe
■ Departure Warrington to arrival zone of Europe for H2O2 Dangerous and Packed products. The Carrier is Bowker, the Transit duration is 6 days.
○ 3F0005 : DO-NE-XXXX-AUBRY-200/250KM-1DAY
■ All arrival zones located between 200 and 250 km from Dombasle, for Non Dangerous Packed products, by haulier Aubry, Transit duration is 1 day.
○ 3H0001 : AXA1-NE-SODA-TARGET-SUEZ-2DAYS
■ Departure SASC DEKHEILA PORT to arrival zone of Suez. Non Dangerous Packed Soda products. Carrier is Target Logistics, Transit duration is 2 days.
○ A separator: "/"
○ 2 digits to indicate the site of departure
○ A separator: "-"
Route Description for RAIL○ 2 digits to indicate the country of destination
○ A separator: "/"
○ 6-7 digits to indicate the customer number :eg 1201026 ○ A separator: "-"
○ 2 digits to indicate:
■ Dangerous or Non-dangerous goods. ■ Physical nature of the goods:
■ Bulks: Liquid, Gaz, Powder
■ Packed: E
○ A separator: "-"
○ 3-4 digits with a short description of the product. Ex: PVC, LSC, SALT ○ A separator: "-"
○ The type of container (container on railcar), when relevant. Eg C40 for 40' containers
Route Description for SEA○ RET for return, when relevant. ○ Etc.
■ Departure country Russia. Loading in Kstovo. Destination country Belarus. Customer
337711 (BELORUSKALYI OAO) for PVC Non-Dangerous and Packed products. The Carrier is RZHD.
○ 2 digits to indicate:
Route Description for SEA■ Dangerous or Non-dangerous goods. ■ Physical nature of the goods:
■ Bulks: Liquid, Gaz, Powder
■ Packed: E
○ A separator: "-"
○ 3-4 digits with a short description of the product. Ex: PVC, LSC, SALT ○ A separator: "-"
○ Country Code and Port of Departure
○ Country Code and Port of Arrival
■For all Belgian sites, all non dangerous packed products, port of departure Antwerp, port of arrival Piraeus (Greece) by container 40'
○ 1F0002 :TA-DE-CLM-FR/FOS-GR/PIRAEUS
■ For Tavaux, dangerous packed product, CLM, port of departure FOS, port of arrival Piraeus.
●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes

●Single creation of Route
Creation of a Route - Required Data●Single creation of Route Determination
●Mass upload for creation of Route
●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.
○ The Shipping Type is mandatory. It is used for Shipment Cost determination. Select a Shipping Type related to the product type that will be associated for Route Determination.
Creation of a Route - Required Data ○ The Transit Duration is the number of calendar days required for delivering the goods from the Shipping Point to the arrival point.
■ The Time Unit is the DAY.
■ Remark: 0,5 = 1 DAY and 0,49 = 0 DAY.
■ A Transit Time of 0 DAY means that the customer is delivered on the same day as the Loading date.
○ The Factory Calendar is the calendar that is valid for this Route. Use the calendar of the Shipping Points "Z0 (365/365)".
○ The Mode of Transport at the Border is 3 for Road, 2 for Rail, 1 for Sea etc.
© 2011, SOLVAY S.A.
Creation of a Route - Required Tool●The transaction Z1T_ROUTE is a tool box dedicated to the maintenance of the Routes.
○ You can use it in Display Mode for displaying the Route and the Route Determination.
○ You can use it in Change Mode for the creation of the Routes, the Route Determination and the Connection Points:
■ Single creation mode is used to create data one by one.
■ The Excel file can be uploaded for mass creation of the data.
○ Use this transaction in Change Mode only when required. Accessing it in
Change Mode locks the tables behind this transaction. You can access in Change Mode only if you have authorizations to maintain and create Routes.
●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes
●Single creation of Route
Display Routes & Routes Determinations●Single creation of Route Determination
●Mass upload for creation of Route
●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.

Display Routes To display the Route DeterminationTo create Connection PointsTo switch to Change Mode
© 2011, SOLVAY S.A. Click on the matchcode to search for a RouteEnter the first digits of the Route to restrict the search (in this example: all Road routes from Italy)Then click on
1 2 4 You can also select by Service Agent (carrier) 3

○Double-click on a Route code to display its details.

To display the Route DeterminationThe system switches to the Route Determination area
1 2

Enter the following data (use the matchcode):- Departure Country / Departure Zone- Destination Country / Destination Zone 1 Press Enter. The list of proposed Routes is displayed 2

○Display Route Determination:Enter the selection criteria and execute 1 The list of proposed Routes is displayed
2 
Agenda●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes
●Single creation of Route Determination
Transaction Z1T_ROUTE - Change Mode●Mass upload for creation of Route
●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.

To switch to Change Mode

Single creation of a Route To switch to the maintenance of Route DeterminationTo upload multiple objects with the Excel fileTo switch back to Display Mode

○To create a new Route:Enter the Code of the RouteEnter its Description Enter the code of the Service Agent who will execute the shipmentEnter the Mode of Transport at the Border 1 2 3 4 Enter here:- the Transit Duration (in days)- the Transportation Lead Time (in days)- the Calendar of the Shipping Point Flag the field Relevant for Transport so that the Route can be included in a Shipment 5 6 4

Single creation of a Route When all required data are inserted, press Enter, and check your data
Warning: Data are NOT saved yet!
Enter here the:



Single creation of a Route
■ Main Leg:
Single creation of a Route ■Subsequent Leg:

To save your data, click on
The following message appears: ![]()
●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes

Agenda●Single creation of Route
●Mass upload for creation of Route
Single creation of a Route Determination ●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.

To switch to the maintenance of Route Determination

●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes
Agenda●Single creation of Route
●Single creation of Route Determination
●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.
■ The Excel templates can be found at the following URL: New Excel template 20120201
■ Fulfill the Excel file as required:

Mass upload for Routes creation
■ Save the Excel file in txt format (text file):

Mass upload for Routes creation
Mass upload for Routes creation ■Edit your txt file to remove undesired data (only data for Routes to be uploaded should remain):
The first line of the file correspond to the first Route to be created. There is no other entry after the last entry of the Route to be created.
To upload the Excel file for mass creation of Routes (continued):
Click on Upload Road |
Mass upload for Routes creation 1 
2
Select your txt file 3 Click on Open, the upload starts
SIS / CMR / Dec-12In case a Route already created in the system is included in the file, the system displays the following message. Press Yes or No.When the upload is completed, the following log appear

●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes

Agenda●Single creation of Route
●Single creation of Route Determination
●Mass upload for creation of Route
© 2011, SOLVAY S.A.
■ The Excel templates can be found at the following URL: New Excel template 20120201
■ Fulfill the Excel file as required: go to the tab "Determination"
Mass upload for Route Determination

■ Save the Excel file in txt format (text file):

Mass upload for Route Determination
Mass upload for Route Determination ■Edit your txt file to remove undesired data (only data for Routes Determination to be uploaded should remain):
The first line of the file correspond to the first Route to be created.There is no other entry after the last entry of the Route to be created.



Mass upload for Route Determination Click on Upload Determination 1 3 Select your txt file 4 Click on Open, the upload starts Click on Upload Determination 2
To upload the Excel file for mass creation of Route Determination:
When the upload is completed, the following log appear |
|

Agenda
●Single creation of Route
●Single creation of Route Determination
●Mass upload for creation of Route
●Mass upload for creation of Route Determination
SIS-STAFF / INT / Month-07 © 2007, SOLVAY S.A.
Connection Points -
Connection Points - Display (1)SIS-STAFF / INT / Month-07 © 2007, SOLVAY S.A.



Connection Points - Display (2)© 2011, SOLVAY S.A.
© 2011, SOLVAY S.A. 
Double-click on the connection point




Connection point related to a railway station:
in red box mandatory fields for a railways stationin green optional fieldsthe train station number (L) should be the official id.
When you need to identify a customer as a connection point, the recommendation is to identify only the town of destination in order to avoid creation of lot of points:
in red box mandatory fields for a final the connection id = the shorted name town description = full town name.customer of destination
Connection point related to a shipping point:
in red box mandatory fields for a shipping point
© 2005, SOLVAY SA*
Connection point related to a supplier:
in red box mandatory fields for a supplierthe connection id = the supplier numberdescription = supplier short name and (if necessary) town.
Thank you for your attention!