Skip to Content
avatar image
Former Member

Customising AR report

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 29, 2014 at 07:21 AM


    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?



    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2014 at 11:41 AM

    Hi Jonalie,

    Please re-post to the SAP Business One Application


    Add comment
    10|10000 characters needed characters exceeded