MM 7 UPDATE 8 ERROR AND SOLUTION BY CEPT

MM 7 Update 8 Issues And Solution Provided By CEPT.

Download MM7 Update 8 solution from CEPT FTP and Take Full database back and then execute Script/Update Latest Version.

Download MM7.8 Issues and Solution from CEPT, Direct Link 

Download

or

 Download from Google Drive

Speed Post DET Extraction Value Issues Fixed

Issues related to difference  in Local Speed Net Deposit / Receipt / Missent / RTS figures and Project Arrow DET Deposit / Receipt / Missent / RTS figures

Solution:

Download MM7update8 solution execute DET_25062013.exl using script Tool.

R Net Communication Issues

[Microsoft][ODBC SQL Server Driver] [ SQL Server] Could not find stored procedure P_GetBORegartilceforTransmission.

Solution

Inside MM7update8 Solution BOOfficeId_missing_RedirectedArticles_table.exl available, to solve above issues execute Exl using script Tool.

Postman 7.8 Issues

1.  VPP amount becomes 0(zero) for BO Invoiced VP Parcel Article.

2.  “Parcel in Deposit” Sub Menu under the Reports Menu is not available.

3.  Fetch from Counter for Parcel Article in supervisor  is  not coming in Receipt Side of Parcel Abstract.

Solution:

Download and Replace Latest Postman.exe on Installation file folder.

Issues:

[Microsoft][ODBC SQL Server Driver] [ SQL Server] Could not find stored procedure 

a.  MO_Insert_WithBORemarks,

b.  MO_Select_EnquiryFromBOArticlesTable,

c.  MO_Update_WithBORemarks,

d.  Par_Insert_BOArticles,

e.  Par_Insert_WithBORemarks,

f.  Par_Select_EnquiryFromBOArticlesTable,

g.  Par_Update_WithBORemarks,

h.  Reg_Insert_BOArticles,

i.  Reg_Insert_WithBORemarks,

j.  Reg_Select_EnquiryFromBOArticlesTable,

k.  Reg_Update_WithBORemarks,

l.  RegNet_Msg_BOArticlesDelivered,

m.  RegNet_Msg_BOArticlesUnDelivered,

n.  RegNet_Msg_BOParcelsDelivered,

o.  RegNet_Msg_BOParcelsUnDelivered

Solution

Execute BOTRANSACTION_DATE.exl  using script Tool.

Issues:

[Microsoft][ODBC SQL Server Driver] [ SQL Server] Could not find stored procedure 

a.   Reg_Rep_BagReceipt

b.  RegNet_Msg_BagsReceived

c.  Invalid Column Name ‘Bag_Type ‘

Solution:

Execute Bagtype.exl using script Tool.

Despatch Issues And Solution

1. Non-feeding of mobile number does not allow for completion of transaction. 
2. Speed Articles are getting fetched in the Despatch Application.
3. Even after  deleting EPP  /  SPEED bags by  Supervisor,  on  reopening of  Despatch Application, deleted bags are recreated automatically.
4. While closing Foreign Registered Articles it prompts a message that “Last two characters of Article bar code should be IN” and does not allows electronic dispatch of foreign registered articles. 
5. While scanning the articles at the time of closing bags, the Article Number area does not  gets cleared automatically  after scanning of a particular article thereby causing difficulty / delay in scanning. 
6. Error Message: “For your Circle ……….. first character of Parcel Article Barcode should be C”.
7. The last two characters of the Article Barcode should IN  -  for parcel and  Express parcel articles only.
8. Error Message: “For  your  ………..  circle  bag barcode should be in between ……… and ………… but we have received bag barcode number ………. and ……… for closing the parcel bags.
9. While closing  Speed  bag in Despatch Module, errror  message that articles should be start with R, but for Speed Articles will start with E(Ex:EN545369491IN). 
10. Error message: “Implicit conversion of varchar value to  varchar cannot be performed because the collation of … collation while opening the Unregistered Letter Bag”. 

Solution:

Download and Replace Despatch Latest exe on Installation file folder.

Execute all exl using script Tool.

Schedule (Accountant PBS) 7.8 Issues And Solution

• Pensioner DA Arrear generation.
• Deletion of PLI / RPLI unwanted Policies.

Solution:

Download and Replace Latest Schedule.exe with file folder.

Pensioner DA Arrear generation.

• Pension with 80% DA should be drawn for the months required i.e. July 2013 to Sep 2013.
• Modify (NOT NEW DA  ) the DA under  Allowances  -->  Modify  -->  Select Correct DA already configured  i.e. 80% in this case  --> Edit  --> Select 80%  config --> Enter from month 07/2013 and rate as 90%.
• Generate Arrear  Vouchers  --> Select  that particular DA which was configured as 90%...because many offices are having many DA in different names.
• Reports --> Arrears; the Arrear Vouchers shall be displayed.

Deletion of PLI / RPLI unwanted Policies.

• After running the said exe a new submenu will appear under the  “Tools”  menu named as “Delete PLI RPLI unused data from PLI Master”.
• This option will delete only those  PLI / RPLI  Policy Numbers from  PLI  Master  Table or which no transaction of any type has since been done in the office.
• In order to delete the PLI / RPLI Policies for which any transaction has take place in he office at first those particular transactions should  be get deleted first, then this 
• option to be used for deletion of  those  wrong policies,  then enter correct policy details and then re-enter those transactions which were deleted.

Courtesy : http://potools.blogspot.in