SELECT A.ACCNO,A.NAME,A.NAME2,A.DATE,A.TYPE,LEFT(A.REFNO,10),A.DESP,A.AGE15,A.AGE14,A.AGE13,A.AGE12,A.AGE11,A.AGE10,B.AGE15+B.AGE14+B.AGE13+B.AGE12+B.AGE11+B.AGE10 FROM DETAIL A LEFT JOIN XDETAIL B ON (A.TYPE+A.REFNO=B.TYPE) INTO CURSOR EXCEL_INITFILE
EXCEL_TITLE_NAME_1=LGS(IIF(FT="AR","Debtors Detail Aging Reports","Creditors Detail Aging Reports"))
EXCEL_TITLE_NAME_2="{"+DTOC(RPTDATE)+"}"
EXCEL_SUB_TITLE_1=IIF(FT="AR","Cust.No.","Supp.No.")
EXCEL_SUB_TITLE_2="Name"
EXCEL_SUB_TITLE_3="Name (2)"
EXCEL_SUB_TITLE_4="Date"
EXCEL_SUB_TITLE_5="Type"
EXCEL_SUB_TITLE_6="Refno"
EXCEL_SUB_TITLE_7="Desp"
EXCEL_SUB_TITLE_8="5 Mths+"
EXCEL_SUB_TITLE_9="4 Mths"
EXCEL_SUB_TITLE_10="3 Mths"
EXCEL_SUB_TITLE_11="2 Mths"
EXCEL_SUB_TITLE_12="1 Mth"
EXCEL_SUB_TITLE_13="Current"
EXCEL_SUB_TITLE_14=iif(forl="F","Local","Foreign")
EXCEL_COMMAND_AMOUNT(8,14)
EXCEL_COMMAND_LINE("N")