Error when Importing 1099's - Line contains the incorrect amount of delimited data

Description of Issue

Error when importing 1099's

 line contains the incorrect amount of delimited data

Context
  • EERP 

  • Accounts Payable 

  • 1099 Manager

Cause

New to Functionality

Resolution

To ensure Excel places commas in unused data fields, enter an apostrophe in any blank column. 

Additional Information