Latest Posts

Loading...

Monday, July 15, 2013

WNX Airway Bill Range Expiry Date Update

Department of Posts, India
Office of the Chief Postmaster General
Orissa Circle, Bhubaneswar –751 001

No BD/16-51/2009  (Sub)                                              Dated at Bhubaneswar, the 12.07.2013

To
            The SSPOs/SPOs
Bhubaneswar /Cuttack City/ Puri/Cuttack South/Balasore/Dhenkanal/Cuttack North/ Berhampur/Sundergarh/Sambalpur/Koraput/ Bhadrak Division,

Sub:-    WNX Airway Bill Range Expiry Date Update

            e-mail dtd.24.02.2013 in original from Director foreign post, Mumbai in original are sent herewith for  further necessary action.
 Encl: As above
                        Asst. Director (BD& Marketing)
O/o the Chief PMG, Orissa Circle
Bhubaneswar –751 001
Copy for information:-
The Sr. Postmasters/Postmasters,
Bhubaneswar GPO/ Ashok Nagar MDG/Saheed Nagar MDG/KIIT SO/Utkal University MDG/Cuttack  GPO/ Chandinichowk HO/College Square MDG/Puri HO/Konark SO/Pipili SO/Paradeep MDG/Balasore HO/Angul HO/Kendrapara HO/Berhampur HO/Rourkela HO/Sambalpur HO/Rayagada HO/Uditnagar HO/Sundergarh HO/Dhenkanal HO/Bhadrak HO/Jajpur RD SO/Jajpur HO/Jharsuguda HO/Jatni MDG/Khandagiri SO

 Asst. Director (BD& Marketing)
O/o the Chief PMG, Orissa Circle
Bhubaneswar –751 001



---------- Forwarded message ----------
From: Tridev Ghosh (DHL IN) <Tridev.Ghosh@dhl.com>
Date: 29 June 2013 12:55
Subject: FW: Topmost Urgent :WNX Airway Bill Range Expiry Date Update
To: "adtobdfsori@gmail.com" <adtobdfsori@gmail.com>

 Dear Sir
It has been noted that many of the Post Offices haven’t still implemented this even after Director has passed this order to all the circles on 24th Jun. kindly pass a circular that they should get this done by Tuesday positively

To the System Administrators

             Airway Bills/Article series provided to all authorized WNX booking/approved post offices would get expire on 27.06.2013. Post offices will not be able to use POS to book WNX shipments without changing the expiry date or up loading of new airway bill series.

These airway bill series date can be updated till 31.12.2014 by changing the expiry date in the SQL Database for which attached SQL SCRIPT TOOL needs to updated in the server.

This exercise will help us to replenish the existing airway bill series for the next 18 months.

Below is process for update.

1.         Copy the script tool in Post office server pc in SQL counter database of WNX AWB bill series tables
2.         Then execute the file thru SQL query tool analyzer
3.         Once update is done, the date will change 2014/12/31 & to check this you need to go in SQL database>Counter>WNX Airwaybill table>

Below the script (also in the file attached herewith, in case the file is not there in the email copy the same in the notepad and run)

ifexists(select 1 from WNX_AWBNumber Where ExpiredDate <='2013/06/27')
BEGIN
Update WNX_AWBNumber
Set ExpiredDate='2014/12/31'
Where FreeAWBNumber='Yes'and NewAWBNumber='Yes'andCancel='N'
END

Please have this circulate to all the circle for further distribution to the respective POand system administrators to run this to have date changed.

 any queries the system administrators can call Rakesh Joshi  on 09769492880 or write to him at Rakesh.Joshi@dhl.com


 Best Regards
Tridev Ghosh
Territory Manager- East
Mob- (+91) 9674167294
DID-   (+91) 33 66115239
Board -             66115222
Toll Free- 1800 2332 969

No comments:

Post a Comment