SELECT ACCNO,NAME,NAME2,OPENING,INVOICE,D_NOTE,C_NOTE,PAYMENT,R_CHEQUE,BALANCE FROM INITFILE INTO CURSOR EXCEL_INITFILE
EXCEL_TITLE_NAME_1=LGS(IIF(FT="AR","Debtors Transaction Summary","Creditors Transaction Summary"))
EXCEL_SUB_TITLE_1=LGS("A/C No.")
EXCEL_SUB_TITLE_2=LGS("Name")
EXCEL_SUB_TITLE_3=LGS("Name (2)")
EXCEL_SUB_TITLE_4="'" + DTOC(GETRPTDT(FPERIODB-1)+1)
EXCEL_SUB_TITLE_5=LGS("Invoice")
EXCEL_SUB_TITLE_6=LGS("Debit Note")
EXCEL_SUB_TITLE_7=LGS("Credit Note")
EXCEL_SUB_TITLE_8=LGS("Payment")
EXCEL_SUB_TITLE_9=LGS("Return Chq.")
EXCEL_SUB_TITLE_10="'" + DTOC(GETRPTDT(FPERIODE))
EXCEL_COMMAND_AMOUNT(4,10)
EXCEL_COMMAND_TOTAL("J")
EXCEL_COMMAND_71=[OEX.CELLS(EXCEL_TNROW+2,4).VALUE=TBALBF]
EXCEL_COMMAND_72=[OEX.CELLS(EXCEL_TNROW+2,5).VALUE=TTTII]
EXCEL_COMMAND_73=[OEX.CELLS(EXCEL_TNROW+2,6).VALUE=TTTDD]
EXCEL_COMMAND_74=[OEX.CELLS(EXCEL_TNROW+2,7).VALUE=TTTCC]
EXCEL_COMMAND_75=[OEX.CELLS(EXCEL_TNROW+2,8).VALUE=TTTPP]
EXCEL_COMMAND_76=[OEX.CELLS(EXCEL_TNROW+2,9).VALUE=TTTRR]
EXCEL_COMMAND_77=[OEX.CELLS(EXCEL_TNROW+2,10).VALUE=TBALBF + TTTII + TTTDD - TTTCC - TTTPP + TTTRR]