DET figure mismatch

Problem in fetching column no.7 and 51of data extraction toolPostman220410.exl

Point of Sale SP2

The following modification are done in the service pack 2 for PointOfSale6.6 attached herewith.

1.Rectified the error in RPLI receipt printing.
2.Rectified the error in submit account related to MTNL transactions.
3.Rectified the error in submit account related to EPP transactions.
4.FCCode and Register number are made mandatory for NPS transactions.
5.Validations for NPS transactions according to the selection of service type.
Download Here

POS Solution

Point of Sale DayEnd Problem
Download

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

FAQ Meghdoot 6.6.1 (Service Pack-1)

Point of Sale

1.      RPLI transactions cannot be booked.

Solution: Do not enter Date Of Acceptance and Agent Code while doing RPLI transactions till a new service pack is supplied.

2.      Stored procedure missing error while doing submit account.

Solution: EMO database upgradation should be done before Counter upgradation. You should do emo database upgradation and then do the counter database upgradation.

3.      The following error log after counter database upgradation.

1. COUNTER

22:36:28:============================================

22:36:28:         SCRIPT EXECUTION DETAILS (counter)

22:36:28:============================================

22:36:29:[Column names in each table must be unique. Column name 'AgentCode' in table 'PostalLifeInsurance' is specified more than once.] : Script Execution Error : While executing statement ALTER TABLE PostalLifeInsurance ADD AgentCode nvarchar(15) NULL

22:36:29:[Column names in each table must be unique. Column name 'FirstYearPremium' in table 'PostalLifeInsurance' is specified more than once.] : Script Execution Error : While executing statement ALTER TABLE PostalLifeInsurance ADD FirstYearPremium money NULL

22:36:29:[Column names in each table must be unique. Column name 'DateOfAcceptance' in table 'PostalLifeInsurance' is specified more than once.] : Script Execution Error : While executing statement ALTER TABLE PostalLifeInsurance ADD DateOfAcceptance datetime

Solution: These error messages will come if counter database is upgraded twice. These error messages  can be ignored.

4.      Active X component cannot create object.

Solution: Reinstall the application after deleting the old installation cab files. If you are getting any error while registering the dlls then do the following

Register the dll by entering the following in the Run dialog box window.(Start - Run)

Regsvr32 ApplicationPath\dllname

eg.Regsvr32 H:\POS\cash.dll

5.      While doing submit accounts ‘Server not configured for RPC’

Solution: Run the following query using query analyzer

exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'

go

exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'

go

in the myserver replace the myserver with your servername.. It will solve the RPC problem

6.      While doing submit accounts error ‘Operation is not allowed when the object is closed’

Solution : Run Counter13042010.exl using script tool.

7.      While booking MO Videsh, Countries and currencies are not coming

Solution :  If countries, currencies are not coming in Movidesh booking then patch is available in ftp site...

ftp://ftp.ptcinfo.org/ForSKRegionAndCoimbatoreRegionProjectArrowTesting/MOVidesh/EuroGiroTest.rar

8.      While performing Day End, Multiple step operation generated errors. Check each status value

Solution: Please download the zip file from http://www.sendspace.com/file/r7xz78. Unzip it and follow the instruction given in readme.

9.      Invalid object name 'ECounter..ENVIRONMENT'.

Solution : Upgrade eCounter database

TREASURY

1.      In treasury module while entry in postman returns error shown ‘POSTMAN DATA BASE IS NOT AVAILBLE QUITTING’

Solution:  Run the following query using query analyzer

exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'

go

exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'

go

in the myserver replace the myserver with your servername.. It will solve the RPC problem

2.      Accounts Heads not coming

Solution: Please run treasury1.exl using script tool.

After executing the script, run query analyzer and execute the following query selecting treasury database.

update_megh66_accountheads_bydate 'ddmmyy'

ddmmyy stands for the date on which account heads not appeared. ex: if the date is 06/04/2010 then ddmmyy will be 060410

DESPATCH

1.      While performing Day End, Multiple step operation generated errors. Check each status value

Solution: Please download the zip file from http://www.sendspace.com/file/r7xz78. Unzip it and follow the instruction given in readme.

2.      Station articles are not fetching in Despatch

Solution:  Local delivery / Station articles will not be fetched for despatch in the Despatch module.You can fetch local article for delivery through postman module. The data will be correctly fetched in DET.

POSTMAN

1.      Local articles are showing not sent out for delivery in DET

Solution:  The option "Fetch from Counter" should be used on the day of invoicing these articles to Postman beats.  For ex: If you have booked local articles today and you want them to be sent to beats on tomorrow, you should not use the Fetch from Counter option today.  This option to be exercised on the next dayonly.

In such a situation, even if you don’t fetch today, all these local articles will be treated as "Despatched" in DET.  Hence Pls use the Fetch from Counter option on the date of invoicing the articles to postman.

SUB ACCOUNTS

For any type of error coming after upgradation pl.do the following.

Restore the backup of Sub accounts, Sub Treasury, BO Sub accounts taken before upgradation....and continue your work till solution is provided by PTC.

eMO

1.      Object reference not set error while doing paid verification

Solution: Please ensure that eMO Account heads are created properly. SubAccount and SupplySubaccount databases are running and correct treasury server name is given while configuration. Ensure that Socodemapping is done correctly. Ensure that HOAccount date and SOaccount dates are entered correctly both in eMO operator and subaccount modules.

Meghdoot 6.6 SP1 Solution

If countries, currencies are not coming in Movidesh booking then patch is available in ftp site... ftp://ftp.ptcinfo.org/Meghdootv6.6/PointOfSale/eurogiroCountryProblem/EuroGiro.zip

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."

All Download

All Downloads
All patches and scripts which may downloaded from here