Hi everyone, i am novice to Navision. I am working on a report that needs to compare two different rows within the same same table. I want it to compare the amount where document type is finance charge memo and where the next row document type is payment being compared to the amount the payment is being applied and if the payment is less than the finance charge it should take the payment as finance charge. can someone Please help me out.
Thanks
IF "Document Type"="Document Type":: "Finance Charge Memo" THEN BEGIN
Fincharge :="Remaining Amount";
END;
IF "Document Type"="Document Type"::Payment THEN BEGIN
Principal:= "Closed by Amount";
// ***************************************************************8
IF Amount < Fincharge THEN
Fincharge := Amount;
IF Principal=0 THEN
Fincharge :=-ABS(Amount)
ELSE
// ***************************************************************8
Fincharge :=ABS(Amount)-ABS(Principal);
0
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Thank you Kirki for the reply.
And can you please elaborate more on what you were saying.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Thanks for your help.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!