accumulated balance in page 20

kanika

Hi experts!! NAV2017

I need to add a field on the page with the accumulated balance, like the example





I wrote this code in the OnAfterGetRecord () trigger

IF NOT blnPrimero THEN BEGIN
decAcumulado:=0;
blnPrimero:=TRUE;
END;
decAcumulado+=Amount;

but it does not work

please any suggestions!!

allenyyzhou

Hi

Just my personal suggestion.

Add accumulated field in Page is not a good practice. Do this in report.
If you really want to do, add accumulated field in table, create a new page and calculate it by action.

kanika

but why???
why is not a good practice??
and
why a new page?

allenyyzhou

Hi

Well, performace is one concern, and the control of filtering, sorting is another concern.
Again, just my personal opinion.

kanika

I thank all the opinions, it is for having a more extensive information

Slawek_Guzek

I would not be concerned about any performance issues. What you do is a simply math operation, you would have to run tens of thousands of them to see any impact.

The trouble with Pages is the control of calculation. How do you reset the blnPrimero when user clicks one of headers and change soting order? Or add a filter to get a subset of records?

I would agreed with @allenyyzhou - do it on a report. This is the a place where you can get it working much easier.

kanika

the question is that as it works well except the first line, from the second the balance is correct until the end

Slawek_Guzek

OnAfterGetRecord is not guaranteed to fire only once on the page . And this is exacly what happend here: it was fired 5 times: 1st on 1st line, then on 2nd, then on 3rd line and then 2 times more on the first one.

Even order in which the records are fetched is not guaranteed. Try scrolling a few lines an then try PageUp or PageDown.

If you want do do this on the page you would need to build much more complicated logic to control when to add up the amount and when to reset it back to 0.