Skip to Content
0
Former Member
Oct 11, 2010 at 07:22 PM

BPS - Making total value not changable

24 Views

Hello Gurus,

I am having a simple layout ( as below) wherein total value is distributed equally across Terms on service. Say I have total values = 100 and Terms = 10, then for every month, the amount is 10.

Transaction_ID Month Amount

1001 Jan 10

1001 Feb 10

1001 Mar 10

1001 Apr 10

1001 may 10

1001 June 10

1001 July 10

1001 Aug 10

1001 Sep 10

1001 Oct 10

============================

Total 100

However, the amount fileds for individual month is editable and user can change values there if they want to. Ex: say for month FEB, user changed values from 10 to 20, then total is getting changed from 100 to 110.

Is there any way to avoid total to change ? can we keep total same all the time? Later I would like to display the messge saying that total amount cannot be changed, so that if user increasing individual month, they have reduce for some other place.

Transaction_ID Month Amount

1001 Jan 10

1001 Feb 20

1001 Mar 10

1001 Apr 10

1001 may 10

1001 June 10

1001 July 10

1001 Aug 10

1001 Sep 10

1001 Oct 10

============================

Total 110