Our client uses pre-printed remittance-with-cheque stationary. The cheque number is pre-printed on each page. This means that a cheque number is used per remittance page. When we print cheques using report object 1401 it prints the cheque number on the first page, but prints the actual cheque on the last page. So the two differ. Also it only increments the 'Last Cheque No.' field on the bank once, irrespective of the number of pages printed.
Has anyone else encountered (and hopefully resolved) this problem ?
You can chnage the report to allow more Detail Lines per page than 10 - we have the ability to print up to 25 lines of detail per check. This is an amount that I know we will never go passed so the solution of changing the maxiteration to 25 works as a solution for us.
I recieve checks all the time from Chain type customers where they pay 300 invoices or more. They send a seperate report that has the complete check details.
I have read posts about doing the same in Nav and it is possible. Therefore keeping the check to 1 sheet instead of getting the "Void" when the check becomes multiple pages. And still providing the receiver of the check to see what inv and/or cm you are taking to pay them. We also use preprinted checks and a two page check is hopefully the last check else the whole run is off.
It shouldn't be hard to generate a check report. Basically what you need to do is exactly like when you go to the Vendor Ledger entries. Click on a payment->Application->Applied Enties
Harry Ruiz - Dynamics NAV MVPwww.CosmeticSolutions.bizwww.DreamTheater.net
I modified the report to print a header section for the CheckPages dataitem, instead of a body section.
I cut the following code from the OnAfterGetRecord trigger for the dataitem and pasted it into the OnPreSection of the new header section (as mentioned above) and now it works.
UseCheckNo := INCSTR(UseCheckNo);IF NOT TestPrint THEN CheckNoText := UseCheckNoELSE CheckNoText := Text011;
It prints the cheque number on each page, but correctly applies the cheque number from the last page to the resulting ledger entries.
I also had to set the 'NewPagePerRecord' to be true for the GenJnlLine dataitem and PrintOnEveryPage to be true for the new CheckPages header section.
Thanks for your help