SELECT ACCNO,DESP,DESP2,BF,DB,CR,BAL FROM INITFILE INTO CURSOR EXCEL_INITFILE
EXCEL_TITLE_NAME_1=LGS("Transaction Summary")
EXCEL_SUB_TITLE_1=LGS("A/C No.")
EXCEL_SUB_TITLE_2=LGS("Description")
EXCEL_SUB_TITLE_3=LGS("Description (2)")
EXCEL_SUB_TITLE_4="'" + DTOC(GETRPTDT(FPERIODB-1)+1)
EXCEL_SUB_TITLE_5=LGS("Total Debit")
EXCEL_SUB_TITLE_6=LGS("Total Credit")
EXCEL_SUB_TITLE_7="'" + DTOC(GETRPTDT(FPERIODE))
EXCEL_COMMAND_AMOUNT(4,7)
EXCEL_COMMAND_TOTAL("G")
EXCEL_COMMAND_71=[OEX.CELLS(EXCEL_TNROW+2,4).VALUE=TBALBF]
EXCEL_COMMAND_72=[OEX.CELLS(EXCEL_TNROW+2,5).VALUE=TTTDB]
EXCEL_COMMAND_73=[OEX.CELLS(EXCEL_TNROW+2,6).VALUE=TTTCR]
EXCEL_COMMAND_74=[OEX.CELLS(EXCEL_TNROW+2,7).VALUE=TBALBF + TTTDB - TTTCR]