Problem with automatic clearing F.13

[Former Member]

Hello Gurus,

We have huge old open items (posted in old system R/3 4.7 after upgrade in ECC 6) which cannot be cleared by F.13. The OB74 is maintained for that GL account by Fund and Business area. The open items are basically the the year end Journal Entry which are balance by Fund and Business area i.e the total is 0.

However when we run F.13 by selecting that Gl account and those open item documents (which are balanced to 0 by fund and business area), they cannot be cleared. In the test run, detail List shows the document posted in old system (4.7) with only Business Area field populated but the documents posted in the new system (ECC) has both business area and fund fields populated. I think the problem is in the documents posted in the old system because they do not populate Fund. Below is the copy of Detail List from test Run:

DocumentNo Itm Clearing Clrng doc. SG Crcy Amount Business Area Fund

10056388 001 USD 75.37 0380

10056367 001 USD 582.24 0380

10056365 001 USD 1,976.44 0380

10056366 001 USD 2,000.00 0380

10028974 002 USD 47,662.00 0380

• USD 52,296.05 0380

10097405 001 USD 663.99 0380 7003801

10108169 002 USD 52,960.04- 0380 7003801

• USD 52,296.05- 0380 7003801*

I would appreciate if you could help me on this,

Thanks

Prakash

Edited by: Prakash Shahi on Jun 23, 2010 8:17 PM

Edited by: Prakash Shahi on Jun 23, 2010 8:20 PM

[gladys_xing · Accepted solution]

Hi Prakash

Can you check whether there is value in GEBER saved in BSEG table (check in T-cd:SE16 ) for the old documents posted in release 470?

If not, then it should be derivation issue when posting the old documents in system (4.7) . I researched in our SAP database whether there is similar issue happened or not, unfortunately I can not find. so suggest you to create a FI-Gl-Gl-A message with details reproducing example in system (4.7) .

In case you don't have system (4.7) anymore, may you consider to use below 2 ways for clearing these documents together:

1. Try to use another criterion for clearing those documents.

2. Clearing these documents manually in T-cd:FB1S/FB1K/FB1D.

Best Regards,

Gladys xing

[Former Member · Accepted solution]

Hi Gladys,

Yes, the table BSEG is populated with fund for those docs posted in 4.7 system. It would take a long time to clear them manually because we have huge open items since 10 years back from implementation date.

I am trying to find out if there is a SAP Note or something regarding this issue. It looks like it is a program issue because Automatic Clearing Program SAPF124 is not able to derive Fund for clearing for those docs posted prior to upgrade.

Thanks for your effort.

[gladys_xing · Accepted solution]

Hi Prakash,

I did research very carefully, so far there was not similiar message reported from customer.

Did you check whether this issue happened in 4.7 system till now( I mean, the issue that no fund value displayed in F.13 log although they are existed in BSEG and secondary index table: example:BSIS .

If you can debug, you can try to find why GEBER was not transfer from index table). otherwise please create message in FI-GL-GL-A, our SAP colleagues can help you further.

Another way is I have mentioned in before reply, define another clearing criterion in OB74.

With Best Regards,

Gladys Xing

[Former Member · Accepted solution]

We don't have access to 4.7 now. But i checked BSIS and FUND is empty for those open GL items posted prior to beginning of 2004 which is when we had done the upgrade from 4.6 to 4.7. But the fund is populated for the same line item in BSEG.

Fund was never transferred to secondary index table BSIS. I need to have the FUND field in the criteria in OB74 because the balance sheet is balances by fund and business area. If they are cleared out of balance it will create due to due from entry which needs to be corrected again.

[gladys_xing · Accepted solution]

HI Prakash,

There is abviously inconsisterncy in your system for FUND field if all settings between 4.7 and 6.0 are the same. and because you don't have access to 4.7 now, the only way is to correct the inconsistency documents between BSIS, BSEG and FM related tabkes, please report a message in FI-GL-GL-X .after the correction, value of Fund should be updated in BSIS as well, then in F.13, Fund value will be displayed in this log correctly and you can clear them.

Best Regards

Gladys Xing

[Former Member · Accepted solution]

Hi Gladys,

I have created OSS message to FI-GL-GL-A. Once i have the answer i share it with you as well,

Thanks for your help though,

Regards

Prakash

[former_member224726 · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

Hi Suresh, yes i got the answer. SAP looked into our system found that BSIS was inconsistent with BSEG. So they will repair our production system so that Fund will populate in BSIS consistent with BSEG. Fund was not populating in BSIS in ERP 4.6 and it started populating after 4.7.

Prakash