Unplanned delivery Cost Distribution

[Former Member]

Hi ,

I was trying to simulate the example given in SAP help fro Unplanned Delivery cost distribution among Invoice line Item ...

SAP help says,

If Config is set for "Distribution of unplanned delivery cost among Invoice line item" in IMG and

PO is created for

100 pcs @20/Pc for Mtrl A

100 pcs @10/Pc for Mtrl B

GR1

Goods receipt 50 pcs of mat. A

Invoice 1

50 pcs of mat. A @ $20.00/pc.= $1000.00

GR2

50 pcs of mat. A

80 pcs of mat. B

Invoice 2

50 pcs of mat. A @ $20.00/pc.= $1000

50 pcs of mat. B @ $10.00/pc.= $500

Unplanned delivery costs = $100

In such case , $100 of Unplanned delivery cost will be distribute considering both invoices and this cost will be loaded in inventory proportionality.

so in such case it will distribute like

(1000 + 1000) : 500 = 4:1

Therefore $80 will be distributed on MTRL A and 20 on B.

To Simulate , I created a PO with two line items of 100 pcs each, with price 20 and 10

Created GR for 1 line of 50 pcs and did the MIRO (without unplanned delivery cost)

Created another GR for 50 pcs of Item A and 50 pcs of Item B with unplanned Delivery Cost 100

But system is loading 100$ , considering the invoice 2 only and therefore loading 66.66 on mtrl A and 33.33 on Mtrl B.

Can u tell what I am doing wrong ?

Regards

Shrey

[Former Member]

Thx ..... I also had the same feeling but confused with SAP Help....

Giving below details of help

-

---

Purchase order

100 pieces material A

200 pieces material B

1st invoice for the purchase order

50 pieces material A at $ 10.00/piece = $ 500

50 pieces material B at $ 12.00/piece = $ 600

2nd invoice for the purchase order

20 pieces material A at $ 10.00/piece = $ 200

80 pieces material B at $ 10.00/piece = $ 800

Delivery costs = $ 90

The system divides up the delivery costs in the following ratio:

(500 + 200) : (600 + 800) = 700 : 1400 = 1 : 2.

Material A is debited for $ 30, material B for $ 60.

-

---

Therefore wondering ... do we need to hold all invoices if we are expecting UNPLANNED DELIVERY COST in the final invoice .... OR system will take care by considering all previous invocies created against that Purchase order.

Actually this SAP example doesn't say that we need to book all invoices together and i feel this is also not possible in actual business case.

Awaiting for your reply

Regards

Shrey

[Former Member]

You have Loaded the Delivery Cost 100 on the Total Qty of that Invoice that is 100+50=150

System will distribute the Delivery Cost for the Qty in that Invoice , It will not Consider the Qty of Already Posted Invoice..

If that is the case, You need to Post Invoice w.r.to GR1 & GR2 in Single Invoice..

The Distribution of Delivery Cost as Follows

Mat A 50+50 = 100

Mat B 50 = 50

Then Ratio will be 100:50 = 2:1

What System has proposed 66:33 is Correct

[Former Member]

Just for clarification

by Invoice 2 , I mean Considering only "Second Invoice" value

Regards

Shrey