Scribd
Upload
3 views1 page

Report Script

The document outlines steps to update the Account GL balance by modifying the GLPRTDEF table and provides SQL commands for the update. It also includes instructions for moving reports from a test area to a production area. The specific file to be copied is report.MOL, along with the necessary paths for the operation.

Uploaded by

nibro
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views1 page

Report Script

The document outlines steps to update the Account GL balance by modifying the GLPRTDEF table and provides SQL commands for the update. It also includes instructions for moving reports from a test area to a production area. The specific file to be copied is report.MOL, along with the necessary paths for the operation.

Uploaded by

nibro
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

While report Displaying blank (zero data)

Steps

Update the Account GL balance by product GL balance in GLPRTDEF


table.

SELECT * FROM GLPRTDEF WHERE GL2='07152'

UPDATE [Link]

SET PRDACCID = '07152 000000000000000000000000'

WHERE GL1 = '07100' AND GL2 = '07152' AND GL3 IS NULL AND LVL = '2'
AND LVL1 IS NULL AND LVL2 IS NULL AND LVL3 IS NULL AND PRDACCID =
'07152 000000000000000000000000' AND DRCR = 'C' AND ACCTYP = '2L';

------------------------------------------------------------------------------------------------------
-------------

07152 >> settelemt account from \to conventional

SELECT * FROM GLNAME WHERE GLCD='07152'

When its needs to move from test area to main area (report or
additional menu from the group)

 Copy [Link] from UAT AREA TO PRODUCTION AREA)


 [Link]

 D:\ISBUAT\TOMCAT6.0\WEBAPPS\OMNI\OPEN GROUP CODE =9
COPY [Link] and paste to production on the same path.

You might also like