MIRO - Unplanned delivery cost to impact material MAP and specific GL account

[Former Member]

Dear all,

We have the following business case for which we didn't find any solution yet.

We purchase materials valuated at moving average price (MAP) through purchase orders.

It happens that not freight costs when planned for a PO then no freight condition entered. But sometime, after the goods receipt we receive a freight invoice that we want to post against the PO to impact the material MAP and a freight GL account.

What we tried:

When we enter invoice in MIRO we recall only PO lines related to the material purchases, no freight line (because no accruals planned). Then if we use the unplanned delivery costs field it will impact the MAP but not the right GL account (Goods purchase account instead of a freight account).

If we change the customizing of Unplanned delivery costs field to post into a separate freight GL account then the material MAP is not impacted by those costs.

If we use the GL accounts tab in MIRO we will only post to GL account but not impact the MAP.

Do you have any idea on how to process that in SAP?

Thanks a lot.

[Former Member]

Hi,

Please check below link

SAP e-mory: SAP MIRO enter freight invoice

Hope it will solve your query.

Regards,

Arsh

[Former Member]

Hi,

Could you share the expected accounting postings? Because I think is not possible to update MAP/Expense + Freight Account for unplanned costs, in only one step, because of this in the configuration below you must choose if it will be posted to MAP or specific GL Account.

Try this configuration: IMG --> Materials Management --> Logistics Invoice Verification --> Incoming Invoice --> Configure How Unplanned Delivery Costs Are Posted

So please share the expected accouting postings with us. Thus we can analyze the possibilities.

BR.

Gian

[Former Member]

Hi,

Indeed that's my point when I say "If we change the customizing of Unplanned delivery costs field to post into a separate freight GL account then the material MAP is not impacted by those costs."

I did configuration: IMG --> Materials Management --> Logistics Invoice Verification --> Incoming Invoice --> Configure How Unplanned Delivery Costs Are Posted

Let's say we have a PO with one price condition for material price, no condition for freight.

When we post the GR and the goods invoice, the accounting postings go in account 60110000 PURCHASES - Raw Material.

Then if we receive an invoice for freight costs we would like to post it against the PO item to impact the material MAP but post to the following GL account 60110400 PURCH - RM TRANSPORT.

Through unplanned delivery costs we can either:

- Impact material MAP and GL account 60110000 PURCHASES - Raw Material

- Or post onto another GL account which would be 60110400 PURCH - RM TRANSPORT. Without MAP impact.

I hope it helps to understand.

BR,

Anthony

[Former Member]

Hi,

So I think to impact MAP (60110000) + Freight Account (601104000) at same time, is not possible in the standard system. In my point of view, unfortunately you will need to choose  if wants to impact the MAP or control in an separated account.

The main postings in standard system can be (for 100 USD freight):

- MAP

60110000 (MAP)                     100 USD

VENDOR                              -100 USD

- GL Account

601104000 (Freight)                 100 USD

VENDOR                               -100 USD

If you want to post in both, I think we have a missing account:

60110000 (MAP)                     100 USD

601104000 (Freight)                 100 USD

XXXXXXXX                               -100 USD --> this account is used in planned del.costs.

VENDOR                               -100 USD

Because of this I think is not possible. The only way is create additional accounting postings through BADI INVOICE_UPDATE for instance.

BR

Gian