SSRS Cheque Printing

Finance and Operations/AX Developer Forum
1

Hi to All,

Please help me on printing cheque in ax 2012 ssrs. My requirement is i need to print invoices in top of the cheque and middle of the cheque as usual amount,recipient,date, address. Middle of the part is printing properly. But top of cheque only one invoice is printing. All invoices must be print in top of cheque.

I used classes are ChequeDp and Cheque Controller and tables are chequetmp and tmpchequeprintout. While using the chequeDp Class only one invoice is printing. I need to print all invoices.

Thanks,

2

pls suggest me

3

thanks,

i finished the above post.

4

Hi Ali,

Please can you let us know how you managed to solve this issue? I am sure this will info will be of use to someone someday.

Thanks in advance,

5

Hi Harish,

Sorry for late reply. I am providing solution for above post .

There is mainly BankChequePrint, VendOutPaym_Cheque, ChequeController, CustVendCheque, ChequeDp Classes are involved.

We need to write code in CustVendCheque Class . In this Class there is a Output Method. In this method add the following code.

while select crosscompany

specTrans

order by

specTrans.RecId

where specTrans.SpecTableId == tableNum

(LedgerJournalTrans) &&

specTrans.SpecRecId == ledgerJournalTrans.RecId &&

specTrans.SpecCompany == ledgerJournalTrans.company()

{

vendTrans = specTrans.vendTrans();

ttsBegin

;

chequeInvoicesTmp.Invoice = vendTrans.Invoice;

chequeInvoicesTmp.InvoiceDate = vendTrans.documentInvoiceDate();

chequeInvoicesTmp.AmountCur = VendInvoiceJour::findFromVendTrans(vendTrans.Invoice,vendTrans.TransDate,vendTrans.AccountNum).InvoiceAmount;

chequeInvoicesTmp.AmountPaid = specTrans.Balance01;

chequeInvoicesTmp.Discount = specTrans.getPossibleCashDiscAmount(ledgerJournalTrans.TransDate, VendPaymModeTable::discGraceDays(ledgerJournalTrans.PaymMode));

chequeInvoicesTmp.NetAmountPaid = chequeInvoicesTmp.AmountCur + chequeInvoicesTmp.Discount;

chequeInvoicesTmp.ChequeNum = ledgerJournalTrans.BankChequeNum;

chequeInvoicesTmp.SerialNumber =

1

;

chequeInvoicesTmp.insert();

ttsCommit

;

We need to add same fields in ChequeDp and VendOutPaym_Cheque classes. VendOutPaymclass there is a method PrintDocument .In this method we need to add the same fields and design the report as per requirement in visual studio.

Thanks,

ali.

6

Thanx Ali, It helped me too. :slight_smile: