I finally figured out the same thing late last night. LOL!
Edit
Preferences
Tax:1009 (scroll to bottom of list)
Company Preferences
Map the accounts to either 1099 NEC or 1099 MISC by clicking on “you can do it here” under each item. Once everything was re-mapped, I ran the report and it worked.
