Visitors

System Administrator Nagpur Region

System Administrator Nagpur Region

Saturday, April 10, 2010

Meghdoot 6.6 SP1 - Solutions



If countries, currencies are not coming in Movidesh booking then patch is available in ftp site...
Delete Duplicate Account Head in Subaccounts ( Change into Current Date = ‘yyyy-mm-dd’)

Use Subaccounts
EXECUTE [H_DeleteDuplicate] @TransDate = '2010-04-09'
For treasury problem :
Run the attached Treasury1.exl file using script tool. ( Download )
After executing the script, run query analyzer and execute the following query

Use Treasury
execute update_megh66_accountheads_bydate 'ddmmyy'

Note: ‘ddmmyy’ stands for the date on which account heads not appeared. ex: if the date is 09/04/2010 then ddmmyy will be 090410

For Accounts PBS Problem:

1. If u are getting the error while generating
PLI file then

Please run the following query using query analyzer on NICPLI database
select * from NICPLI..NICMASTER where pliorrpli ='P'
see the results, If no record is returned , it means that there are no PLI record in ur NICPLI database and thus u are getting the BOF error. So u will have to transfer the pli records from master csv file, which u have downloaded from website, using bridge software and select "Delete old records and insert new records" option button. Then transfer rpli records using "Append records" option button.

2. If u are getting the error while generating RPLI file then
Please run the following querry using query analyzer on NICPLI database
select * from NICPLI..NICMASTER where pliorrpli ='R'
see the results, If no record is returned , it means that there are no RPLI record in ur NICPLI database and thus u are getting the BOF error.
>So u will have to transfer the pli records from master csv file, which u have downloaded from website, using bridge software and select "Delete old records and insert new records" option button. Then transfer rpli records using "Append records" option button."


No comments:

Post a Comment

Free Softwares and Toolbars For Employees

Get Latest govt employees News in your mail box !!

Download our free toolbar for govt employees
A Must Toolbar For Postal employees. Free Download
Calculate your New pay on Promotion
Calculate your pension, Free softwares for employees
CAD Outsourcing