SUB ACCOUNT 7.9.3 INCORRECT SYNTAX NEAR 'TEL'

Incorrect Syntax Near 'Tel' In Sub Account

After Upgrade MM 7.9.3, While taking printout of General Reports in Sub Accounts in may shown the error message as 

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

[Microsoft][ODBE SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'tel'.

Solution

• Download attach script which is given by CEPT for the above mentioned problem.
• The same may be executed with the help of System Administrator.

Download

Read More

SUB ACCOUNT TABLE CREATION ERROR AND SOLUTION in 7.9.3

Sub Account 7.9.3 Invalid Object Name Error

After upgrade MM 7.9, while doing data entry in BO / SO Account in Sub Account it may shown the below error 

The above error message due to improper updation of fields data in Subtreasury database. This may be recover two ways.

• Restore Old database then do the up gradation properly.

Do Re Day begin in Sub Account

In the Supervisor menu there is an option > Undo Day's work. This will delete the tables created while making Day Begin. Then correct the server date to current date. Login to Sub Accounts. Make the Day Begin for current date. 

Note : the above solution is also applicable for by mistake the day Begin is being done to a future date. 

Read More

INVOICE SPEED POST ARTICLE ERROR IN SPEED NET 4.3

Speed 4.3 Invoice Error And Solution

Error Message : 

Could not find stored procedure ARN_ValidateHCPODBarcodePrefix

Solution

• Download and Execute the script file  ARN_ValidateHCPODBarcodePrefix.exl using ScriptTool.exe 
• First Take full backup of POSPCC database then execute the above script.

Download Validate HCPOD Barcode Prefix Solution

Read More

SPEED NET 4.3 UPGRADATION PROBLEM - OLD VERSION DETECTED

Speed Net database upgrade issues

Attempt to login with old version of Speed Net detected. Please upgrade to the latest Version of Speed Net 4.3 Release dated 15.07.2015 and then try login

Solution For Speed Net 4.3 Update Problem

• Solution for the referred issue is available at CEPT FTP site. 
• The office concerned need to do the following: Go to

ftp://cept.gov.in/SpeedNet/Speednet4.3/Utilities/ 

• and click on directory "Speednet 4.3 Version Script Solution".
• Now, download POSPCC_V43_09102015.exl file and run the script.

Download

Read More

POINTS TO REMEMBER WHILE UPGRADE SPEED NET 4.3

Speed Net 4.3 Up Gradation Issues And Solution

After Upgrade to Speed Net, the following error may come due to the improper configuration. Check the following point after upgrade the Speed Net 4.3 to transmit /receive the files without any issues.

Issues Noticed

Communication module not working / Files not transmitting/ receiving after upgrade.

Solution

Once Speed Net 4.3 is updated check the followings,

Step 1:

• Supervisor --> Master --> Environment --> Folder Paths --> please check whether Meghdoot Point of Sale Information is provided correctly or not. 

If not correct then correct it (i.e., tick the option Meghdoot - Point of Sale is installed and under use in this office, click on the option Point of Sale and SpeedNet are connected through Network and enter the correct SQL Server Name where Point of Sale Databases are installed)

Step2

• Open the hosts file (c:\windows\system32\drivers\etc) 
• Add the below entry

103.244.127.226 speednetmsg.ptcmysore.gov.in

Read More

SPEED NET 4.3 BNPL DISTANCE SLAP CONFIGURATION AND SOLUTION

After updating SpeedNet to version 4.3 it shows error in BNPL speed post booking. While trying to do data entry of BNPL article it shows an error 

"The office with the pincode......is not found in the office master list. Please update the office master database first and retry". 

The required cities are added with appropriate distance slab freshly after updating the software. 

All the added pincodes are properly mapped with distance. Mapping is done from 'Supervisor --> bulk customers --> Configuration --> cities'. I have also checked 'Supervisor --> bulk customers --> Configuration --> Map Pincode - Distance Slab' window and there is no unmapped offices shown in the list. The error message tales that 

'Please update the office master database first and retry'. 

Is there any way to upload the office master data to database from the 'office master' text file available in the SpeedNet folder.

Yes. 

Procedure To Upload Office Master

Please do the following for updating the latest offices master data: 

• Download the latest office master file from the Speednet MIS. 
• Update the offices data using the option in Speednet communication-->Update Offices. 
• Update the offices data under 

Supervisor-->Master-->Offices-->Add Additional Offices-->Update option. 

• Enter the pincode and click on fetch button. In case details for the required offices are available, then the office master updation is done properly. Else, do the office master updation once again. 
• If pincode details are available, update the pincode - distance slab mapping under 

'Supervisor --> bulk customers --> Configuration --> Map Pincode - Distance Slab' window.

Read More