T
tr2usa
Customer No. Customer Name/ Document No. InvoiceDate DueDate Current 1
To 30 31 To 60 61 To 90
1618 ABCH COMPANY Contact:
Address:
IN IN83749 8/8/2005 11/7/2005
IN IN84487 9/16/2005 12/16/2005
IN IN85225 10/24/2005 1/22/2006
IN IN86259 12/14/2005 3/14/2006
IN IN87865 3/27/2006 6/25/2006
IN IN90476 8/29/2006 11/27/2006 6,262.00
Customer Total : 6,262.00 0.00 0.00 0.00
A075AZ AUERHAUSE
Address:
CR CN41983 9/25/2006 9/25/2006 -2,526.00
Customer Total : 0.00 -2,526.00 0.00 0.00
I have this AR Aging with details but I need summary of (1 To 30 31 To
60 61 To 90
next to customer ID). I tried Index and Match but did not work.I need
help to bring all CUSTOMER TOTALS: under (1 To 30//31 To 60// 61 To 90)
next to Customer ID and loose the rest of the data. Can someone help me?
To 30 31 To 60 61 To 90
1618 ABCH COMPANY Contact:
Address:
IN IN83749 8/8/2005 11/7/2005
IN IN84487 9/16/2005 12/16/2005
IN IN85225 10/24/2005 1/22/2006
IN IN86259 12/14/2005 3/14/2006
IN IN87865 3/27/2006 6/25/2006
IN IN90476 8/29/2006 11/27/2006 6,262.00
Customer Total : 6,262.00 0.00 0.00 0.00
A075AZ AUERHAUSE
Address:
CR CN41983 9/25/2006 9/25/2006 -2,526.00
Customer Total : 0.00 -2,526.00 0.00 0.00
I have this AR Aging with details but I need summary of (1 To 30 31 To
60 61 To 90
next to customer ID). I tried Index and Match but did not work.I need
help to bring all CUSTOMER TOTALS: under (1 To 30//31 To 60// 61 To 90)
next to Customer ID and loose the rest of the data. Can someone help me?