Tuesday, July 12, 2005

SOX Calculation

7/11/2005
Studied the manual SOX calculation

7/12/2005
Created a report, TRISBSSX in FSTRN88. Created a layout called isbs-ytd-sox-2005.xnv in development environment. This layout combines the two layouts from the income statement (GROEL/TRISYD05) and balance sheet (GROEL/TRBS2005).

Ran the reports and checked that the combined report matches the two individual report output exactly.

Added formula to identify the significant accounts based on the 1st criteria (Amount > 0.5%). Ran the report and checked that it identifies significant accounts correctly according to the formula.