STO: Freight cost loaded on material cost

[Former Member]

Hello, I want to integrate shipment cost to my material cost (Moving average cost)

What is the simpliest way to achieve this in this scenario:

1. Multiple PO exist for a specific delivery date for a STO from A-->B

    2.Multiple deliveries are created

    3. 1 shipment is created and deliveries are included in the shipment.

    4. PGI is done from the shipment.

    5. MIGO for all the PO’s of the shipment have to be done

…

Note: If my freight cost is 3000$ for route A-->B,

I want this cost distributed among all items of the shipment based on their weight…

If possible MIRO process should be as simple as possible…

Please let me know what are my options..

Thanks!

PS: I know the process of shipment cost (using VI01) distributed against blank PO conditions, but it will creates a lot of different accruals to reconciliate using MIRO and I'm trying to avoid this...

[Former Member]

If your query has been resolved then please close the thread.

[Former Member]

I'm still trying to make it work...

Good news: I was able to create the shipment cost and to dispatch it to the item!

But I’m not able to dispatch freight cost based on scale, and MIRO step is very painfull

What was done.

Define the MM conditions:

1. 1. M/06: define condition ZRB1
   1. a. Cond. class   A Discount or surcharge
   2. b. Calculat.type B Fixed amount
   3. c. Cond.category B Delivery costs
   4. d. Tick: acruals
   5. e. Tick: Copy shipment cost
2. 2. M/08: Include it in the PO Schema (ZM2000)
   1. a. With accrual keys…

Define the Shipment cost conditions (as described in your post)

1. 1. Define Condition type FB20
2. 2. Define pricing procedure with condition type FB20
   1. Requirement : 51 (V_T683S-KOBED)
   2. Condition formula : 90 (V_T683S-KOFRM)
   3. Alternative formula: 13 (V_T683S-KOFRA)

I create a Shipment with 3 deliveries from 2 POs (POs with condition ZRB1 included),

Then, before PGI, I created shipment cost at header in VI01 against the shipment #1 for a value of 10 000$.

I did the PGI

The freight distribution didn’t happened based on weight as desired...

Shipment #	PO#	Item	Qty	Delivery	Net Weight	Gross weight	Freight
1	PO # 1	A	1	85000528	63	100	11,11%
1	PO # 1	B	1	85000525	126	150	22,22%
1	PO # 2	C	1	85000526	252	300	66,66%

Freight distribution should have been:

Item A = 100 / (100+150+300)

Item B = 150 / (100+150+300)

Item C = 300 / (100+150+300)

Then in MIRO, when receiving the carrier invoice, I have to enter all POs to cancel accruals.  Is there a simplier way to handle MIRO?

Let say I have 50 POs in my STO shipment, it’s a pain to cancel all accruals?  And if there’s price difference, it’s not that easy…

1. 1- Please let me know my options for freight dispatch per item weight
2. 2- Please let me know my option of easy MIRO invoice capture…

Many thanks!

[Former Member]

Hi,

Have you tried scale basis config in define condition type?

Here select your condition type & click on scales for condition types.

Also, are you trying to create automatic PO in shipment for service agent?

[Former Member]

Hello Syed,

Thanks for your help!

I've defined scale basis = D (gross weight) for condition type in PO ZRB1 (M/06) AND for shipment cost condition type FB20 and no success, I keep the same proportions.

FYI:  When doing the same process with only 1 PO with 2 items; the scale distribution works, but with net weight even if there are no place in the config where it's define tin net weight... (only gross weight).

Is there something special that need to be done when there are multiple PO (deliveries) in the same shipment?

Thanks!

Should I start looking for User-exits?

[Former Member]

Hi Luc,

I never tried for multiple PO's. But if your service agent is same for all the multiple PO's then in that case, you can create MIRO with respect to service transportation agent. This will somehow reduce your extra efforts for multiple PO's.

Also, you have defined scale basis=D for gross weight, if you need net weight try Scale Basis=E.

Regards,

Arsh

[Former Member]

Hello Luc,

As i understand, the only way you can transfer your freight charges to material price is through VI01 in that freight condition that you are using should have config on scales basis on quantity & its UOM as required. Also in transportation pricing procedure you have maintain call type as 90 to transfer freight charges to material

SPRO->LE->Transportation-.>Pricing->Pricing Control->Define condition type

[Former Member]

Hello,

I haven't find this option the the condition type definition:"maintain call type as 90 to transfer freight charges to material"

can you explain more in details?

Thanks!

[Former Member]

Hi,

     You have to maintain condition type's scale basis as per your requirement in define condition type,

After that you have to assign that condition in pricing procedure

(Define & Assign pricing procedure-> maintain pricing procedure)

[BijayKumarBarik]

Hi,

in STO process, the material posted with valuation  price from supplying plant and if you have freight cost- you can have freight condition type in STO( keep this condition type in your STO MM pricing procedure and assign account key ZFF) and capture the freight cost to separate G/L account( OBYC with a transaction key-ZFF)

Regards,

Biju K

[Former Member]

Hello Biju, thanks for your answer,

If I have multiples POs in the shipment, the MM pricing procedure would be blank at PO creation? Meaning no accuals?

When capturing the transporter invoice in MIRO, would we be able to track against which accruals/ shipment it goes?

Thanks for your time!

Luc

[BijayKumarBarik]

Hi,

I am not sure how your business agree and following above said process where during PO(STO) creation- no freight cost  but you are paying freight cost to freight vendor in MIRO screen. Now where and how freight vendor recognized by system as in STO you have supplying plant as vendor and receiving plant as customer!

Better have a new STO pricing procedure and have a freight condition type in it. Activate condition TAB in STO in item details. Refer for more

Regards,

Biju K