Forum Discussion

MAAO's avatar
MAAO
Regular Visitor
3 years ago

Customer Ageing Table

Hi,

I was trying to build a report as per attached sample and couldn't complete it after several trials. I am not sure if it's possible to bulid and present it or no.

 

Simply, the report is showing customer ageing balance per invoice/ customer/ country "buckets wise", and another column to show provision taken and total colection per week. It's a comprehensive report that support differnt aspects.

 

my issue is how to add a column for provision and weekly colletcion without showing it under buckets (Highlighted in Red).

 

Business UnitCustomer MasterA 01-30B 31-60C 61-90D 91-120E 121-180F 181-360G +360TTL Before ProvProvTTL After ProvCollection Week 1Collection Week 2Collection Week 3Collection Week 4TTL ColletcionNet Due
CongoAir France 100100   100300(50)25000(30) (30)220
CongoAir Rwanda      100100(50)5000(30) (30)20
CongoFedex 100100100100100 500(20)48000(30) (30)450
CongoToyota 100100100100  400(50)35000(30) (30)320
MoroccoHilton 100100 100100100500(40)46000(30) (30)430
MoroccoBYC 100100100100100100600(50)55000(30) (30)520
MoroccoICT  100 100  200(50)15000(30) (30)120
MoroccoJambo 100100    200(50)15000(30) (30)120
                  
  06007003005003004002,800(360)2,44000(240)0(240)2,200

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi MAAO ,

     

    Do you want to add columns which are highlighted in red?
    Here I have some questions:
    1. how can we get data in red, are they in your data model?
    2. what result do you want?
    I think your calculation is based on your data model. Please share a sample file with me and show me a screenshot with the result you want.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.