Problem in sum calculating inside 2013 report

poppins

Hi everyone,

I have a report to upgrade from nav 2009 to NAV 2013.
The report consists of two data items: Date(parent) and GL/Entry.
The following code was in the OnPreSection of a group footer related to GL/Entry dataitem in the Classic report (grouped by GL Account No.):

IF  (("Debit Amount" - "Credit Amount") > 0) THEN 
DebitG2 :=  DebitG2 + ("Debit Amount" - "Credit Amount") 

ELSE 
CreditG2:= CreditG2 + ("Debit Amount" - "Credit Amount");

END;

I inserted the same code in the OnAfterGetRecord trigger of the GL/Entry dataitem in my 2013 report ....but it isn't behaving as expected (like in 2009)...It is just returning the sum of "Debit Amount" in DebitG2 and the sum of "Credit Amount" in Credit G2.

I don't understand why is that....
What shall I do?

Tarek_Demiati

Try to initialize both variable just before your code :

DebitG2 :=  0;
CreditG2:= 0;

IF  (("Debit Amount" - "Credit Amount") > 0) THEN 
DebitG2 :=  DebitG2 + ("Debit Amount" - "Credit Amount") 

ELSE 
CreditG2:= CreditG2 + ("Debit Amount" - "Credit Amount");

END;