Issues in Sub account Supplementary and Solution

Backup Sub Account Related Databases before apply the below Solution

a. Runtime error appearing for Supplementary--Printing SO Reports-->Summary-General

b. Runtime error appearing for Supplementary--View So Details--Other Data/Closing Balance.

Snapshot of Sub Account Error Message

Incorrect Syntax Near 'Speedpo'
Incorrect Syntax Near 'IEMOP'
Incorrect Syntax Near '.' / Incorrect syntax Near '+'.
Incorrect Syntax Near 'ip
'

Solution for Incorrect Syntax Near ''

  1. CEPT Provides Solution for Incorrect Syntax Near '' in Sub Account 7.8 Supplementary .
  2. Download attached Sub account Exls from PoTools.
  3. Execute both exls using Script Tool.exe.

Download


Download

Note : This is only for Sub Account Supplementary Issues 

For Normal Sub Account Incorrect Syntax Issues Visit