Issues in Sub account Supplementary and Solution

a. Runtime error appearing for Supplementary--Printing SO Reports-->Summary-General

b. Runtime error appearing for Supplementary--View So Details--Other Data/Closing Balance.

Snapshot of Sub Account Error Message

Incorrect Syntax Near 'Speedpo'

Incorrect Syntax Near 'IEMOP'

Incorrect Syntax Near '.' / Incorrect syntax Near '+'.

Incorrect Syntax Near 'ip

'

Solution for Incorrect Syntax Near ''

1. CEPT Provides Solution for Incorrect Syntax Near '' in Sub Account 7.8 Supplementary .
2. Download attached Sub account Exls from PoTools.
3. Execute both exls using Script Tool.exe.

Download

Download

SUB ACCOUNT 7.8 DAY BEGIN ISSUES AND SOLUTION

Sub Account 7.8 Day Begin Error 

While Day Begin in Sub Account 7.8 it shows an error message as Could not find stored procedure 'H_CheckforSuppleDates'.

 Invalid object name 'SuppleDateMaster'.

Solution

1. Download attached Script from PoTools.
2. Execute Once Using MM Script Tool.

Download

Download

COD COLLECTION HEAD MISSING IN SUB ACCOUNT AND TREASURY 7.9

Posted by Admin 

BPCOD/EPCOD Collection Head Missing In Sub Account

After Update 9 In Some offices COD Collection head was not yet Created. i.e BPCOD Collection, EPCOD Collection, BPCOD Fee and EPCOD Fee in Sub account Module and also Treasury Module.

Do's

For Create account Head for COD in both Sub Account and Treasury

1. Download Attached Treasury.exl from PoTools 1KB.
2. Execute the same Using Script Tool 

Download

Note:This is Only for MM 7 Update 9 Parcel Net.

 Don'ts

Never Create COD Collection manually, it will create Issues with

1. Mis-match Account head between Sub Offices an Head Office.
2. it will be deleted at the end of month if not make Permanent.
3. View SMR Report in Treasury Module.

Just For Info :

Script Provided by CEPT, it will available in parcel Net Update and all Solutions.

SOLUTION FOR POSTMAN TRANSFER_PARCELCOD_TO_ECOUNTER ISSUES

Posted by Admin 

Postman 7.9 COD Invoicing Issues 

While  Invoice COD Articles in Postman using Post Sorting Option it shows an Run-Time Error.

Error

Run-time error '-2147217900 (80040e14)':

Could not find stored procedure 'postman.dbo.Transfer_ParcelCOD_to_Ecounter'.

Solution

This issues Because of Transfer_ParcelCOD_toEcounter stored procedure not created / improper updation.

1. Download attached Script Transfer_ParcelCOD_to_Ecounter.exl from PoTools.
2. Extract and Execute Once using MM Script Tool.

Download

Download

Note : Above exl were provided by CEPT and test by PoTools.

The above Issue because of Booked article addressee detail contains more than 30 Characters. Counter PA Should enter Address information less than 30 characters CEPT Mysore will settle this issue in futher release.

Wednesday, January 15, 2014

DESPATCH 7.9 STRING/BINARY ISSUES WITH FETCH FROM POSTMAN

Despatch String / Binary Data Would Be Truncated

while fetch article in Despatch 7.9 It shows an error message [Microsoft][ODBC SQL Server Driver][SQL Server] String or binary data would be truncated.

• Counter PA Should enter Address information less than 30 characters
• CEPT Mysore will settle this issue in futher release.

Solution to parcelnet 13/01/2014

Reliesed by CEPT myosore for
Solution to parcel net 13/01/2014

Download

Postman 7.9 Dated 09.01.14

Postman 7.9 Dated 09.01.14

Postman Exl files and Updates with Updater:
Download

EMO IFS Error And Solution

Issues

1. Could not find stored procedure "GetIFSMOs_For_RePrinting

2. Could not find stored procedure "N_geteMODetailsForReturnedAuth

3. Could not find stored procedure "N_getIFSDetailsForRedirectionAuth

4. Could not find stored procedure "N_getReasonCodeforIFS

5. Could not find stored procedure "N_IFSDetailedTracking

6. Could not find stored procedure "v_getIFSDetailsForPrinting

Solution

• Download attached exl
• Execute Once Using Script Tool.

Download

eMO IFS exl

Simple Procedure To Receive The Articles

Most of the Offices has received the COD articles with duplicate in Postman. so here i have shared procedure to Receive the COD articles without duplicate.

Prerequisites

• MM 7 Update 9 Upto dated 24.12.2013 should be installed.
• R Net Communication 4.0 - Office Master Should be updated.

Procedure

When COD article is Received to your Office, You just do the following to receive COD Booking data.

Postman 7.9 Registered Parcel Bag

• Click Bag Receiving to Receive the COD Parcel Bag. 

Try to receive the Bag as Virtually instead of Physically. 

•  Use Bag Opening Option to Open the COD Articles.

Before receive the COD articles you should ensure that Bag contains article type as COD.

• To avoid Duplicate Entries  In-case COD bags does not received virtually then only you should receive and Open the COD Articles Physically.

  If you receive the COD article Physically that is already received by virtual bag that will create duplicate in article type, so at the time of transfer COD to eCounter by Postman Module it gets doubled.  

• Once Open the article as COD, Just Execute the R Net Communication.

The above procedure to enough to receive the COD article booking message from Central Server.

Request Resend:If Article does not comes for Postman 7.9 (dated 24.12.13)  invoicing using the above procedure, you may try to give the request Once from Postman Supervisor.

Central Server will respond your request Min 30 Seconds to Max 3 Hours. Once you have requested COD booking data from Postman Supervisor you should execute R Net Communication frequently until receive the COD Article

Just For Info

• Once article is received from Central server, article will disappear from Request resend option.
• If Article number not available in Request Resend Menu

1. It should be download into local database.
2. Its surly will available in Postman 7.9 COD Post Sorting Menu.

•  even not available in Post Sorting Menu. You should take up this issues to CEPT.

Never Try

Kindly never try to receive/open/request resend the same article again and again in Postman Module. It will leads to create the Duplicate entries at the time of article received to local database.

Postman 7.9 Day end Issues Report of eVP Received for SOs is not printed

Postman 7.9 Day End Issues : eVP Received for SOs is not printed

COD article were implemented in Parcel Net Update i.e MM 7 Update 9, Most of the Issues were fixed by CEPT in the version dated 24.12.2013. But in some offices were received error message at the time of postman day end. It shows an Error Report of eVP received for SOs is not printed.

Snap Shot

After received some COD articles to local database, the above issues may occur in Postman 7.9.

Postman Day end Error Message :

Report of the eVPs Received For SOs dated is not printed. Please get it printed through Operator before performing Day End.

Solution

1. Download attached eCounter Script from PoTools.
2. Execute Once Using MM script Tool.exe

Download

eCounter Exl

Postman 7.9 EVP/COD Verification Issues and Solution

After RTS/Paid BO verifying of BPCOD article the error message is "Supervisor has not verified BO EVP/COD returns."

Please check and verify EVP/COD Returns of all the BOs before performing Day End.

Solution

1. Download Postman 7.9 rar file from PoTools into your machine.
2. extract the same and execute all the exl and replace the latest postman.exe and dlls.
3. Register the dlls then open and check with latest Postman.

Download

Download

Complete Procedure to Upgrade Parcel Net and Receive COD

Up-gradation Procedure of Parcel Net for COD (Update 9)

CEPT has released four solutions for update 9, In Most of the offices were upgraded upto 17.12.2013 or before version only. after that Upgrade directly 24.12.13 it will create some issues listed below

Issues

• Not able to verify BO Return to Sender - RTS articles.
• Not able to day end postman - BO COD verification not done.
• At the time of Postman day end it shows an message Subscript Out of range.
• COD article message data were received and it does not shows in invoicing.

Solution

1. Update should be done update IFS Update.
2. If you have updated Parcel Net 17.12.13 then you should download attached solution.
3. Execute all the exls order-wise then
4. Replace Exes and dlls of Parcel net Solution dated 24.12.13 from CEPT FTP.
5. Login as Postman operator and check whether article received or not.
6. All the exls were complied here is provided by CEPT only.

Note: No need to execute exl once from 24.12.13.

Download

CODParcelSolution

To know more about COD article

COD Parcel 

 

COD articles Despatch Solution in Despatch 7.9

Issues

After Update 7.9, we have faced many issues but all those issues fixed by CEPT and Finally released MM 7 Update 9. But in some office have issues with Despatch of COD articles in Despatch Module.

 

we can fetch COD articles in despatch Module while prepare bag it shows an message as "This Articl with  

is an either not collected or already included in some bag.

 

 

Solution

• Download and execute attached exe at once

Download

Despatch Exe

Configuration

1. Login as Despatch 7.9 Supervisor to Configure Bag type
2. Modify / View Tab to check whether Article types are available.
3. Select BPCOD/EPCOD and related parcel type and then modify.

Refer the Screenshot

 

Point of Sale International EMS NewTariff Revision W.E FROM 01/05/2013

Point Of Sale Internation EMS Tariff Revision w.ef. 1.5.2013

Release Document

Centre for Excellence In Postal Technology, Mysore 570010

This section will outline about:

ü        The Requirement

ü        How to use

The Requirement

The tariff fixed vide Department letter No. 43-1/08-DA dated 3.1.2011 for International EMS has been revised. The new tariff will be effective from 1.5.2013. Though the provision for configuring the tariff is available in Point of sale, inorder to ease the work of configuration and to incorporate some changes in the structure of countries the utility is being provided.

How to use

Run the InternationalEMSTariffRevision_2013 exe in the machine where Point Of Sale Server component is installed. Enter the path of PointOfSale Server component and the SQL server name and click on Update to update the new Internation EMS tariff rates.

DOWNLOAD PATCH HERE 

Error in update 5

After updating MM7 with update 5, while running eMO client an error as shown "[701] Login faild for user 'nrega' "

Download solution

UPDATE 5 TO MEGHDOOT 7.0 FOR NREGS DATA TRANSFER

Upgradation procedure for NREG in c/w eMO Client
Ensure that your emo database is already upgraded with version 7 update 3. In offices having Sanchay post latest version installed and NREGAEMO database is available, please upgrade the same with NREGAEMO script provided.
Stop eMO client exe if running. Replace existing eMOclient.exe available in eMO client installation path with new eMO client exe provided in upgradation.
For the first time, when you run new eMO client exe, it will prompt to enter Sanchay post server details as below.

Enter Sanchay post server name if Sanchay Post server is available in that office else select not available and click on OK.

Your system will now be ready for receipt of Sanchay post related files through eMO client from central server if server details were provided.

For adding Sanchay post codes, option is available in Divisional administrator web login of eMO. Reports regarding NREG are available under Reports menu. 
Please select the eMO Office Name and update Sanchay post code used for that PO.

CLICK HEAR FOR DOWNLOAD PATCH

Collection of fee for National Eligibility cum Entrance Test (UG)-2013 under e-payment for Central Board of Secondary Education – National Biller

The following issues are reported from units while accepting the fee for NEET(UG)-2013 under e-payment in Kerala




1. The fee for SC/ST Candidates is Rs.550. But in the Point of Sale module, it doesn’t accept Rs.550. Only Rs.1000 is reflected as default in the the Point of Sale module.

2. While filling the application form through online, the candidate has to give the receipt number in 10 digits, but the receipt number generated while accepting the fee, under e-payment, is starting from serial no.1. This is not accepted while uploading the number through online, by the candidate.



Solution Provided by PTC mysore

Modification in minimum amount for National Biller for CBSE in ePayment module

1.It is noticed that the minimum exam fee for CBSE NEET-UG-2013 exam is Rs. 550/- (For SC/ST/PH).

2.Whereas it was configured as Rs. 1000/- while configuring the National Biller.

3.Hence this exl file is provided to modify the minimum amount to Rs. 561/-(550/- + 11/-)



a. Download the file ECounter_CBSE_03122012.rar and extract to get the exl file ECounter_CBSE_03122012.exl.

b. Run the exl file ECounter_CBSE_03122012.exl using scripttool.







Download the solution from here

Problems facing in MPCM 7.0 APS Version which has been recd from R&D Cell APS Centre

i)       SDS Report is not generating

ii)      Parcel Report is not generating

iii)    The 13 digit barcode RL No which are booked in civil POs  are not accepting in data  entry dispatch module.

iv)    Articles received from other FPOs for further despatch are not accepting in data entry, because the data entry module will accept only 13 digit barcode articles.  But we are not booking the Register letters using barcode. No options to change this conditions in this software

v)       No option is available to add new Speed post city.

vi)    Speed Post rate has been revised wef 01 Oct 2012.  The revised rate changes made in the Tarrif menu is showing incorrect value after calculating 12% Service tax and 3% Edn cess. The merger option of fraction value is not available in this software.  The new patch for rate change for MPCM 7.0 APS version is needed.

However the solutions for above para i & ii is available in my blog to download Click here

If any solutions (patches) available for the above remaining problems send to R&D cell(APS Centre) to circulate all  FPOs