Issues in Sub account Supplementary and 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

Supplementary_Accounts solution

Supplementary_Accounts solution 

Click here for view

Click here for Download

SUPLIMENTARY SOLUTION

suplimentary problem in HO's download below sql query and run in query analyer using supplusubaccount database


DOWNLOAD

suplimentary problem in so's download below sql query and run in query analyer using supplusubaccount database
DOANLOAD