!-- Whatsapp Share Buttons Start -->

Latest Updates / Blogroll

.... AIPEU GROUP - 'C' IS TO CONDUCT ALL ITS STRUGGLE PROGRAMMES UNDER THE BANNER OF POSTAL JCA ....

.... THE JCA SUBMMITTED THE MEMORANDUM TO 7TH CPC ON 23.7.2014 ....

…. NFPE & GDS (NFPE) FILED A CASE IN SUPREME COURT PRAYING : IMPLEMENTATION OF 1977 JUDGEMENT AND DECLARE GDS ARE CIVIL SERVANTS & SCRAP THE GDS (CONDUCT & ENGAGEMENT) RULES 2011 AS THEY ARE INVALID AND UNCONSTITUTIONAL ....

…. SUPREME COURT DIRECTED THE CASE TO DELHI HIGH COURT .. FIRST HEARING WAS ON 13-01-2014 AND PLEASED TO SERVE NOTICE TO GOVT. & DEPARTMENT....

.... NEXT HEARING ON 07-05-2014 NEXT HEARING ON 07-05-2014 ....

APPEAL

APPEAL

UNION SUBSCRIPTION

.... AIPEU GROUP - 'C' UNION SUBSCRIPTION DETAILS ....

.... ALL INDIA UNION / CHQ QUOTA = RS 13 + CIRCLE UNION QUOTA = RS 12 + DIVISIONAL / BRANCH UNION QUOTA = RS 25, TOTAL = RS 50....
.... AIPEU POSTMEN & MTS UNION SUBSCRIPTION DETAILS ....


.... NFPE = Rs 2 + ALL INDIA UNION / CHQ QUOTA = RS 10 + CIRCLE UNION QUOTA = RS 10 + DIVISIONAL / BRANCH UNION QUOTA = RS 18, TOTAL = RS 40....

DHENKANAL POSTAL DIVISION AT A GLANCE

Saturday, April 1, 2017

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



0 comments:

Post a Comment

IS GENERATOR FUNCTIONAL AT YOUR POST OFFICE ?

IS EARTHING DONE AT YOUR POST OFFICE ?

IS UPS FUNCTIONAL AND GIVING BACK UP AT YOUR POST OFFICE ?

IS THERE A SEPARATE SERVER COMPUTER AT YOUR POST OFFICE ?

IS CASH COUNTING MACHINE AVAILABLE AT YOUR POST OFFICE ?

IS VACUUM CLEANER AVAILABLE AT YOUR POST OFFICE ?

IS THERE ANY SECURITY WATCHMAN AT YOUR POST OFFICE ?

IS FAKE NOTE DETECTOR AVAILABLE AT YOUR POST OFFICE ?

About

ALL THE INFORMATION PUBLISHED IN THIS WEBPAGE IS SUBMITTED BY USERS OR FREE TO DOWNLOAD ON THE INTERNET. I MAKE NO REPRESENTATIONS AS TO ACCURACY, COMPLETENESS, CURRECTNESS, SUITABILITY OR VALIDITY OF ANY INFORMATION ON THIS PAGE AND WILL NOT BE LIABLE FOR ANY ERRORS, OMISSIONS OR DELAYS IN THIS INFORMATION OR ANY LOSSES, INJURIES OR DAMAGES ARISING FROM ITS DISPLAY OR USE. ALL INFORMATION IS PROVIDED ON AN AS-IS BASIS. ALL THE OTHER PAGES YOU VISIT THROUGH THE HYPER LINKS MAY HAVE DIFFERENT PRIVACY POLICIES. IF ANYBODY FEELS THAT HIS/HER DATA HAS BEEN ILLEGALLY PUT IN THIS WEBPAGE OR IF YOU ARE THE RIGHTFUL OWNER OF ANY MATERIAL AND WANT IT REMOVED PLEASE EMAIL ME AT "suryamadhu.talk@gmail.com" AND I WILL REMOVE IT IMMEDIATELY ON DEMAND. ALL THE OTHER STANDARD DISCLAIMERS, TERMS AND CONDITIONS OF TRADEMARK, REGISTERED COPY RIGHT, PATENT ALSO APPLY.
COPY RIGHTS RESERVED WITH AIPEU P3, DHENKANAL DIVISION ( R ) / ( T ) : 2014 : PIONEERS OF THE TRADE UNION MOVEMENT