Solved: ICR Proces 003 Functionality

SAP Managed Tags
SAP ERP
FIN (Finance)

Hi friends

Recently I m cuztomizing SEM BCS for financial statement consolidated, from some years ago in version SAP R/3 4.6c, the transaction code F.2E was used to, butin version 5.0 and 6.0 this funcionality there isnt, now Intercompany Reconciliation is used,

any of yours have implemented this functionality, I have read the notes about this topic and I dont understand verywell how to do this

Is necesary configured all process, 01, 02, 03

is necesary use a special ledger , the new functionality mentioned that I can do reconciliation fron sistem No SAP and SAP old versions like 4.6c, 4.7 etc

I have version 6.0 and I want to do reconciliation beetwen Trading partner, one trading partner was in another client, Ineed to do RFC`s, IDOC`s???

Best regards

thanks in advance

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

We are going through a technical upgrade from R/3 4.7 to ECC6.0 and we are experiencing problems with this process as well. I see mentioned a Tcode called FBICC but when I try to run that transaction, I get the message that it does not exist.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello Sherry,

Please note step #1 in my post in this thread from Jul 31, 2008 10:50 PM. You first need to install a couple of notes. One of them will create transaction FBICC.

Best regards,

Ralph

Thanks so much for your reply. We got the notes applied and I was able to run FBICC successfully.

However, now I am trying to run FBICS3 and I get a syntax error:

in program /1BCDWBEN/SAPLFEN009:

Type CI_DFKKREP06 is unknown

Have you seen this before?

Thanks.

Sherry

Hello Sherry,

Go to transaction SE11, specify table DFKKREP07 and choose function activate. This will generate some coding which will probably fix the syntax error.

Best regards,

Ralph

You are TOO smart for words. Thanks a bunch. That took care of that problem.

Sherry

Hopefully we will soon get this function behind us. I got all the config done and the programs are running without errors. However, no documents are being selected. Does anyone have documentation for end users trying to run this transaction?

Thanks so much,

Sherry

We are not getting any records when we try to run the Intercompany reconciliation. I think the problem may be that in FBIC032 there is no RFC Connection set up for each company. How do I determine what those settings should be? (Column 2 and 3 in the FBIC032 screen)

Thanks for any help.

Sherry

Ralph

You have been so helpful.

I have another question. I am trying to update FBIC010. I only want to use Process 003, but it requires me to fill in Group COA and Sender Ledger for 001. Then when I try to save my changes, I get the message:

Ledger 0L is not a valid send ledger

I have not entered 0L anywhere.

Where is it getting this from?

Thanks SO much.

Sherry

Edited by: Sherry Patterson on Oct 27, 2008 5:16 PM

Hello Sherry,

Please refer to the documentation attached to note 1164059 ( https://service.sap.com/sap/support/notes/1164059 ). The first part also describes the program runs. Did you execute data selection and automatic assignment? Automatic assignment must be performed before you can see the data in interactive reconciliation.

Ralph

Hello Sherry,

If the company codes are assigned to the companies you set up in FBIC032 and these company codes are productive on the same system which you are running data selection in you do not need to set up any RFC destinations. If the company codes are productive on a different system you need to get your basis experts to set up the RFC connections in SM59.

Best regards,

Ralph

Hello Sherry,

The sender ledger should not be a required field for process 001. At any rate, just specify ledger I1. This ledger probably does not exist and you will get a corresponding message. But you can ignore this message as long as you are not using process 001.

Best regards,

Ralph

Hi Ralph

The message says the 0L ledger is not valid for Process 003

Not sure where it is getting that.

Thanks for all your help.

Sherry

You have specified ledger 0L as sender ledger for process 003. For process 003 the sender ledger must use totals table FBICRC003T. Ledger 0L uses totals table FAGLFLEXT.

This is the message I get. It looks like it thinks I have specified 0L for 003, but I have not entered anything into Sender Ledger.

Thanks

Hello Sherry,

For process 001 please enter receiving ledger I1. For process 003 please enter receiving ledger I3.

Please have a look at thread as well. I explained there what the whole ledger deal is about.

Best regards,

Ralph

Hi Ralph

Thanks for your reply. I did read the thread you spoke of, but it does not tell me where the reference to 0L as the sender ledger for process 003 is coming from. I know it must be assigned somewhere, but I cannot find it. I have looked at all of the config I can think of and cannot find it. I understand that we don't have to have I1 or I2 or I3, etc. set up, but that we may want to use them later and I appreciate your clarifying that.

We are all learning as we go through this technical upgrade. We had been told that there would be no program changes, but we are finding out that is not the case.

Thanks for all of the input you have given. If we can just get this intercompany rec to work, we'll be all set.

Regards,

Sherry

Hello Sherry,

Did you apply note 1159776 and related notes yet? Also, did you apply note 1161993? Is the message an error message of an information message?

When you ran FBICC it specified 0L to be the sender ledger for processes 001 and 003. But if you did not apply above notes yet you may not see this information or you may not be able to change it.

Best regards,

Ralph

Hi Ralph

I checked with our Basis team and they said these notes have not been applied (1159776 and 1161993) but they will get them applied. When I am allowed to change the sender ledger for process 003, am I correct that I can put I3 or some other ledger number in the Sender Ledger field?

The message I get is a hard error message that will not allow me to save the data in the screen. I had tried to put I1 in the Receiver ledger for Process 001 and I had tried to change the Fiscal Year variant used by Process 003, but I could not save the changes due to the error message.

I have a list of notes that pertain to this process....863630, 1062292, 1172591, 1159776, and 1161993. Are there others that I need? I am going to go back again and look through your threads to see if I can locate any others we need.

Thanks so much.,

Sherry

Hello Sherry,

In that case applying these notes will probably let you make the necessary changes.

Please specify a sender ledger only if you want to read data from newGL. In that case you should specify your leading ledger. Otherwise just delete the leading ledger info. You should specify I3 as receiving ledger (unless you created a different one to be used for ICR).

The list of notes looks good. Please check note https://service.sap.com/sap/support/notes/1267185 for additional ones (mainly 1238735).

Best regards,

Ralph

Thanks so much. I believe we are off and running now.

Sherry

Ralph

I have another question....we thought we had it, but one little issue popped up and I have searched through all the notes but have been unable to find an answer.

On the FBICR3 scree, there is supposed to be a 'Further Settings' tab that allows us to enter Display Currency, but that is not showing up. Is this an authorization issue or something like that?

Thanks so much.

Sherry

Hello Sherry,

Check FBIC010. You probably have Hide Display Currency from Selection Screen checked. If you want users to be able to specify different values just uncheck this flag.

Best regards,

Ralph

Thanks, Ralph. That took care of it.

Sherry

Display Categories Open Items and Payables contain some of the same data records

Message no. FB_RC017

Diagnosis

Due to the definition of display categories Open Items and Payables some of the selected data records are contained in both display categories. This will also affect the calculated total amounts.

System Response

Warning

Procedure

Keep in mind that some of the data records will be displayed in both display categories.

*I am getting this warning message when running FBICR3. I suspect it is because we have run the test so many times. Am I correct, and is there any way to get this to go away? I tried finding info on the message but was unsuccessful.*

*Thanks.*

*Sherry*

Hello Sherry,

This message simply lets you know that the grand total of differences displayed is not the actual grand total of differences on the business partner level.

Your display may look like this:


C1000              10.000
  C2000            10.000
    Payables       10.000-
    Receivables    15.000
    Open Items      5.000

The total difference for C1000 with C2000 is shown as 10.000. However, there are only open items for 5.000. You have the display set up to show payables and receivables separately and then also both of them included in open items. Basically you are including each open item twice. The message simply lets you know that this is the case.

If you were to exclude object group Open Items on the selection screen then the message would not be shown and your display would look like this:


C1000               5.000
  C2000             5.000
    Payables       10.000-
    Receivables    15.000

You could also restrict the display to object group Open Items. In that case the message would also not be displayed and you would see the following result:


C1000               5.000
  C2000             5.000
    Open Items      5.000

Best regards,

Ralph

Hi Ralph

Thanks for the response. We tried both excluding open items and selecting AP and AR. However, the message still appeared. Do I need to reset something in config or delete some transaction data or something?

Thanks.

Sherry

Hello Sherry,

This does not have anything to do with your data. It is purely a matter of configuration. Please compare the setup of your display categories / object groups to the documentation attached to note https://service.sap.com/sap/support/notes/1164059

Best regards,

Ralph

Thanks, I have read this and it is very helpful.. I believe we'll finally get this working properly.

Thanks for your help.

Hey Ralph

Do you know if these configuration settings are transportable? We moved from our DEV client to QAS, but the settings did not come over. It thinks Process 003 is not active again.

Thanks.

Sherry

Hello Sherry,

All relevant customizing settings are transportable. However, when you import the transport requests from note 863630 after having transported the customizing settings then the process will be set to inactive again. Just retransport that setting from your DEV to QAS. If the setting in QAS is already that the process is active you have not yet run FBIC004 in QAS. This is not done automatically when importing the customizing settings since it does generate the posting framework also used for FI postings. I did not want to risk update cancellations in FI because ICR customizing is transported.

Best regards,

Ralph

OK, thanks for the explanation.

Sherry

Hey Ralph

I just wanted you to know that yesterday we had our first test of the Intercompany Reconciliation and it was successful. Thanks SO much for all of your help.

Sherry

Hello Sherry,

Great News!!! I am glad we were able to get you there

Ralph

Hello Ralph,

i am implementing the new solution ICRC in my french customer for version ECC6.

i tried to add the field BVORG through the customizing point FBIC006 ("create additionnal field") for process 001.

i activated the transaction data tables (FBIC004). The result is that my field BVORG appears in my field catalogs. the status of field BVORG is "subassignment".

When processing FBICA1, the value field BVORG is not alimented when i checked the table FBICRC001A. Do you have a solution for my problem ?

my need is to use the field BVORG in automatic assignment.

Thanks a lot

Nicolas

Hi Ralph

We moved everything to Production last night and we are not having many problems. However, the FBICA3 is not automatically assigning any records. I have checked config and everything looks ok on the surface. Any idea what may be causing this? It worked in DEV and QAS.

Thanks.

Sherry

Hello Sherry,

Please check your settings regarding the number range for assignment numbers in your productive system (transaction FBICRC_SNRO). Number ranges are not transported automatically.

HTH,

Ralph

Hi Ralph

Yes, I added the number range during cutover as I knew it would not transport, and I just verified it is there. It is actually being incremented already so I know it is being found.

It is weird. This worked so beautifully during DEV and QAS testing.

I don't have to activate any tables or anything do I?

I will keep looking.

Thanks.

Sherry

Hello Sherry,

From your description it sounds like FBICS3 works just fine. I.e. FBICRC003A does contain some entries with RTYPE = SPACE. Then you run FBICA3 and the number range is updated but no entries are added to FBICRC003A with RTYPE = 1 or 2. Is that correct? What do the logs for FBICS3 and FBICA3 tell you?

Ralph

I have a Success message in FBICS3. 347 data records were selected. No new data records were transferred.

In FBICA3, I have 388 data records analyzed. 388 Resulting unassigned company data records, 388 resulting unassigned partner data records, 0 resulting assigned data records.

Hello Sherry,

OK - now we are getting closer. So you can see the unassigned items in FBICR3, correct?

If you added any fields to your process you definitely have to run FBIC004 before these can be posted to. If your rules are based on such fields that would be an explanation for not assigning anything automatically.

If you did not add any fields or you are not using them in your automatic rules You should have a look at the data records in FBICR3. Check whether the fields you are using in your rules are populated correctly. If you have to add them to your layout please note that when you have the popup with the field lists you can use the context menu (right mouse button click) to display the technical field names. When they are displayed you can also search for the technical field names. Might be easier to find them that way

Ralph

Hi Ralph

We did not add any fields so that should not be a problem. The only rule we are using during auto assignment if the Refnr = Refnr, standard SAP SAP0050 rule.

Sherry

Hello Sherry,

Is field REFNR populated correctly? Are there any entries that match based on REFNR? You could create a copy of the auto assignment rule and delete the checkbox for auto assignment. Then you could simply run the rule to suggest assignments in FBICR3.

Ralph

OK, I will try creating another rule based on REFNR. It's just weird, though, because it worked in QAS.

Thanks.

Sherry

Hi Ralph

I tried copying the REFNR rule and using it manually. Nothing matched, so I think some changes must have been made to how they are populating REFNR. That is possible because they added some new SD functionality.

What do people normally match on for auto assignment?

Thanks.

Sherry

Hello Sherry,

Most customers use XBLNR as a sender field for REFNR. This is the field you specify in FBIC032 on the company level. Other options are ZUONR, SGTXT, XREF*, ...

When SD integration is involved it really would make sense to have one of the fields filled automatically in the outgoing document. Obviously this information has to be printed on the invoice so the partner can post it.

Best regards,

Ralph

Hello Ralph,

I've just set up the intercompany reconciliation with the help of this thread and the mentioned OSS-notes.

Also I've implemented the needed notes for the correction of existing errors.

But I'm now facing a problem when executing transaction FBICS3 for the document selection.

In test mode everything is working fine and the expected document I've posted before with the correct trading partner is selected. But when I execute it in 'real'-mode I've getting a syntax error:

*************************************************************************************************

The current ABAP program "CL_FBICRC_SERVICES============CP" had to be

terminated because it has

come across a statement that unfortunately cannot be executed.

The following syntax error occurred in program "/1BCDWBEN/SAPLFEN0009 " in

include "/1BCDWBEN/LFEN0009$28 " in

line 5:

"Type "CI_DFKKREP06" is unknown"

*************************************************************************************************

Have I missed a manual task in the notes or is there another known problem?

Thanks.

Regards

Jan

Hello Jan,

Please see my earlier reply to this question in this thread (23 October 2008; 9:26 pm). This actually does not have anything to do with ICR. But since it affects the posting framework it can pop up when you are using ICR...

Best regards,

Ralph

Thanks Ralph,

it seems that I've just missed the mentioned entry. The activation of the mentioned structure was solving the problem.

All seems to be working fine now.

But I've still one general question.

In our system we have countries which are using the calendar year as fiscal year, also countries where it's shifted.

When I want to set up a reconcilation process in the future for both cases with correct fiscal year variants, is it enough to copy the reconciliation process 003 to e.g. 004 in FBRC007, to assign the different fiscal year variant to the new process in FBIC010 and also to assign the needed company codes to the new process in FBIC032?

Will this work without any problems?

Thanks.

Jan

Hello Jan,

You can reconcile all companies in process 003.

The fiscal year variant you specify in FBRC007 is used on combination with the year and period you specify on the selection screen to determine the key date for open item selection.

Example

In FBRC007 you specified K4 as fiscal year variant (calendar months). On the selection screen you specify year 2010, period 012. From this information the program determines the key date for open items to be 31 December 2010. Therefore it will look for items with posting date on or before 31 December 2010 and/or clearing date after 31 December 2010.

Depending on your companies' setup a document with posting date 30 December 2010 may have been posted to posting period 12/2010, 09/2010, 03/2011, or any other posting period. But the posting date will still be the same in any case. Therefore you can simply include all companies in FBIC032. There is nothing else you have to do.

If you added a new process in FBRC007 you would have to write your own programs to support this process. A lot of the ICR services are generic and can be reused independent of the process ID. But the actual programs are not that flexible.

Best regards,

Ralph

Hello Ralph,

We are upgrading from 4.7 to ECC 6.0 and we have EC-CS implemented in 4.7. In the upgraded ECC 6.0 environment, F.2E is disabled and we are migrating to ICR functionality.

As part of this we have completed the configuration and followed OSS notes 863630, 1062292, 1159776 and 1172591 and looked at the associated notes.

We are using Reconciliation Process 003 and set up companpanies in config using t. code FBIC032 and the customizing generated by FBICC. GL data is in ledger 0L and consolidation data is in consolidation ledger ZC. Sender ledger is 0L and receiving ledger is I3.

All the companies involved in consolidation are local to the existing system so no RFC connection should be required.However when we execute FBICS3 to collect all ICR documents from local system, I am getting following error

Company 001000/0000: RFC destination KRJ810: Ledger 0L not assigned

Message no. FB_ICRC116

Even when we assign RFC desitantion to ledger 0L using config FBIC032, it still gives the same error.

Please advise.

Hi,

for the process 003, you should use ledger "I3"...it will be configured automatically using the FBICC transaction for process 003. Later on you will still get the error messaghe "ledger does not exist" when accessing the configuration, but somehow the process will work.

FOR RALPH or anyone else -> I have one question regarding the FBICR3 transaction:

-> what is the use & difference when flagging the "add intercompany relationship without documents" & "display difference only"...somehow I do not see any difference when executing with or without the flags in the next screen. Data looks the same

Also why the "currency of document group" displayed as "DEM"...does it refer to german marks ?

Thansk for a hint

cheers

Stephane

Hello Kapil,

Even when selecting data from the local system RFCs are used in order to enable parallelization.

According to the message it seems that you did specify a RFC destination for company 001000. Otherwise the error message would mention RFC destination NONE.

You should not assign a sender ledger unless you want to select NewGL information (e.g. split customer/vendor lines). At the beginning of the data selection program some information on the sender system is checked. First of all a company code must be assigned to the company that data is supposed to be selected for. If a sender ledger is specified the program will check whether NewGL is active in the sender system. If it is all ledgers for the company code(s) derived from the company are retrieved and checked against the sender ledger. This can also lead to a situation where 2 company codes are assigned to the same company ID but only one of them actually works with the sender ledger...

I hope this helps you resolve the issue...

Ralph

Ask a Question

Top Q&A Solution Authors

User

Count

By Category

Related Content

Activity Groups

Industry Groups

Influence and Feedback Groups

Interest Groups

Location Groups

Customer Only Groups

Forums

Related Resources

Products

Learning and Support

About

My SAP Profile

My SAP Profile

Know the answer?

Need more details?