Customising AR report

[Former Member]

Good Day!

SAP business one has recently been implemented in our company, thus many of us are still unfamiliar with the processes and capabilities of the system. Recently, our boss has asked our department to create a customised AR statement. We currently have the following information accounted for using the SAP crystal reports:

    1. CardCode [BP Code]

     2. CardName [BP Name]

     3. ItemCode

     4. DocDate

     5. DocDueDate

     6. Gross Price

     7. Instalments

     8. Account Balance

     9. Total Paid Sum

However, we are lacking some information namely the: current monthly due (0-30 days) as well as arrears for the past 60-90 days and the over 90+ days due. How do we incorporate these information to the crystal report? We tried researching in the internet, but it's not very friendly to beginners.

Thank you so much for any help!

[abhilash_kumar]

Hi Jonalie,

Please re-post to the

-Abhilash

[raghavendra_hullur]

Hi,

Can you explain more on what you want to display for Current Monthly Due or 60-90 days or 90+ days?

Is it the count of records or summary of some amount field(s) for those 3 categories?

Where that information needs to be displayed (detail section or under group or report footer?)

What is the field to be due date (DocDueDate?) and due to be calculated from current date?

Thanks,

Raghavendra