Customer summary Aging

Business Central/NAV User Forum
1

Hi All,

In the customer summary aging report we have to option of providing the Period length and start date.

Once i provide that say (15d and work date) it shows 5 periods (before, 3 periods from current date and after).

before, 05/10/09…06/11/09, 06/11/09…07/11/09/, 07/11/09…08/12/09 and after.

Now the requirement i have is i need 6 periods from current date, a before and an after.

before, 05/10/09…06/11/09, 06/11/09…07/11/09/, 07/11/09…08/12/09, 07/12/09…08/01/10, 09/02/10…11/03/10, 12/03/09…13/04/10 and after.

harsha

2

you can customize the report to add additional periods…you will need some technical skills for it.

the PeriodStartDate,CustBalanceDue, etc variables’ dimension need to be increased, and their values extended in prereport, customer and integer dataitem sections.

you may even need to change the layout of report to accommodate additional columns.

3

In the code the period start date has been set to a default value of 5 …

i checked the local variables and globals its just defined as a date obj…

how do i increase the size of the obj … according to me we have change the array size and the for loop.

please assist me how to go about…

harsha

4

go to the properties of Global variable PeriodStartDate and increase the dimension value.

i hope this is what you were asking.

5

thanks :slight_smile: