Recently, Turnkey was asked to streamline the printing of AP checks in Business Central on preprinted check stock such that checks with more than ten remittance lines would not generate voided checks. Out of the box, if there are more than ten remittance lines, the Check/Stub/Stub report will print a voided check, then ten remittance lines, then a voided check, ten more remittance lines, et cetera, until all remittances have been printed, with the last page of the report containing the non-voided legal tender check. If a check is cut with less than ten remittances, that is not an issue, as the one page contains the legal check stock and then the two sections of remittances. If, for example, a check is cut that contains 45 remittances, the following occurs:
A voided check for the full amount is printed.
Ten remittances are listed in each of Section 1 and Section 2.
Another voided check for the full amount is printed.
Ten more remittances are listed in each of Section 1 and Section 2.
A third voided check for the full amount is printed.
Ten more remittances are listed in each of Section 1 and Section 2, taking us to thirty total remittance lines.
A fourth voided check for the full amount is printed.
Ten more remittance lines are printed.
A legal check for the full amount is generated.
A final remittance page of five remittances is printed.
This is standard and by-design behavior and it cannot be modified via customizing the check layout or configuration within the BC environment. Thus, the only way to circumvent this functionality is to create a custom report and extension, which Turnkey has done with great success for a client that routinely prints consolidated checks per vendor on preprinted check stock.
To prevent the unnecessary check voiding, the Turnkey extension will detect when there are more than ten remittance lines and will simply output Please see attachment, which can contain a hard copy of the check remittances, generated via a remittance report in Business Central or through an Excel workbook. Turnkey can also modify the process further, if necessary, to print an Excel file of all check remittance lines but that is not a part of the current solution.
