Meghdoot 7.0 - Treasury - Account Head Creation Problem in C class office

Problem :

While creating account head in Treasury module one error is showing as mentioned in the attached file.This one is a C class office using meghdoot Version 7.0 and SQL Express Management Studio 2008.

Solution by PTC, Mysore

Downloads (Click Below)

1. SUBACCOUNTS18052011_ Add New Account Head.exl

2. BOSUBACCOUNTS18052011_ Add New Account Head.exl

Run the above attached files with script tool to solve the problem.

-

With Regards

Help Desk
Center for Excellence in Postal Technology
Postal Training Center Campus
Mysore 570010
Karnataka , India
Ph: +918212449015
Fax: +918212440526

Meghdoot Account Head Problem

Pl. Download the latest Treasury21032011.exl from Meghdoot update 28032011 folder under meghdootv6.6 ...
run it with script tool .. after that .. pl. run the following two queries in sql query analyzer ..

execute treasury..update_megh66_accountheads

execute treasury..update_megh66_accountheads_bydate 'ddmm11'


(Pl. mention date and month at 'ddmm', for which the day begin was performed in subaccounts module)

Solution received from
Help Desk, PTC Mysore


Download

Adding Account Head Error in Treasury Module

Download and Update this exl file given by PTC,

Download

Meghdoot Account Head Problem

Meghdoot Account Head problem - after upgradation of Meghdoot Service pack ( TNEB, etc)

Please run the attached treasury14012011.exl with script tool for the log errors came while executing the Treasury script.

Download then execute the following Query in SQL Query Analayzer for updating the account heads to the current date in the given format.   'ddmmyy'

Execute Treasury..Update_Megh66_Accountheads_bydate 'ddmmyy'

Download

Error while taking Sub office Monthly Report

While taking sub office monthly report an error comes.

Run time error Microsoft odbc sql server driver ' the definition for column money ' must include a data type.

Execute the attached script through script tool selecting treasury database

Download  or Download

Treasury Updates dtd 18/09/2010

Solution regarding MO Value & Commission problem in daily account received from PTC, Mysore


Pl. download the attached file and run with script tool executor ..   

after this .. pl. execute the queries mentioned below  in SQL Query Analyzer ...

Execute treasury..update_megh66_accountheads_bydate 'ddmm10' 

(Pl. mention date and month at 'ddmm', for which the day begin was performed in subaccounts module)

With this the heads MO Commission and IPO Commission will be available for data entry of SO Daily Accounts...


Download 

Treasury Account Head Problem

Download and  run attached exl.  ( Download )

execute the attached script using script tool.
if the accountheads are required for the current date execute the following:

use treasury
go
update_megh66_accountheads

if the accountheads are required for a particular date:


use treasury
go
update_megh66_accountheads_bydate 'ddmmyy'


in this ddmmyy explanation is as follows:
if the date is 02/06/2010 then it will be equal dd/mm/yyyy so the ddmmyy will be 020610. This can be applied to any date on the same analogy.