Good for sharing.. at least I can refer back in case I forget...haha
Assume you enter the following Trx:
Invoice Date.............Invoice No......... Amount
01/01/2012 ..............1234................$2000
01/02/2012 ..............1235................$5000
In the Report Design
Invoice Date....Invoice No....... Amount............30 days........60 days...
BO.Date........BO.InvoiceNo...[BO.Amount]..[BO.Amount].....[BO.Amount]
On the 30 Days: BO.Amount, enter the condition:
DAY_DIFFERENCE2(CURRENT_DATE,BO.INVOICEDATE)<=30
On the 60 Days: BO.Amount, enter the condition:
DAY_DIFFERENCE2(CURRENT_DATE,BO.INVOICEDATE)>30 AND DAY_DIFFERENCE2(CURRENT_DATE,BO.INVOICEDATE)<=60
That is...cool..
May be there is a short way... please share...
