Deletion of balance zero in Z report prepared for cash journal

[Former Member]

Hi,

One of our cash journal for site was having mismatch between last day's closing balance and opening balance of next day. So, according to solution given from SAP we run the report RFCJ1 for that cash journal and after that balance of closing and next day' opening have been tallied.

As because of this execution program deletes the balance table, however, no information is lost.

Next time to run the transaction FBCJ, the opening balance has recalculated properly.

But now the problem is because of that one of our Z report created for seeing balance for Cash Journal (Opening and Closing) on a day to day basis is having problem and closing balance for that cash journal is showing as zero in this Z report. While in Std. Cash journal Closing bal. is different.

Pls suggest. Awaiting for your reply.

Tapan

[dekhamz02]

Please explain how you were able to resolve this issue.

Thanks.

[former_member182098 · Accepted solution]

Please go to SE16N,

Give the table name

Press Enter

In the transaction code bar enter '&SAP_EDIT' and press enter.

SAP editing function is activated.

now click on execute.

The table will open in EDIT mode. But, please make sure that you are editing correctly the entries.

Note:

This is not the recommended procedure to do. Therefore, please do not attempt to do in production.

Any wrong doing will have negative consequence.

Regards,

Ravi

[dekhamz02 · Accepted solution]

This makes sense, senior man, but hope it does not result in future issues since I am fixing this in production., or could you please proffer alternative soltiuon to this??