Friday, 16 April 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."

If you are having schedule problem after upgradation of Megh 6.6 servicepack1


1.Select NICPLI  database>select Environment table>open table>modify the file downloaded field as "N" and then open the schedule your problem will be solved

(or)

2. Use the Schedule.exe available in  MD 6.6 SP1 -Testing  folder
ftp://ftp.ptcinfo.org/ForSKRegionAndCoimbatoreRegionProjectArrowTesting

Local Article DET Problem

If you are having any grievance regarding local articles, then pls run run the enclosed script using the script tool.This postman15042010.exl will eliminate the condition that you should use only one of the two options i.e.,either fetch from counter option or take receipt using bag details.

Hence after running this exl, you should take receipt of all the local articles using the Bag Details option on the next date. The DET will not take the receipt of the articles fetched using the fetch from counter option.

Hence pls note that all the local articles should be taken receipt by using the Bag Details option hereafter.
Postman150410 patch Download the Postman150410.exe from here

1 comment: