Showing posts with label SUPLIMENTARY SOLUTION. Show all posts
Showing posts with label SUPLIMENTARY SOLUTION. Show all posts

02 April 2014

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

01 April 2011

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