Filter Planned Delivery Cost MIRO

[Thorben_Hald]

Hi all

I have a customer requirements that I cant find a good solution for.

It is regarding planned delivery costs. The customer maintains freight and customs on purchase inforecord level.

Each time a purchase order is created the conditions are copied to the order lines.

The conditions post an accrual during goods receipt to a GR/IR account.

This is offset through MIRO when the freight and customs invoices are received.

This is all standard.

My issue is how to handle the following scenario:

The freight and customs invoices cover many PO's - and thus many PO lines.

The customer makes an effort and identifies the PO's related to the freight and customs invoices, so they do actually post the invoice against each purchase order.

However my issue is that when they have found the PO's and they bring the planned delivery cost lines up - SAP correctly shows two lines for each PO line - a freight line and a customs line.

How can I easily filter or otherwise provide the customer with an easy way of selecting freight lines and customs lines separately? The freight and customs come on two different invoices, but MIRO will show both in the same screen.

I do not want to maintain vendor numbers on freight and customs condition level in the purchase inforecords.

Are there any options where I can set a filter through SDH0 for example or somehow create a layout the customer can use to filter out freight and then thereafter customs?

Thanks

[former_member183424]

As freight and custom both condition types are designed quite same (as delivery cost), so system can't able to segregate these charges in MIRO line item.

You can able to see both condition type and description in MIRO line item :

By this, you can segregate between freight cost and custom cost. When you will be doing invoice for freight cost, then only select line items for freight condition type (you can use sort ascending and descending for this condition type or description).

[Thorben_Hald]

Hi

Thanks for the answer - yes this I know:)

I was searching for an option where the user does not have to manually mark all lines regarding freight.

[former_member183424]

User has to do something, otherwise how can system know that you are going to post invoice for freight or custom ?

If you have your own criteria, then you can map this in badi. You can find appropriate badi in this OSS note 1156325 - BAdIs in the Logistics Invoice Verification environment

[Former Member]

Hi,

Check in MIR5 report...it may help you if the Invoice document for freight and custom are different.