• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Want to Display Customer Aging Data In Report Header

abhay123

Active Member
I created one custom sales report want Aging data of Customer in header of the report like Credit balance, Over Credit Limit, Credit Limit, 31-60, 61-90, 91-120 etc.. (This data is available in P40250 application)
I fetched credit limit from customer master and the rest of the field I tried to retrieve using F0311 Accumulate A/R Balance BSFN for Aging data, but I am unable to retrieve this data in my report so please guys help me in this how to calculate this field?

Any help you can offer would be greatly appreciated.

Thanks.....
 
Last edited:

rsvconsulting

VIP Member
Take a look at the F03B15 as the data you require resides there. This table is populated when you generate the R03B525, credit analysis refresh. You will need to create a process flow that defines the steps to be completed prior to running the custom report. These steps will include invoicing, cash application, deduction processing, etc. and then culminate with the credit analysis refresh.
 

abhay123

Active Member
It seems F03B15 is workfile and not possible to create a process flow bcz after each sales order user going to generate this custom report. Actually, I need step to calculate this aging field directly in my report header.

Thanks.....
 
Top