How to Check and Clear all Opening Balance entry (include duplicated entry)

Financial Period Precaution:

Note: Cut off date must be in between financial period.

And Financial Period, Cut off date cannot simply change, please make sure user create database are create with correct financial period and cut off date.

Financial Length  are 12, maximum is 18 month.

If Financial Period changing without clear Opening Balance.

Changing financial period will caused Opening Balance capture duplicate/2 different amount opening balance.

Opening Balance will capture in this 2 table.

To Select all Opening Balance in gltransactions table:

select * from GLTransactions where Description = 'Opening Balance'

If you have different date of opening balance in gltransaction, to select specific date:

(Please insert Date which want to delete)

select * from GLTransactions where Description = 'Opening Balance' and TransactionDate = '31-Dec-2010'

GLOpening Balance will only store opening balance, therefore no need to select all,

But if user want to select specific date of opening balance, run script below.

(Please insert own date)

Select * from GLOpeningBalances where OpeningBalanceDate = '31-Dec-2010'

To clear all Opening Balance, execute script below:

Must execute 2 script, have to clear in 2 table:

Delete from GLTransactions where Description = 'Opening Balance'

Delete from GLOpeningBalances

The above scripts are clear all.

Clear Opening Balance with Specific date:

(Please insert Date which want to delete)

Delete from GLTransactions where Description = 'Opening Balance' and TransactionDate = '31-Dec-2010'

Delete from GLOpeningBalances where OpeningBalanceDate = '31-Dec-2010'