Vendor Rebate Excel Upload
-
This excel is useful to upload rebate master details (When user is Purchasing goods for other country then certain % need to be fix for vendors, that process call it as Rebate) for the respective Vendor in the application, for this excel option is will available in Master Excel, through which the rebate details will be uploaded.
-
The excel will have the columns of ‘Vendor Code’ and ‘Rebate Percentage.
-
No column should be blank.
-
It should not allow invalid data (invalid vendor code for Rebate % accept only numeric and decimal values only).
-
Rebate percentage should be in between 0% (greater than zero but not equals to zero) to 100%.
Below is the excel format for the rebate upload.

‘Rebate’ excels upload validations: