How to Display Finance Charge Memo Amount in Report

kolaboy

Hi Experts;
I am designing a report that Should Display finance Charge amount in a report for finance charges that are already applied.
Here is a code i am using:

 IF "Finance Charge Memo" <> 0
 THEN BEGIN
 Int := "Cust. Ledger Entry". Amount;
END;

I have also used the one below:

 IF "Finance Charge Memo" <> 0
 THEN BEGIN
  Int :=  Amount;
END;

None of these are working. I am using the Detailed cust. Ledg. Entry table to pick these informatioms.
Is anything wrong with my Code? I would like to see you code that you think will solve my problem please.
Thanks.

raj2000be

Kolaboy,

I am not a programmer, but I think you should be doing a calcfield before you can assign it to an integer. This is because its a flow field.

Rajesh

kolaboy

Hi Rajesh,
The Int in the code means Interest not integer. Also the interest have been calculated already by the program when the Finance charge was applied.

Therefore i am not calculating the interest per say, instead what i want to do is just to display this finance charge memo amounts in a report, by picking it from the Detailed Cust. Ledg Entry table or the Cust. ledger Entry table
Here is the recent code i tried but it is not working. Instead it is displaying different values:

 IF "Document Type" = "Finance Charge Memo"
   THEN BEGIN
  Int :=  Amt;
END;

Any problem with the above code

I would also like to see a better code please.
Thanks.