Aging report


How to create ageing report by using following columns in below provided format.Pleaselet me know the solution.

Columns:Customer,Debit,Credit,Days past due

Format:
Days(0 to 180) |Days(180-365) | Days(>365)|

Customer|Credit|Debit|Credit|Debit|Credit|Debit|

abc | 3344 |12000 |400 |36000 |100 |12000 |
xyz | 1340 |12300 |400 |3600 |300 |11000 |



case when cast(Days as int) <180 then 'Days(0-180 days)'
when cast(Days as int) >= 180 and Days < 365 then 'Days(180-365 days)'
when cast(Days as int) >365 then 'Days(>365 days)'
end

No comments:

Post a Comment

Popular Posts