Miro-automatic distriubute delivery cost to each line items

[Former Member]

Hi SAP experts,

I am facing a customer requirement about invoice in MM (t-code Miro)

1. Create PO2 with 2 line items:

Line 1, Material A, plant A: 20 L15

Line 1, Material B, plant B: 80 L15

- In header, enter total estimated freight cost (condition type freight cost): 1000 USD

System automatic distributes freight cost to each line item ->

freight cost for line 1: 200 USD

freight cost for line 1: 800 USD

2. Good receipt for PO2

3. Enter Freight Invoice

Total amount in the invoice is: 1200 USD

How to have system distribute total amount for each line in the invoice the same with the way it done in the PO2 above?

Does anyone have any idea about this issue? Please share for me!

Any help would be highly appreciated.

Thank you very much,

Huyen

[Former Member]

hi,

try to reassign the G/L of line item in PRD through OBYC settings. so that difference will post to that account & balance will zero

Hope it will useful

regards

ronny

[Former Member]

in MIRO Planned delivery cost are taken as separate line item and will be posted to the clearing account.

If you want to distrbute to Material account then you have to use Unplanned dlievery cost that you can enter in Invoice header

in the details tab. You need to configure this under LIV>Incoming invoice>Configure Unplanned del cost. Default setting will distrbute the amoun to the line items.

Refer SAP Note 129066

Edited by: Karthik on Aug 11, 2011 10:59 AM

[Former Member]

Hi,

Thanks for your quick reply

I checked Unplanned delivery cost.

I remain the Default setting, it means system will distribute the amount to the line items.

But I can not see that. The step i do is:

In Miro screen,

1. Test 1st

- Enter PO reference -> system auto populates 2 line items in the PO

- Field "amount" in the header: enter the total estimated amount

- Field "Unpl. Del. Csts": enter the diff between estimated amount and actual amount

2. Test 2nd

- Enter PO reference -> system auto populates 2 line items in the PO

- Field "amount" in the header: enter the actual amount

- Field "Unpl. Del. Csts": enter the diff between estimated amount and actual amount

In both case, system issues an error: u201CBalance not zero", and i can not post the document -> system does not distribute the difference to each line item as support?

Did I miss what step?

Thanks,

Huyen

[Former Member]

you can find plenty of sap note on balance not zero message else raise message to SAP

[Former Member]

In my System it is working fine. Check the Balance field on the top Still it is showing some balance or 0.

Check by clicking simulate button and let me know.

Check SAP Note 429073

[Former Member]

Hi,

{2. Test 2nd

- Enter PO reference -> system auto populates 2 line items in the PO

- Field "amount" in the header: enter the actual amount

- Field "Unpl. Del. Csts": enter the diff between estimated amount and actual amount"}

For the case above, document display zero balance - green button.

But when clicking "simulate button" accounting entry as:

+Debit Account payable: Actual amount

Credit GRIR: estimated amount of line item 1

Credit difference (PRD): zero

Credit GRIR: estimated amount of line item 2

Credit difference (PRD): zero+

*Total Debit: estimated amount

Total Credit: actual amount

Balance: diff between estimated amount and actual amount*

Then when clicking "post" buttton: system issue an information: "Balance is not equal to zero" and not allow to post document.

System does not distribute the diff amount for each line.

Do you thing the note Note 429073 is the suitable note for my issue?

Thank so much for your help,

Huyen

In my System it is working fine. Check the Balance field on the top Still it is showing some balance or 0.

Check by clicking simulate button and let me know.

Check SAP Note 429073

[Former Member]

Few more SAP notes relevant to Unplanned delivery cost distribution. You have to test it which one is suitable for your system.

SAP Note 863647, 457967 & 129066