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)|
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
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