run I run this fex my openbal for all accounts is zero, any thought way?

DEFINE FILE WF_GL_DETAIL_VIEW ADD
OPENBAL/D17.2=IF PERIOD LT &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN TRANSAMNT ELSE 0;
Debits/D12.2=IF PERIOD EQ &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR AND TRANSAMNT GE 0 THEN TRANSAMNT ELSE 0;
Credits/D12.2=IF PERIOD EQ &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR AND TRANSAMNT LT 0 THEN TRANSAMNT ELSE 0;
REF/A12=IF PERIOD EQ &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN REFERENCENO;
COM/A12=IF PERIOD EQ &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN COMMENT_TEXT;
TT/A2=IF PERIOD EQ &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN TRANSTYPE;
TD/MDYY=IF PERIOD EQ &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN TRANSDATE;
CLOSEBAL/D17.2=OPENBAL + Debits + Credits;
END
TABLE FILE WF_GL_DETAIL_VIEW
SUM
'OPENBAL' AS 'Opening,Balance'
'CLOSEBAL' AS 'Closing,Balance'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.CENTER' NOPRINT AS 'Ctr'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.ACCOUNTNO' AS 'Account,Number'
PRINT
'REF' AS 'Reference,Number'
'COM' AS 'Comment'
'Debits' AS 'Debit'
'Credits' AS 'Credit'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.CENTER' NOPRINT AS 'Ctr'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.ACCOUNTNO' AS 'Account,Number'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.ACCOUNTNAME' AS 'Description'
BY 'TT'
BY 'TD' AS 'Transdate'
ON WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.CENTER AS '*Total For Center' SUBTOTAL MULTILINES Debits Credits
ON WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.ACCOUNTNO AS '*Total For Account' SUBTOTAL MULTILINES Debits Credits
ON TT AS '*Total For TT' SUBTOTAL MULTILINES Debits Credits
HEADING
"&DATEtMDYY <+0> &TOD"
"P C C S T R U C T U R A L S, I N C."
"Cost Center Ranges : Detail Financial Report"
"By Cost Center, Acct Number, Trans Type and Transaction Date"
"For Period &PERIOD.Period:. Fiscal Year &FISCALYEAR.Fiscal Year:."
" "
WHERE ( PERIOD EQ &PERIOD ) AND ( FISCAL_YEAR EQ &FISCALYEAR ) AND ( PLANT GE '&PLANT1.Plant GE: Plant Is 2 Digits.' ) AND ( PLANT LE '&PLANT2.Plant LE: Plant Is 2 Digits.' );
ON TABLE SET PAGE-NUM ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF

This message has been edited. Last edited by: Kerry,

WHERE ( PERIOD EQ &PERIOD ) AND ( FISCAL_YEAR EQ &FISCALYEAR )

If this is what you are selecting, then this:

OPENBAL/D17.2=IF PERIOD LT &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN TRANSAMNT ELSE 0;

will never be true. PERIOD will never be less than &PERIOD.

Defines are done after a record is selected for further processing.