You are doing your commission imports and you get an error message preventing you from importing your data. 


It is important you read the message and try to identify what the issue is, the warning should help you with that.


Example Warnings

This is a common warning, the warning tells you that in one of the required columns (Rep ID, Product, Account) there is an empty cell. It can happen that you check your spreadsheet and there is no empty cell(s), in most cases there is a total a couple of rows down that is causing RPM to think there is more rows that need to be imported. 




This warning tells you that the column header Customer has changed been changed to Customer name. You want update the mapping in the upload matrix if this is how the commission statement is delivered to you from this point forward. 





This warning will show when you are importing an item variable setup as a date field and the there are entries in your commission data that is not a valid date. The warning shows the column header where you can find the issue. 





This warning will show when you are importing a money variable and the there are entries in your commission data that is not valid. The warning shows the column header where you can find the issue. 





In most cases when you see a lot of columns 'missing'  it happens when the data you need to import is not on the 1st tab in excel. 









See also: