ICR process for Open item recon.(003) - Report Display issue

[Former Member]

Hi All,

I am facing a problem in the data reconciliation report display.The document number "1212121212" doesn't not exist in the SAP system.But "1212121212" is used as the reference number in the another document which is created in the SAP.

Legacy data file.

RCOMP RASSC DOCNR ATYPE RACCT RTCUR TSL

L001 U001 1212121212 C CCU001 USD 200

In the data selection process, i am using the following inputs.

Company code - L001, U001.

Vendor - CCU001,CCL001.

Customer - CCU001,CCL001.

In the data assignment process, i am using the following inputs.

Company - L001, U001.

Trading Partner - L001, U001.

Rule - 300, 400.

Rule - 300 config.

200 DOCNR Document Number Equal DOCNR Document Number

Rule - 400 config.

200 DOCNR Document Number Equal REFNR Reference Number

In the reconciliation report display (right side bottom page),

U001->L001->Payables or other way around L001->U001->Receivables (Top Left side).In the either of the two display am able to see two items.

first item (not expected in the report display, bcoz there is no relevant data present in the legacy file).

TR.PT PRT.DOC.NO PR.CUR Amount DGC Difference Reference no

U001 1700036236 USD 500 USD 500 TEST

The first item exist in the SAP and it is getting selected during the data selection process.

second item (reconciled and expected in the report display)

L001 U001 1212121212 C CCU001 USD 200

Kindly help.

Thanks in advance

Regards,

Karthik

[Former Member]

Hi Ralph,

I am okay if we see in doc group in the portion below.. items with differences... but here in my case .., I have only one line in my upload file and thats is exact match of offsetting (reconciling in sap u001) and shows me with zero difference properly. But all other items that I am seeing have no matching line items ... they exist in sap world only and not in my upload file .. they should be in the top part as open... but they are moving down to reconciliation with their balance itself....

Please find below is the data in the file looks like.

L001 U001 1212121212 C CCU001 USD 200 20090603 6

Thanks,

Karthik

[Former Member]

Hi Ralph.

Using this transaction FBIC025 the issue was facing is solved.The SAP documents were containing the Reference number with the same values.So that was the reason, we are seeing the unwanted documents in the report display.

Thanks for the help.

Karthik

[Former Member]

Hi Ralph,

Yes we are having two company codes.your understanding on this point is rite.

I am using the standard file upload functionality from the presentation server for uploading the non-sap company data.since in the earlier thread i had explained very detail level, so now had made it short.

The only issue that I am having is that I have just one line item in my upload file and it is from non sap company L001 for trading partner u001. File gets loaded (data selected 1 correctly), Then after all the steps when I am in the last step (reconciliation) I see that line getting reconciled with other line available in U001 with zero difference. That looks good because it is matching as per my rule. but I am also seeing some other open items in U001 that are also getting reconciled with no lines in file with difference equal to their values. They should not show up in the bottom part of reconciliation part at all as they are still open in U001 and should not get reconciled until I put their offsetting lines in upload file from L001. So they should stay at the top right side in simple words I am seeing open items as well in reconciliation portion bottom one even I do not have any lines to reconcile them and they are showing a balance in them as well.

Thanks in advance.

Let me know, if you need any more details.

Regards,

Karthik

[former_member572578]

Hello Karthik,

Please review the note 1164059 attachment ICR_Assignment_Documentation.zip. Does that explain why the other document groups are created? If not, what do the document groups look like? You may want to check whether there is any other document with the same GRREF using either FBIC025 or SE16N.

Best regards,

Ralph

Edited by: Ralph Stadter on Jun 10, 2009 9:20 AM

[Former Member]

Hi All,

Let me know, if you need any more details for more clarity on the problem.

Hoping for some direction.

Thanks,

Karthik

[former_member572578]

Hello Karthik,

I'm not sure I understand your issue. If I'm understanding you correctly you have a companies:

U001 is an SAP company.

L001 is a non-SAP company.

You start data selection. The data of U001 is picked up during data selection. There should be a corresponding item in the log showing you how many open items of U001 with partner L001 were selected.

You are using file upload to get L001's data into the system. Did you maintain a file name or do you choose the file during data selection interactively? Does the log contain any information about documents from L001 with partner U001?

When you check these business relationships in FBIC025 do you see both documents?

Best regards,

Ralph