<div>
Thanks Abbas! lemmie try this and get back to you!
</div>


Thanks Abbas! lemmie try this and get back to you!

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I have a bit of a scenario for which I'd really appreciate some help.<br />
<br />
I have a database that has client invoices that are churned out on a monthly basis, clients pay against these invoices. However, some clients sometimes don't pay or pay less than the invoiced amounts, some still, pre-pay.<br />
<br />
Now, I need to do a debtors aging report showing the distrubution of debts between today (current) and over120 days. I'm able to pull out all my invoiced amounts correctly to allocate them to the correct time bands (30days, 60days, 90days, 120days and over120) but I keep getting errors when it comes to over120 days payments. <br />
<br />
Any chance someone has the English query for aging so that I could adapt it to either Oracle or SQL?<br />
<br />
Any help offered most appreciated!<br />
<br />
Regards,<br />
Gezzat
</div>
</div>


Hi all,

I have a bit of a scenario for which I'd really appreciate some help.

I have a database that has client invoices that are churned out on a monthly basis, clients pay against these invoices. However, some clients sometimes don't pay or pay less than the invoiced amounts, some still, pre-pay.

Now, I need to do a debtors aging report showing the distrubution of debts between today (current) and over120 days. I'm able to pull out all my invoiced amounts correctly to allocate them to the correct time bands (30days, 60days, 90days, 120days and over120) but I keep getting errors when it comes to over120 days payments. 

Any chance someone has the English query for aging so that I could adapt it to either Oracle or SQL?

Any help offered most appreciated!

Regards,
Gezzat

Aging Report in ORACLE or MSSQL

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.