I need your help in printing a three-section check for our church. I setup a single table/form expense reimbursement program. A member fills out a reimbursement request form for their purchases. The accounting office enters the data and prints out a check. The check is a single page (letter size) three parts with the check on the top with two voucher sections (middle and bottom). So far so good.
It got a bit complicated when a member purchases three items for three different departments. We currently print three checks for the same member since each transaction must be associated with a department that the purchase was made for. So, in order to save checks (and the hassle of printing multiple checks) we want to print a single check for the total amount to be reimbursed with three different items listed in the two voucher sections (middle one to recipient and bottom one for accounting office).
Easy enough I thought; three purchases are entered as three transactions (as we currently do) except we use the same check number for three transactions. Then I filter by the check number to print the check using a group header to print the top check section (payee, the total group amount, etc.) and use the detail section to list each transactions into the middle voucher section of the check page.
Now the difficult part (at least for me); How do I print the same information that is listed in the detail section (the middle section of the check page) to the bottom third of check page? Also how do I handle the varying size of middle and bottom sections due to varying number of records?
I am clues less as to the solution � your help will save lots of checks. Thanks.
Eugene
It got a bit complicated when a member purchases three items for three different departments. We currently print three checks for the same member since each transaction must be associated with a department that the purchase was made for. So, in order to save checks (and the hassle of printing multiple checks) we want to print a single check for the total amount to be reimbursed with three different items listed in the two voucher sections (middle one to recipient and bottom one for accounting office).
Easy enough I thought; three purchases are entered as three transactions (as we currently do) except we use the same check number for three transactions. Then I filter by the check number to print the check using a group header to print the top check section (payee, the total group amount, etc.) and use the detail section to list each transactions into the middle voucher section of the check page.
Now the difficult part (at least for me); How do I print the same information that is listed in the detail section (the middle section of the check page) to the bottom third of check page? Also how do I handle the varying size of middle and bottom sections due to varying number of records?
I am clues less as to the solution � your help will save lots of checks. Thanks.
Eugene
Comment