Sub Account Supplementary Printing Error

Take Backup of All Sub Account Related databases before apply this solution.

Error:

while printing the option Supplementary-->printing SO reports--> SO days figure, error occurs "Incorrect Syntax near the keyword "

Solution:

SQL Version is 2005:
  • download the attached exl file and execute with script tool (Subaccounts2005.exl)

SQL Version is 2000:
  • download the attached exl files, execute with script tool(Subaccounts2000.exl, subaccounts25052010.exl, subaccounts31012011.exl)