Freight cost capture on Weight and Route basis for Inbound Delivery / Advance Shipping Notification - Part 1

[former_member201529]

Purpose:

The aim of this document is to provide an understanding of the Freight cost capture on KG basis with reference to Inbound Delivery / Advance Shipping Notification.

Process:

Material Master Settings:(Tcode - MM02)

The Gross weight has to be maintained at Basic Data 1 in material master along with weight unit, here the gross weight 30 KG taken for example.

Creation of Purchase Order: (Tcode - ME21N)

Purchase Order has to be created with Confirmation Control Key 0004 Inbound Delivery, here 100 KG taken for example.

Creation of Inbound Delivery / Advance Shipping Notification: (Tcode - VL31N)

Complete Purchase Order quantity taken for IBD and the total weight has been calculated based on Material Master and Delivery (30 KG X 100 KG = 3000 KG).

Creation of Condition Record: (Tcode - TK11)

Go to the transaction TK11 and pass the condition type FB00 for Weight basis, here the key combination take for Transporter, Shipment Type and Shipment Route. Here Rs.55 taken per KG for Route 1, Rs.60 for Route 2 and Rs.30 for Route 3 respectively.

Creation of Shipment: (Tcode - VT01N)

Use the shipment type 0010 Inbound Shipment with corresponding Transport Planning Point for Shipment Creation, pass the required Inbound Delivery number and execute.

Pass the Transporter name along with Shipment route and Type, system will calculate the freight cost automatically based on condition record.

Here Gross quantity is 3000 KG and net Value is 165000 (3000 X 55).

Creation of Shipment Cost: (Tcode – VI01)

Create shipment cost document with reference to shipment number.

Change Shipment Cost: (Tcode – VI02)

Pass the shipment cost number and tick Transfer check box for auto Purchase order creation.

Service Purchase Order has been created in background and you can see the Material Document Number and Service Entry Number in Purchase order history. 

Configuration:

OLML – Shipping - Basic Shipping Functions – Routes - Define Routes - Define Modes of Transport

We have to assign this mode of transport into shipping type and we can define the same as per business requirement, also it will be easy to monitor whether the material transfer by Road or Air.

OLML – Shipping - Basic Shipping Functions – Routes - Define Routes - Define Shipping Types.

We are using this Shipping Type is on of our key combination and we can set different prices based on shipping type through condition record.

OLML – Shipping - Basic Shipping Functions – Routes - Define Routes - Define Routes and Stages.

We can define the route and stages based on the distance where the vendor located and the transportation price will be differ based on the distance, we are using the route also on of our Key Combination in condition record.

OLML – Transportation – Shipments - Define Number Ranges for Shipments.

Set up new number ranges for Shipment document.

OLML – Transportation – Shipments - Shipments - Maintain Transportation Relevance - Maintain transportation relevance for delivery types.

Kindly activate the below check box then only the we can use delivery type "EL" for transportation process.

OLML – Transportation – Shipments - Maintain Transportation Relevance - Maintain transportation relevance for delivery item types.

Kindly activate the relevant Item category for the delivery type "EL" for transportation process.

OLML – Transportation – Shipments - Define Number Ranges for Shipments - Maintain Transportation Relevance - Maintain transportation relevance for routes.

The activation has to be done for relevant route then only the route can be used for shipment.

OLML – Transportation – Shipments - Define Shipment Types.

Shipment Type having various control for transportation process like Output determination procedure, number ranges etc... Below proposal screen we are using the weight unit is "KG" since we are calculating the transportation cost on KG basis.

OLML – Transportation – Shipments - Configuration of Transportation Processing for Forwarding Agents.

This configuration mainly using to identify the service agent who are involving into freight forwarding process, we are using this forward agent also on of our key combination in condition record.

In second screen you can come to know the assignment process of Transportation planning point with shipment type, when ever we use the transportation planning "CH" system will consider the shipment type "0010 Inbound shipment".

Shipment Cost:

OLML – Transportation - Shipment Costs - Shipment Cost Document - Define Number Ranges for Shipment Costs.

Here we can define own number ranges for shipment costs, when creating a shipment cost document, a unique number is generated as per this configuration.

OLML – Transportation - Shipment Costs - Shipment Cost Document - Shipment Cost Types and Item Categories.

Here we can define the shipment cost types and item categories that contain all important control features for the shipment cost document and also we can assign the valuation class makes it possible to post the values of services of the same service category to different accounts.

OLML – Transportation - Shipment Costs - Shipment Cost Document - Shipment Cost Relevance and Default for Shipment Cost Type.

Here we can assign the shipment cost types to the shipment types and set an indicator to show whether the cost type is relevant to shipment costing, this setting has to be done for every cost type in every shipment type.

OLML – Transportation - Shipment Costs – Pricing - Pricing Control - Define Price Dependencies (Condition Tables)

A table where the key fields are data combinations for which messages are triggered and there is a condition record for each data combination, here we craeted table by using the Service Agent, Shipment type and Route as a key combination.

OLML – Transportation - Shipment Costs – Pricing - Pricing Control - Define Condition Types.

Since we are looking this process to calculate transportation cost for Weight basis, here we have taken standard Condition type FB00 is using for Gross weight.

In second screen you can see the calculation base "A- Delivery" if it is A then the total weight will be consider from delivery header level.

OLML – Transportation - Shipment Costs – Pricing - Pricing Control - Define Access Sequences.

As you aware an access sequence is a search strategy which uses to search for condition records valid for a condition type, here we have taken MAKT and the table assign to the same.

OLML – Transportation - Shipment Costs – Pricing - Pricing Control - Define And Assign Pricing Procedures - Maintain pricing procedure.

We can set the pricing procedure as per the requirement by using above condition type.

OLML – Transportation - Shipment Costs – Pricing - Pricing Control - Define And Assign Pricing Procedures - Define pricing procedure determination for shipment costs.

All the shipment is allocated to a transportation planning point for transportation planning. It helps to determine responsibility for transportation processing during which it can be used as a selection criterion, in order to create a list of shipments to be processed, say for example one planing point can be used for Road and another for Air like wise.

Finally all Item determination procedure group, service agent procedure group and shipping type procedure group which has been done above configuration need to be assign with Pricing procedure. 

OLML – Transportation - Shipment Costs – Settlement - Assign Purchasing Data.

Finally we need to assign the Transportation planning point with shipment cost type, purchase organisation, purchasing group and plant for auto purchase order creation.