RoyaltyZone display any errors found in your sales upload file
You can fix errors from within RoyaltyZone:
1. The total number of errors is displayed
2. The error type and corresponding row in your spreadsheet are displayed
3. You can "Fix" or "Delete" each error
You also have the option to cancel the entire upload, fix the errors in your upload file, and try the upload again.
NOTE: If your upload is over 1000 transactions, you will receive an email highlighting the errors, and a link to the "Fix" page
Click "Fix" to resolve each error, then click "Fix This Item" when done.
Possible Sales Upload Errors
|
Error Message |
Description |
“Fix” Button |
Edit File |
|
Territory Unrecognized |
The territory must match the Licensor territory description exactly |
Map your nomenclature to the Licensors by choosing the correct territory from the drop down menu. For example, map what you call “USA” to what the Licensor calls “United States” NOTE: you only need to do this once for each territory – all errors will be resolved for the current upload file, and any future uploads. |
Cancel upload, edit the affected rows to use the exact territory verbiage (you can copy and past from the Available Territories on the upload page), and re-upload the file. |
|
Distribution Method Unrecognized |
The Distribution Method must match the Licensor Distribution Method description exactly |
Map your nomenclature to the Licensors by choosing the correct Distribution Method from the drop down menu. For example, map what you call “Internet” to what the Licensor calls “Online”. NOTE: you only need to do this once for each Distribution Method – all errors will be resolved for the current upload file, and any future uploads. |
Cancel upload, edit the affected rows to use the exact Distribution Method verbiage (you can copy and past from the Available Distribution Methods on the upload page), and re-upload the file. |
|
Please enter the total Invoice amount for Gross Sales, prior to any Sales Tax or Shipping deductions. |
The Gross Sales amount should include any sales tax or shipping deductions. Net Sales = Gross – Tax – Shipping |
Enter the correct amount for Gross Sales or remove Sales Tax and/or Shipping deductions |
Cancel upload, edit the affected rows, and re-upload the file. |
|
The territory or distribution method you selected does not match the royalty rate. Select another territory or distribution method or contact {LICENSOR} to request a change to the royalty rate. |
The SKU can not be sold in either the territory or distribution method chosen. Royalty rates define rights in RZ. View the agreement summary page to review royalty rates. To be valid, a sale must match all four criteria of a royalty rate: property, category, territory, and distribution method. |
Choose the correct Territory or Distribution method, or contact the Licensor to change the royalty rate. |
Cancel upload, edit the affected rows, and re-upload the file, or contact the Licensor to change the royalty rate. |
|
Discount can not be greater than Gross Sales |
You can not take a deduction greater than the Gross Sales amount |
Enter a discount amount less than Gross Sales, or enter a higher amount for Gross Sales |
Cancel upload, edit the affected rows, and re-upload the file. |
|
Commissions can not be greater than Gross Sales |
You can not take a deduction greater than the Gross Sales amount |
Enter a Commission amount less than Gross Sales, or enter a higher amount for Gross Sales |
Cancel upload, edit the affected rows, and re-upload the file. |
|
SKU can not be blank |
Columns in the sales upload file can not be blank |
Enter the desired data |
Cancel upload, edit the affected rows, and re-upload the file. |
|
Invoice number can not be blank |
Columns in the sales upload file can not be blank |
Enter the desired data |
Cancel upload, edit the affected rows, and re-upload the file. |
|
Invoice date can not be blank |
Columns in the sales upload file can not be blank |
Enter the desired data |
Cancel upload, edit the affected rows, and re-upload the file. |
|
Customer can not be blank |
Columns in the sales upload file can not be blank |
Enter the desired data |
Cancel upload, edit the affected rows, and re-upload the file. |
|
Territory can not be blank |
Columns in the sales upload file can not be blank |
Select the desired Territory |
Cancel upload, edit the affected rows, and re-upload the file. |
|
Distribution Method can not be blank |
Columns in the sales upload file can not be blank |
Select the desired Distribution Method |
Cancel upload, edit the affected rows, and re-upload the file. |
|
Quantity can not be zero |
Columns in the sales upload file can not be blank |
Enter the desired data |
Cancel upload, edit the affected rows, and re-upload the file. |
|
Unit price can not be $0.00 |
Columns in the sales upload file can not be blank |
Enter the desired data |
Cancel upload, edit the affected rows, and re-upload the file. |
|
Billing Zip code can not be blank |
Columns in the sales upload file can not be blank |
Enter the desired data |
Cancel upload, edit the affected rows, and re-upload the file. |
|
Shipping Zip code can not be blank |
Columns in the sales upload file can not be blank |
Enter the desired data |
Cancel upload, edit the affected rows, and re-upload the file. |
|
Gross Sales can not be zero |
Columns in the sales upload file can not be blank |
Enter the desired data |
Cancel upload, edit the affected rows, and re-upload the file. |
