Designing Distribution Driver Report and Sub-Reports

The first step is creating the sub-report(s) to be called by the driver report.

In our first example, an A/P target report was designed earlier as our sub-report. This example shows vouchers per vendor. Notice that there are different vouchers per Business Unit. In our example, a user would like to have this sub-report generated for each BU and emailed to the BU owner.

The second step is to select the source table to act as the driver for report generation and distribution. This driver could be a JDE table or external table as the trigger field(s) for distribution, e.g. by each customer or vendor, or by employee, or by branch plant/ BU, etc.