Sub account Module Error and Solution

Invalid Column name in Sub account and Solution

While doing day end in Sub Account Module it may shown the error message as Run-time error  ‘-2147217900(80040e14)’

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name ‘ebillcommission’

The above solution is applicable for Invalid column name of account head.

Solution

• Execute below two quires

execute treasury..update_megh66_accountheads
execute treasury..update_megh66_accountheads_bydate 'ddmm15'

Note : date and month at 'ddmm', for which the date sub account module last worked successfully