Sub Account Supplementary Error - Printing SO Reports

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)

Download

SQL Version is 2000:

• download the attached exl files, execute with script tool(Subaccounts2000.exl, subaccounts25052010.exl, subaccounts31012011.exl)

Download