How to Calculate or Fetch "No of Days Credit " and "Outstanding Amount as per No of Credit days " In Customer aging Report ??

[hiriyappa_myageri]

Hi Experts,

I have got a Issue from My Client On Customer Aging Report .

the output columns Like this 

Company code,

Marketing Area Code ,

Marketing Area,

Party code ,

Customer name ,

2-31,

31-62,

62-93,

93-123,

123-153,

<153,

Total,

Closing Amount.

Now They want Two More Additional Columns   " No of Days Credit "  and "Outstanding Amount as per No of Credit Days".

Their Requirement Like this .

01. After The Name of Customer – Please arrange Column *“No of Days

Credit”

02. After the Total – Please arrange Column “Outstanding Amount as

per No of Credit Days” .

My Client Need This Requirement .
if any one Know how to calculate or fetch  "No of Days Credit " and "Outstanding Amount as per No of Credit Days "
Please let me Know .

Thanks & Regards ,

Hiriz...

[former_member205178]

Hi,

You could use the Payment Terms from the Customer Master of the Payer[If it is not the same as Sold to Party] and take the Outstanding Balance from the FI Standard Reports for more than the Credit Days.