Cannot filter 1099 report to output correct 1099 box totals

Customer needs to run the 1099 report two ways:

1. For default boxes 1-6 and 8-14 skipping box 7 for NEC.

2. A Report only for default box 7 for NEC

For both reports certain fund divisions are used in the selections.

Steps for a report only for default box 7 for NEC

1. Go to reports\accounts payable\1099 vendor Report w\Fund Information
2. Select the system NEC form
3. For the report format choose individual box 1099 items
4. In the report selection choose fund division code X-Y
5. In the report selectoin choose (Grantee) Default Box 1099 7-7
6. In the report note that the report shows Box 1 NEC column rather than box 7
7. Also note that in the report results that the total for the Box 1 NEC is not correct, it is alot less that expected.

Steps for default boxes 1-6 and 8-14 skipping box 7 for NEC.

1. Go to reports\accounts payable\1099 vendor Report w\Fund Information
2. Select the system Misc 1099 form
3. For the report format choose individual box 1099 items
4. In the report selection choose fund division code X -Y
5. In the report selection choose (Grantee) Default Box 1099 1-6
6. Add another line and choose (Grantee) Default Box 1099 8-14
7. In the report note that the report shows Box 1 NEC column rather than box 7
8. Also note that in the report results that the total for the Box 1 NEC are appearing when it is expected that that column would be blank.