Trading partner for Inter company elimination in BPC

[Former Member]

Dear All,

We are implementing BPC 10.1 and to facilitate the inter company elimination the trading partner functionality is being configured and implemented in ECC.

I have one query with regards to documents which have already being posted without trading partner during first 6 months when the trading partner was not live.

I read in one of the blog where it was suggested to reverse and repost the already posted documents.

I need to know whether the reversal need to be performed for FI documents only and that too open items.

The client wants to know what about the documents where 90% of the sales is between 2 cos(inter company related).

Is there any other alternative in BI/BPC for identifying/eliminating the already posted documents?

Thanks in advance for your advice and suggestions.

Regards,

VM

[Former Member]

VM,

We have also came across this situation during implementation and tackle it with two ways:-

1. By writing an ABAP logic for the field "Trading Partner" on the basis of "Business Area" in the extractor which loads the data into BI/BW from ECC.

2. Still if there are some cases which are not fits in case 1, we have created one input form for Elimination GL accounts with data set as I_None and eliminating in manually on the required data cut.

Regards

[Former Member]

Hi Thavamohan,

Thanks!!

I think the case I which you are referring ,the coding will be done at ECC level or BI with a start routine.

If you have any document relating to same can you please share the logic.

Thanks in advance.

Regards,

VM

[Eyal_Feiler]

Hi VM,

Another option is to create an input form in BPC and add the interco (trading partner) in another Datasource.  This way if the periods are already closed you don't have to modify the original data.

This is how we correct partial data supplied by source systems.

Regards,

Eyal

[Former Member]

Hi Eyal,

The solution as i understand is create input form and bring all the data on I_NONE and then identify the transactions and add the inter co transactions for those periods.

Do we need to do that month wise or YTD?

Thanks for your suggestions.

Thanks and Regards,

VM

[akos_beres]

VM,

Is the model periodic or YTD? Due to the difference on how the data is saved in each model type, that will drive the input. The periodic is pretty straightforward and with a YTD model, there are basically two options. Depending if the issue needs to be fixed on a monthly level or just all at once. The prior will require monthly entries, the latter on lump-sum entry.

Hope this helps!

Akos

[Former Member]

Hi Akos,

The model is YTD.

The requirement of client is to have the historical data in FI without trading partner to be fixed when going live so that the elimination and balances at top level for financial statements in BPC matches with the balances they have after eliminating in excel.

Thanks and Regards,

VM

[former_member225135]

Hi VM,

There are 2 ways of doing this:

1. You pass rectification entry in ECC only for every line items for which you require trading partner (be it FI document or open line items)

2. You can upload the correction entries in BW/BPC. (here also you will have to manually find the entries without trading partner)

I would suggest to go for 1st option only.

Regards,

Rahul

[Former Member]

Hi Rahul,

Thanks for your prompt reply.

When you say the reversal and repost is to be done for all the FI documents or open items what needs to be done for documents for which billing document are created from sales order.

For eg. if sales order is created between 2 cos and billing doc is created will only FI will be reversed and only open items?

What about items which have been cleared?

Please suggest as the same needs to be advised to FI support team member.

Thanks for your help.

Regards,

VM

[former_member225135]

Hi VM,

Rectification will only be required for FI entries. Because you will need only FI data from ECc for legal consolidation.

And it the items are cleared, then there will no need to pass rectification entry.

Regards,

Rahul

[Former Member]

Hi Rahul,

Thanks for your suggestion.

If FI entries are reversed and reposted with trading partner will there be any impact on other modules like CO.The reason I am asking is the FI period may be closed?

Do we need to open the periods in respective modules or it is only FI module?

Please guide .

Thanks and Regards,

VM

[former_member225135]

Hi VM,

Sorry for the late reply,

It would require to open closed period in FI if you want correction to be passed in source system.

This is what you can do:

1. Create all entries which will require updation inter company in ECC

2. Ask your ECC team to have a black out period to update the entries,as the uploading of entry will not require more time

Regards,

Rahul