Dynamics Community Forum Thread Details

BC Check/Stub/Stub report: how to print “See attached”on stubs with separate detailed descriptions

Hi,

I'm customizing the Base Report 10411: Check (Check/Stub/Stub) in Business Central and need help limiting the report to print only 1 page when there are more than 10 invoice lines in the payment journal.

Current Standard Behavior: When I print a check for a vendor with more than 10 invoice lines in the payment journal (using "One Check per Vendor per Document No."): it generates the attached format of-

pg1 : Void check +stubs of invoices 1-10

pg2 : Total check amount = stubs of invoices 11-12

and so on... if there are more invoices.

But the requirement is: One page Check/Stub/Stub report with "See Attached" on both stub sections (no invoice details) and Separate pages with all invoice details (if more than 10) - these can print on plain paper, not on check stock.

I've tried enabling the "Preprinted Stub" while check printing - This only removes headers but still prints multiple pages with invoice descriptions on check stock.

Has anyone implemented/faced this? How can I stop the report from generating multiple check pages and instead print only 1 check page + separate invoice detail pages on plain paper?

Resources or guidance would be incredibly helpful on how I can achieve this.

Attached: Screenshot showing current multi-page behavior

Thank you!

pg 1 .png

pg 2.png

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Dynamics 365 Business Central

Hi,

I think you need to customize the check report format. I guess you want to know why.

Well you can do that by setting the hidden property of the tables.

First you need to swap the place of Invoice details tables/field and Check details tables/fields. So that Check details comes first and Invoice details comes later.

Now you need to segregate the fields between Check details fields and Invoice details fields or table.

Then for Check details fields/table set the hidden property value to =IIF(Globals!PageNumber = 1, True, False)

For Invoice details fields/table set the hidden property value to =IIF(Globals!PageNumber = 1, False, True)

This will make sure that Check details are only printed in page 1 and invoice details are only printed on pages other than 1.

Try this and let us know if any helps is required.

Regards,

Dhiren.

Quick Links