Cash Book - Opening balance after FI migration

[Former Member]

Hi all,

We have have just finished our migration and I would like to know how we can enter in Cash Book (T_CODE FBCJ) the opening balance?

I'm sure that we need to do a manual posting but which element I need to precise in this posting to get the amount in the field "Opening balance"?

Thanks for your help,

Regards

Karim

[Former Member · Accepted solution]

Dear,

Manual Business Transaction is required to be created for Transfer of Opening Balance from Legacy to SAP. Mark the Business Transaction as Blocked in FBCJC2 once the balance are transferred.

Assign Takeover GL Account to the Business Transaction created.

Hope the above explanation would help.

Regards,

Jaymin R. Bhatt

[Former Member]

Dear all, thanks for your explanations.

I have duplicated a business transaction type (C=Receipt from bank account) and set the migration account.

posting is ok, but the amount is displayed in Cash receipts and not opening balance...

Is it normal after an FI migration? Is there an action to perform to move the amount from cash receipt to Opening balance?

IF I expect to hve the amount in Opening balance...what should I do??

Thanks for your help,

Karim

[atif_farooq]

Hi:

This is system standard behavior. E.g you have configured Cash journal today and have posted an entry for cash receipt from bank dated 18.10.2011 valuing 50000 Rs..It makes sense that Cash journal will show only amount in cash receipts only becuase prior to 18/10/2011 you were not having any balance in FBCJ cash journal , however if you enter date as 19/10/2011 in from and to period it will show you the opening balance 50000 Rs....I hope it will help you..

Regards

[atif_farooq]

Hi:

In order to update opening cash balance in your cash journal you will have to create a custom cash journal in FBCJC0 and then a TT in FBCJC2.For instance you want to update cash opening balance through cash collection from customers then in FBCJC2 you will have to create a new TT for account type K...Number ranges for cash journals will be maintained in FBCJC1 and FBN1. This is not a manual posting , system will auto debit cash journal GL as given in FBCJC1. I hope this will help you.

Regards

[former_member188028]

Hi,

Even opening balance transaction also to be done in FBCJ only.

Create one business transaction for Opening balance upload.

Please go to Cash receipts tab and select this BT and assign Opening balances upload account(Usually this might be start with 9)

The accounting entry would be

Dr Cash journal a/c

Cr Opening balances upload a/c

Rgds

Murali. N