I need a report for an employee to show which DD bank accounts were used and the amounts that went to that bank account. This employee has more than one DD bank account setup. I also need it to span a 2-year period. I looked at the DD30101 table, which looks like it will work, and I can restrict on the employee ID, but not the check dates. I tried adding the check date field from the DD30301, but not sure this will return multiple lines of records.
I'd like to create it as a view to use with SmartList.