ICR Proces 003 Functionality

[#1]

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

[former_member572578 · Accepted solution]

Hello Lucio,

Documentation regarding ICR is available as attachments to note 863630:

https://service.sap.com/sap/support/notes/863630

To get started I suggest you implement notes 863630 and 1062292 and look through the other available notes. Depending on which parts of the functionality you would like to use you may need additional corrections.

You should also implement note 1172591. This creates a program which will generate pretty much all the customizing settings you need - at least for initial testing. The default customizing will probably cover most if not all of your requirements. All you need to do then is set up RFC connections to the sender systems where the companies are posting their FI data and run the programs. Setting up standard ICR will not take you long. The only prerequisite for generating the customizing is that you have maintained company data in your system (transaction OX15).

Since you are familiar with F.2E I suggest that you set up process 003 as your new solution. With process 003 you will be able to cover the functionality of F.2E and you have additional options (e.g. import data from the additional client you mentioned; yes, you do need to set up a RFC connection for extracting this data with transaction SM59; there is no need to set up IDOCs).

If you would like to include GL open items into your reconciliation process you should set this up within process 003 and not set up process 001 separately - unless there is a business requirement for this. Process 002 is designed to help you with reconciliation of accounts without open item management - typically your P&L accounts.

Hope this helps,

Ralph

[Former Member · Accepted solution]

Hi Ralph

I saw that you are a guru in ICR, I have read your document about this, I dont know how to do this, there is not a guide for cuztomizing this functionality, can you help me with my business escenario, let me show

I have to reconciliate 70 trading partner in diferent clients, example

company a client x ECC 6.0

company b client x ECC 6.0

company c client y ECC 5.0

company d client z R/3 4.6c

my sistem for reconciliation is client x (6.0),

do I need create a Special Ledger in client y and client z ?

you say that I dont need a RFC for diferent systems, then How the system work with other SAP systems?

thaks in advance

cheers

[former_member572578 · Accepted solution]

Hello Lucio,

1. Please apply the corrections from note 863630, 1062292, 1159776, and 1172591 to your system x (ECC6.0) and y (ECC5.0). Please apply the corrections from note 789242 to system z (4.6C). Depending on your use of ICR additional corrections may be necessary. But for getting started the ones I mentioned should be sufficient.

2. In your central ICR system x (ECC6.0) you should make sure that all companies to be reconciled are set up in transaction OX15.

3. Run transaction FBICC, specify Reconciliation Process 003, deactivate Test Run and choose Execute. The program will ask you whether you want to include GL open items as well. If you have any companies that post their IC documents to GL accounts, you need to choose Yes. Otherwise choose No.

4. Start transaction FBIC031. The Inactive flag for FBICRC003A is probably checked. Uncheck this and save your changes.

5. Start transaction FBIC004. Deactivate Test Run and choose Execute. Please note that you should run this program only when nobody is trying to post FI documents in the system at that time since it will generate the posting framework. This might lead to canceled updates if someone is trying to post. For this reason the program will also not run automatically in the target system when you transport your settings. You have to start the program manually in each system of your system x landscape (development, test, production). Try to choose a time when no postings in FI will be made.

6. Go to transaction SM59 and create a RFC connection for system y and a RFC connection for system z. You should set up these RFC connections so the user and password are stored. That way data selection will be able to run automatically without logon screens.

7. If you want your users to be able to display the original FI documents in the original system you should create a second RFC connection for systems y and z. For these RFC connections you should not specify a user name. That way you ensure that if a user tries to display the original FI document they can only do this if they have a user with appropriate authorizations in the original system.

8. Go to transaction FBIC032. Transaction FBICC created an entry for each company from OX15. There will be two entries if you specified that you want to include GL open items. For each entry you need to specify the appropriate RFC connection from #6 in the column RFC Destination for Data Selection (the second column). If you want to specify the RFC connection from #7 in the first column (RFC Connection for Interactive Functions).

This completes the setup.

9. Start transaction FBICS3 in system x to collect all ICR documents from systems x, y, and z using the customizing you set up in FBIC032 (and the customizing generated by FBICC). Specify the year and period you would like to reconcile, deactivate Test Run and choose Execute.

10. Start transaction FBICA3. Deactivate Test Run and choose Execute.

11. For productive use you should set up #9 and #10 as two steps of a batch job to run at regular intervals.

12. Start transaction FBICR3. This is the only transaction that your users will usually execute themselves. For a demo of this transaction please review FI_EN_ICR_sim.zip attached to note 863630. This simulation was recorded for process 001 and is not quite up-to-date regarding a couple of minor details. But it does show the important points. Please download iTutor Software from https://websmp207.sap-ag.de/swdc (search for software iTutor).

You do not need to actually set up SL in any of your systems for process 003!

Hope this helps,

Ralph

[Former Member · Accepted solution]

very helpful answer a lot of thanks

let me understand very well

in my system sender z and y I dont have to do anything only in my system x create RFC`s for this, all settings are make in receiver.

I dont have to create a Special ledger all documents are stored in tables for ICR,

is it correct?

process 01 for GL open items

process 02 for Account

process 03 for receivables /payables open items

in proces 03 can I include process 01 too?

wich is the use "group number"?

thanks for your time Ralph

best regards

[former_member572578 · Accepted solution]

Hello Lucio,

Short answers:

1. You do not need to configure anything ICR specifix in y and z.

2. You make all the ICR specific settings in system x and also set up the RFCs there.

3. You do not need to create any Special Ledgers in any of the systems for process 001 or process 003.

4. You attributed the processes correctly.

5. Yes, you can include GL open items in process 003.

6. Group (reference) number (GRREF) is a technical field which contains the same number for all documents assigned to the same document group.

Long answers for some of the questions:

1. In y and z you do not have to configure anything ICR specific. However, you do need to apply the required corrections (containing the RFC function modules to extract the relevant data). You also need to check and make sure that all company codes that are productive there are assigned to the correct trading partner. Also you need to make sure that the customer and vendor accounts (and possibly GL accounts) have the correct trading partner assigned as well. You also need to set up user accounts to be used for RFCs.

4. Process 001 was originally designed for reconciliation of GL open items. Process 003 was originally designed for reconciliation of AR/AP open items. By now the only difference between the two processes is that process 001 uses table group FBICRC001 containing one field RACCT (account) and process 003 uses table group FBICRC003 containing fields RCUST (customer account) and RVEND (vendor account). GL open items can be included in process 003 by specifying data source Documents of other process in FBIC032. This is done automatically if you select Yes when running FBICC. If you do not implement any other logic the GL account number is stored in field RCUST in FBICRC003A/T (FBICRC003A is the line items table for table group FBICRC003 and FBICRC003T is the totals table).

6. In FBIC032 you specify a sender field for reference number. Per default the sender field is set to XBLNR which is the field that was used by F.2E. So during FBICS3 XBLNR is transferred for each document to the ICR system and stored in field REFNR of FBICRC003A. FBICA3 runs a rule which is set up as REFNR = REFNR. So this will assign all documents with the same REFNR (i.e. XBLNR) to the same document group. For this the same value is stored in field GRREF.

Best regards,

Ralph

[Former Member · Accepted solution]

Ralph thanks, your answers are very important for cuztomizing ICR in the company, because nobody knows about this

a last question?? in your experience what happend with the companies that dont have SAP, does load your documents with a flexible upload with a specific layout? this where do I see this configuration, is like RFC`s

best regards

[former_member572578 · Accepted solution]

Hello Lucio,

You are quite welcome

There are a lot of customers who implemented their own logic in a BADI to import external data into the process. Using standard upload means that there is usually user interaction involved and the users have to perform data selection themselves. Most customers try to avoid user interaction as much as possible and prefer to run data selection and data assignment as a purely central task which is scheduled at regular intervals. That way the users only run FBICR3.

If you want to use the standard upload functionality you specify data source File Upload in FBIC032 for the respective companies. I recommend that you do this on the detail screen (just double click on an entry on the overview screen). This activates a couple of additional fields. You can specify a Logical File Name. If this is specified the program will try to upload the corresponding file without user interaction from either the presentation server (if you marked this checkbox) or the application server. Please note the F1 help for Logical File Name regarding use of parameters. If you do not specify a Logical File Name or the specified file cannot be found the program will start a dialog to let you choose the file interactively.

The last thing you have to specify for file upload is the DDIC Structure to be used. Please note the F1 help for this field as well. If you want to use the standard upload functionality you need to make sure that the field names in the structure are the same as in FBICRC003A. An exception from this rule is some special processing for field Account Type (ATYPE) and Account (RACCT). However, this special processing is only possible for exactly those field names. If these fields exist in your upload structure the content of ATYPE will be evaluated. If ATYPE = C the account number will be moved to RCUST (customer account). If ATYPE = V the account number will be moved to RVEND (vendor account).

Please note my comments in thread as well.

If you want to minimize the manual interaction you could establish a process where the companies have to place the files on an application server according to a specific naming convention so you can use the logical file name. That way your users would not have to run FBICS3 themselves.

Here are some examples for solutions some customers implemented themselves:

o Send an email with an Excel attachment to an XI server. The XI server will parse the Excel file and call function module FB_ICRC_ADD_DATA_RFC.

o Develop a web UI where the user can upload a file. The data from the file will be stored in the SAP system temporarily. During data selection a BADI implementation is called which selects the data from the temporary storage and imports it into FBICS3.

You could also implement a logic in your BADI implementation to extract the data directly from the external source system. Also you could implement something in the external source system which will push the data into ICR using function module FB_ICRC_ADD_DATA_RFC.

Best regards,

Ralph

[Former Member · Accepted solution]

Ralph

thank you for your answers, do you know if are there any courses about ICR in SAP?

cheers

[former_member572578 · Accepted solution]

Hello Lucio,

There is no course for ICR in particular. The functionality will probably be mentioned in the new version of AC 205 Individual Account Closing.

Best regards,

Ralph

[Former Member · Accepted solution]

Hi Ralph,

I have a quick question. Do you know of a process that allows the clearing of IC balances?

Regards,

Tony

[former_member572578 · Accepted solution]

Hello Tony,

I am assuming you want to clear the items without posting any payments (payment run)? How are these IC services paid for?

Ralph

[Former Member · Accepted solution]

Hi Ralph,

I am customizing for the ICR functionality and applied notes 1239136, 1172591 and 1326171. When I try to change Chart of accounts from INT to our chart of accounts in customizing Tr code FBIC010- Reconciliation process attributes', I get the following message. I don;t see ledger 0L in any process as sender or receiver ledger so not sure how can I get rid of this error. Can you pl. let me know how can this error be removed? Also, I see leders I1, I2 and I3 populated by SAP note 1172591 so the question is: Do I need to do naything with these ledgers or just leave it as it is. We have all trading partners in one system only. I would really appreciate your response on this error so that I can proceed further on this.

Ledger 0L is not a valid sender ledger

Message no. FB_ICRC114

Diagnosis

You have specified ledger 0L as the sender ledger for process 001. For

process 001, the sender ledger must use totals table FBICRC001T. Ledger

0L uses totals table FAGLFLEXT.

System Response

Error message. Settings cannot be saved.

Procedure

Specify a ledger that uses totals table FBICRC001T.

Thanks and regards,

Pinky

[former_member572578 · Accepted solution]

Hello Pinky,

Please make sure to apply note 1159776 as well as the other notes referenced in note 1267185.

Best regards,

Ralph

[Former Member · Accepted solution]

Hello Ralph

We are in the process of finally moving this functionality to our Q systems for testing. There were one or two questions related to the process:

1) How does one schedule batch jobs for FBICS3 and FBICA3 as one would like to schedule them to run at month ends for the time R/3 system is open to post any entries. The variant does not seem to have any dynamic date variable to be able to run it for a period. Or was the assumption that it would have to be manually scheduled everytime.

2) Secondly we are greatly dependant on the reference field being populated which we can populate while posting cross company code documents but what do we do about cross company code distributions where the system automatically posts the FI entries without any refernce? Is there any way to get around that and default a reference field for that.

This is one of the most informative and useful posts in the SDN Forum and would once again thank you for your invaluable comments and contributions

Regards

Satpal

[former_member572578 · Accepted solution]

Hello Satpal,

Re #1) When maintaining variants you can use selection variables just like with any other program. ICR is also integrated with ScehduleManager / Closing Cockpit.

Re #2) You could create a substitution to fill the reference field.

Best regards,

Ralph

[NathanGenez · Accepted solution]

this is a great thread but has run it's course. let's start something new if necesary

[NathanGenez · Accepted solution]

Since Ralph is so nice to respond to these questions, please put "ICR" at the start of your subject line so that he (and others) can quickly find them.

[Former Member]

Hi Ralph

I have configured ICR 003 functionality, I run FBICR3 and got all unmatched documents list. I selected a document and click on "Document" icon, gives error message "Company : RFC destination : Error in RFC connection: Exception condition "NOT FOUND" raised.

The documents and reconciliation are done in single client/system. The settings in FBIC032 for RFC Destination and RFC Data Selection are sent as "NONE". NONE is pointed to SAP system.

Please can you help, what went wrong.

Thanks

Venkat

[former_member572578]

Hello Venkat,

Please check whether you can find a corresponding runtime error in ST22. Other than that this does not seem to be a known issue. You may have to create a service ticket. What release and Support Package are you on? Did you apply the notes refrenced in note 1267185?

Best regards,

Ralph

[SurDas399186]

Hello Ralph,

We are upgrading from 4.7 to ECC6. We use only one SAP instance and all data is "local" only. We have successfully implemented the new functionality following the steps you have mentioned for the earlier messages in this thread. Thank you for this great "thread". This is very informative.

We have a typical situation where we need to run F.2E too frequently (especially during close). In the new functionality, the data selection has become the critical step and it's consuming most of the time and resource. Since we are pulling data from local companies only, I wonder if there is a way to skip this step and make data available to F.2E automatically . In other words, we are looking at a real-time F.2E solution, similar to what we used to have in 4.7. Please advise if such a thing is possible in the new ICR.

Best Regards,

Venkat Dasigi

[former_member572578]

Hello Venkat,

I'm glad that the thread is serving its purpose 🐵

With ERP2005 EHP3 we delivered a new transaction FBICR3L which combines the steps of data selection, automatic assignment and interactive reconciliation. So basically you would habe the same process as with F.2E.

However, it surprises me that you're having issues with the runtime of data selection. Essentially this program performs the same data selection that F.2E used to with each program run. Only that with FBICR3 you can access the data much more effectively since it was "preselected" with FBICS3. So all in all it should reduce the impact on your system.

Could you give me some examples of the runtime of F.2E compared to FBICS3? I know that some customers schedule FBICS3 & FBICA3 to run several times a day when they are getting close to the closing date. Also, some customers established "power users" who are authorized to also run FBICS3 & FBICA3 as needed.

Best regards,

Ralph

[SurDas399186]

Hello Ralph,

Thank you so much for your quick response.

The data selection step (FBICS3) is taking almost 20 mins for us. It used to take 45 mins to 1 hour and after applying a OSS note (1279759) the performance of FBICS3 has improved. But this is still not real-time.

F.2E takes less than 10-15 secs. We tried the new t.code FBICR3L and this too takes about 10-15 mins on an average.

As I understand from your reply, the new functionality should not take more time than the earlier F.2E of 4.7 version. But that's not the case with us. Could that be a problem with our configuration? We activated all the 3 processes in our configuration. Are processes 001 and 002 relevant for F.2E functionality? If not, can we deactivate those 2? As mentioned earlier, all our data is in a single R/3 instance only.

Please advise.

Best Regards,

Venkat Dasigi

[former_member572578]

Hello Venkat,

It does not make a difference whether process 001 and 002 are active. What might make a difference is if you added GL open items to your reconciliation process. At any rate - I suggest that you create a service ticket so we can analyze this in more detail.

Best regards,

Ralph

[SurDas399186]

Hi Ralph,

Thank you for all your support. We did open a OSS message for this and here are the details (SAP OSS Message: 0000306910). We appreciate all your help in this regard.

Best Regards,

Venkat Dasigi

[Former Member]

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.

[former_member572578]

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

[Former Member]

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

[former_member572578]

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

[Former Member]

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

Sherry

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member572578]

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

[former_member572578]

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

[former_member572578]

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

[Former Member]

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

[Former Member]

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

[former_member572578]

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

[Former Member]

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

[former_member572578]

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

[Former Member]

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

[former_member572578]

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

[Former Member]

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

Sherry

[Former Member]

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

[former_member572578]

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

[Former Member]

Thanks, Ralph. That took care of it.

Sherry

[Former Member]

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*

[former_member572578]

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

[Former Member]

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

[former_member572578]

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

[Former Member]

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

Thanks for your help.

[Former Member]

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

[former_member572578]

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

[Former Member]

OK, thanks for the explanation.

Sherry

[Former Member]

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

[former_member572578]

Hello Sherry,

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

Ralph

[Former Member]

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

[Former Member]

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

[former_member572578]

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

[Former Member]

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

[former_member572578]

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

[Former Member]

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.

[former_member572578]

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

[Former Member]

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

[former_member572578]

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

[Former Member]

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

Thanks.

Sherry

[Former Member]

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

[former_member572578]

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

[Former Member]

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

[former_member572578]

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

[Former Member]

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

[former_member572578]

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

[Former Member]

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.

[Former Member]

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

[former_member572578]

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