| Ageing Report [message #500375] |
Sun, 20 March 2011 07:17  |
|
|
I have one view which displays the information of all the receipts with date now i want to make ageing report based on this date. the columns will be
0-30 , 30-60,60-180 and > 180 , i want to distribute the receipts qty based on number of days.
|
|
|
|
| Re: Ageing Report [message #500394 is a reply to message #500375] |
Sun, 20 March 2011 12:04  |
 |
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
OK, so what is the question?
Number of days is calculated upon ... which date? Sysdate? So subtract SYSDATE - VIEW.DATE_COLUMN and you'll know how many days has passed. CASE could be a good choice here. However, as you use Reports 6i, I'm not sure 6i's engine supports CASE (but you'll know once you try it). Perhaps you could recreate a view and add that "period" column into the view itself, which would make a report quite an easy task.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
