Thanks @AmyC ! This solution was perfect.
@canuck97 i'm not sure if you have the same situation, but I was able to do Amy's suggestion. I basically inputted the aggregate totals (basically I have 4 aggregate sales) and then I just uploaded my 1099 into the system. I did not utilize the direct import feature (which creates each individual sale and creates the error)
