CashBook Report Opening Balance

SOLVED

Hello Team, 

I trust you’re all well. 

One of our customer has raised a question on Cashbook reports opening balances. After processing the Take-On balance, a debit amount was entered for a specific cashbook. It stayed debit amount as closed balance last year and open balance on the following year still shows debit amount. 

The weird issue rose when viewing the Cashbook report (Report > General Ledger > Cashbook). The opening balance is showing on the Credit side along with the payments done for that particular cashbook. Its closing balance also appears as credit amount. 

I have recreated the same scenario using demo database, Cashbook: 8420 please see the images below to clarify the query. 

Reports > General Ledgers > Accounts Transactions

Ledger Accounts

TB

Now as you see above, the below report for Cashbook:8420 is a bit confusing to the Customer. The payments of 250,000 has been credited to the cashbook and debit closing balance 750,000 is also on the credit amount. The TB shows debit while Cashbook shows credit amount.

CB

Please assist if this is normal and why?

Best Regards