How can we integrate the feature ‘Group reporting IPI’ into version 2020 of Group Reporting?

[calfier7]

Hi all,

We had the Group reporting’s version 2020 on S4HANA on premise.

In order to develop the elimination of intercompany profit in inventory, we need the new feature ‘Group reporting IPI’ that is available on Q4 2021 release (on premise)

Do you know how can we integrate this new feature in our version 2020 of Group Reporting?

Thanks in advance for your support.

Ciao Chiara

[JAnnapureddy]

Hello chiaraalfieri,

If your customer implemented the Material ledger and has separate ledger ML postings, then you can use the custom reclassification methods to post the IPI entries in an automated way. This design requires the GRDC platform to bring the data for Group Inventory from Universal Journal.

• Margin-free Inventory ( Inventory STAT FS Items)
• Inventory with Margin ( Actual Inventory Account)
• The diff. will be posted into Inventory and COGS

example: Margin Free Inventory $100, Inventory with Margin $120. The diff. $20 will be offset into the Original Inventory account and COGS at the same time.

We will share few examples and design approaches via blogs. sap.com asap.

Best Regards,

J.A

[S0023624120]

I have a question, are we able to upload negative margin and Group reporting can calculate based on negative margin?

[Arleigh]

Hi Chiara,

Check out GR blog postings at https://blogs.sap.com/?p=1091480.

There are some 2021 features that are available in 2020 via FP1 but IPI doesn't appear to be one of those. But check with support or check on other Feature packs for 2020 to see if it was included. If not then the customer will have to upgrade to S/4HANA 2021 to get this feature.

Also be aware IPI is a complex topic. The IPI feature that came with S/4HANA GR 2021 is an "estimate". you enter a statistical entry in GR for the value in Inventory and a statistical entry for the % of profit and it calculates a Elimination that's an estimate. This works well for customers who do not have material ledger and transfer pricing.

But for customers who want exact IPI the 1st part of this is being released in S/4HANA 2022 coming out in Q4. But this is for brand new green field S/4HANA Customers only. Hopefully by S/4HANA 2023 they will have conversion routines so existing and brownfield customers can take advantage of this new capabillity.

There will be ALLOT of information on the Value Chain Analysis that's part of S/4 in 2022 coming in the next couple of months. But again it's only for brand new start from scratch implementations at this time.

Hope this helps.

Arleigh