Troubleshooting Problems in Postal Applications - 5

Add This To Del.icio.us Share on Facebook StumbleUpon This Add to Technorati Digg This Pin It

Subaccounts §     To modify daily account data entry for the current day To either correct a wrong entry or to make corrections suggested by other branches, select the daily account concerned in the data entry menu and carry out suitable corrections making corresponding accounting adjustment to ensure that the balance reported in the daily account is not altered.  Such corrections can be carried out before the summary is printed for the day. §     To modify daily account data of a previous date If corrections are suggested by branches or otherwise, in the SO summary of a previous date, corrections should be done for the SO figures in the HO cash book using Adjustments option.  The correction should not have the effect of altering the CB. §     While viewing summary data an error “Sub query returned…” comes up and viewing and printing is not possible This error comes if the operator selects the daily account date wrongly using the option Additional DA in the daily account posting dialog box.  Approach the administrator to solve this problem.  The administrator will have to proceed as below ·        Ensure that all PAs and Supervisor have logged out of Subaccounts module ·        Please download the query titled Subqueryproblem.sql along with the concerned read me file ·        Please go through the readme file and understand the procedure for solving the problem ·        The administrator to login to server and open the SQL server query anyalyser ·        Select the database SUBACCOUNTS or BOSUBACCOUNTS if the problem relates to SO summary or BO summary respectively ·        Using the file – open menu, open the subqueryproblem.sql query and execute the query ·        On completion of execution of the query, select the menu File – New and in the New dialog box, select Blank query window and click OK button ·        In the new query window type the query “Execute  H_DeleteDuplicate  '2006/11/02'” where the date should be the date of SO/BO summary(HO/Account office date) and execute the query.  The date should be typed in YYYY/MM/DD format On completion of execution, inform the operators to continue working Share and Care

For Latest Updates Always Visit http://satish24k.blogspot.com/

PrintPDF

For Further Reading,

Meghdoot Millennium, POSTAL TECHNOLOGY, SAPOST, Troubleshooting Problems in Postal Applications