how to add multiple cheque amount of same vendor and show single cheque printing

mdsr
mdsr Member Posts: 163
edited 2019-05-28 in NAV Three Tier
i want to print cheque,on bank payment voucher page i have added action on click of that action it giving me current selected vendor's cheque print code as follow on the action 
GenJnlLine.RESET;
GenJnlLine.SETRANGE(GenJnlLine."Journal Batch Name","Journal Batch Name");
GenJnlLine.SETRANGE(GenJnlLine."Document No.","Document No.");
REPORT.RUNMODAL(50098,TRUE,FALSE,GenJnlLine);

my requirement is that if same vendor having multiple line for cheque print it should give sum of that amount and print it as single cheque eg:vendor a have to paid by company for product a,b,c of amount 100,200,300 resp now i want print cheque as vendor name with total amount as 500 i really don't know how to do it as beginner can any body help thanks to all .

Answers

  • mdsr
    mdsr Member Posts: 163
    edited 2019-05-29
    Hey I got answer as on action i am running report so on after get record write code strange for party name and account no then use repeat until to add amount in global variable as addition gives total of all cheque belong to one vendor .Take this field report layout that's it it works for me
    Thank You

Categories