FBCJ & FS10N value mismatch

[gouravkumar64]

Hi Friends,

I am a ABAPer.

I am facing one problem,from my FI side,while running FBCJ & FS10N .

we are running fs10n with account number,company code,fiscal year-2012.

value of every month is matching except november month.

As per my observation,

Amount 1030 is not matching with FBCJ,That 1030 amount posted & then reversed.

My system is ECC6.0 ,I tried to run FAGLB03 also,But same result.

I also read notes & thread like

http://scn.sap.com/thread/1429080

Note 377853 - FBCJ: Opening and closing balance

But Not getting any help.

I am attaching both screenshot.

Why this value is not matching for november month ?

Any help ?

Thanks

Gourav.

[gouravkumar64 · Accepted solution]

Hi Friends,

We Got solution.

We raised a issue to SAP.

Actually,in FBCJ For that date,status was D-DELETED Instead of P,by functional team,kind of mistake,but balance coming somehow in TABLE.

Then after P,we need to run RFCJ1 Standard report.

After that,value is matching till now.

Thanks to all,for co-operation.

Regards

Gourav.

[shinas_rh · Accepted solution]

Its Good that u have replied the Right solution..

Thanks to You..

[former_member703638 · Accepted solution]

HI KUMAR,

can you explain your solution please. I'm facing to this issue

[Former Member]

I think this because there are some transactions saved in cash journal but not posted to finance yet.

[gouravkumar64]

Hi Ibrahim

As per function team,there is no transaction is in saved status.

Though It is purely functional issue ,we are trying to solve this issue.

Let see what happens.

Thanks

Gourav.

[former_member213733]

Can you pl. confirm that there are no transactions in the state SAVED in FBCJ and not posted to FI . As cash balances make movements once the tranaction is saved and not at the time of its acual postings to FI.

The transaction in Question amount to 1000 so i dont see that 1030 is the one causing the pain .

Check and above point and revert if still you have issues .

Regards ,

[gouravkumar64]

Hi Dewang,

Thanks for reply.

No, there is no transaction, which is in saved status,in FBCJ.

I am not able to understand why that reversal is not affecting in FS10N .

Thanks

Gourav.

[suma_mani]

Hi Gourav,

Please follow the mentioned SAP note.

Note 1309577 - FBCJ: Incorrect balance in cash journal

Kindly revert ,if not solve the same

Regards

Mani Kumar

[gouravkumar64]

Hi,

This note is not relevant ,I have checked it.

Only for november month ,value is not matching.

I got many sap notes but not able to solve or got any help from those.

Also From main program I am not able to track some points or table,where the value is updating.

Thanks

Gourav.

[suma_mani]

Hi Gourav,

First check whether any direct JV passed to Cash account ,which may cause difference between to FS10N and FBCJ in Nov.

I had same issue for the month of March 2013,i solved through said note. It is just deleting the performance table values. Just check with that. It is not big deal that note.

Or else contact SAP

Regards

Mani

[gouravkumar64]

Hi Mani,

As per your suggestion,

1)No direct JV passed here ,

2) I run standard program RFCJ1 As per your notes .but it's deleted table tcj_balance entries ,If I run FBCJ & FS10N next time ,No result here.means FBCJ & FS10N Value is not matching.

For your information in TCJ_DOCUMENTS I have 4 line items now ,for that one.

One is Deleted status

second is reversed ,3rd is Posted ,4th is actual Posted documents.

All are having 1030 value.

Your opinion please.

Thanks

Gourav.

[suma_mani]

Hi Gourav,

Thanks ! Could you please check November month opening balance and Closing balance in FBCJ & December month opening balance must be same as November month Closing balance. According to me it is not problem with FS10N.

There could be several causes FBCJ balance not tally with FS10N. I have given mentioned notes ,which may help. Better to read Note number 546365. If error persist ,kindly raise OSS.

1. Several cashier work simultaneously with same cash journal / save large amount of entries

    Note 1712030 - FBCJ Cash Journal different Closing/Opening balances

2. You use the FI cash journal. The opening balance on the display day is incorrect, even though the closing balance on the previous day is correct.

Note 1642124 - FBCJ: Update in TCJ_BALANCE missing, TCJ_BALANCE incorrect

3. Note 1690669 - FBCJ: Pstng date chg. -> split line or one-time info is lost

4.

Note 546365 - FAQ: Cash journal

Regards

Mani Kumar

[gouravkumar64]

Hello Mani,

Thanks for your valuable input.

I have checked In FBCJ ,there is no mismatch between Closing balance of November & opening balance of December.

For that reason your first two notes is not relevant.

Last two notes also helpful here.

Our functional team are checking this issue with End user.

We are trying,let see what happens.

If there will no option we will delete that line items & again post, otherwise OSS!!

Thanks

Gourav.

[former_member212740]

Dear Gaurav,

From the attached screen shot it appears that the difference is for Rs. 1360/- insted of Rs.1030/-.

Please check that if any FI entry directly posted to that Cash GL a/c. If any entry posted directly in Cash Account other than FBCJ Transaction code then could be the reason for this mismatch.

thanks

[gouravkumar64]

Hi VS,

I will remind Your point,Will let You Know.

Thanks

Gourav.

[shinas_rh]

Hi Kumar,

I just want to know where are getting the Difference ?

1. FBCJ is more   ??

3. FBL3N is More  ??

Or In FBCJ, 1030 is missing or what ?

If possible Give a screen of FBl3N also.

Normally, Difference may arise due to the Direct Posting in Cash Ledger. I mean if the user Posted Transaction Directly to Cash Ledger, then this will not reflect in FBCJ.

*** Condition Manual Posting Allowed to the Cash Ledger ****

[gouravkumar64]

Hi Shinas,

As Now,I do not have access to SYSTEM,I do not have Screenshot.

As per functional team , FBCJ Showing correct amount for november.

But in FS10N It is showing wrong cumulative balance means less balance, for that month.

Lastly ,Your all points ,I will remember,In further case,will let You know.

Thanks

Gourav.