Wednesday, November 2, 2011

Sub Account Day End Error

Error : At the time of SubAccounts Day End

Invalid column name ‘pliotl’

Pl. download the attached file from http://www.sendspace.com/file/0lz1dk
and run with script tool executor
After this .. pl. execute the queries mentioned below in SQL Query Analyzer ...
update_megh66_accountheads_bydate 'ddmm10'
(Pl. mention date and month at 'ddmm', for which the day begin was performed in subaccounts module)