Sub Account - Sub query / Day begin Error and Solution

Sub Account - Sub query / Day begin Error and Solution

Subaccount Sub Query error / Solution

For Error in Daybegin or Additional Daily in SUB ACCOUNTS Application (For Both SubOffice related and Branch Office related)

Solution for the problem "SubQuery returned more than one value...." and for Two OBs for same dates to same office under Opening Balance option of Supervisor.

Solution

Take Backup of Sub Account Related Database before apply below Solution

1. Download the Script file SUBQUERYPROBLEM.SQL from solution scripts folder

2. Open Query Analyser

3. Select SUBACCOUNTS database if error is coming while entering SO Additional Daily Account

else select BOSUBACCOUNTs if error is found in BO Additional Daily Account.

4. open the downloaded file and run it by pressing F5

5. open a new QUERY WINDOW

6. type the following statement which has the SOSUMMARY Date (NOT DAILY A/C DATE). Pls Note the date has to be  in the same format of yyyy/mm/dd.

NOTE : If the error occurs for daybegin then the SOSUMMARY date should be the previous date for which Dayend is already done.

 Execute H_DeleteDuplicate '2004/02/25'

7. Run it by pressing F5

8. Close Query Analyser and start working in SubAccounts Application

Download Query