Important: 

F&P, BSH, Rinnai, Rheem and EHP sell thrus must NOT be loaded to All Business Units. They must be only loaded to AOL and WA. If you are loaded for AOL and WA , you can load them in as AOL|WA in the subdivision field. Ensure any manual uploads or file uploads adhere to this!

NOTE: 

• Values in “Division Code” field will be separated by ‘|’ pipe (eg. WA|AOL| WACOM) “Division Code” will represent a business unit and is mapped to the corresponding Division/Subdivision combination in a new table - “Sell-Thru Div/Subdivision Setup”. This means that subdivision details do not need to be explicitly included in the CSV upload and the lines will be created by subdivision code.

• 1. Check the sell thru isn't already loaded - how to check if sell thru already loaded between 00:00 and 05:59 ( if sell thru already loaded check with TL to make sure we can load new one ) NOTE : if same start date we need to use different rebate code 

  2. Ensure all the data needed from supplier is there 

  3. Supplier needs to confirm support

  4.  Use Template and make copy ( "M" means mandatory field ) . If the supplier has not provided a Deal Number (claim reference), please ensure the Deal Number you create has not already been used for different dates. 

  5. Delete the example rows and the headers

  6. Sense check that the data is the same on original email from supplier and download as csv 

  7. Load into Navision under Rebates > sell thru vendor rebates > "Import Sell-Thru Rebates By Division" , go to csv then bulk upload

  8. On successful upload, the user is prompted with the message saying how many records were created, a uplaod of 1500 records shouldnt take any longer than 2 mins 

  9. The “Include in WA Standard Cost” value will be carried across from “Dimension Value Sell-Thru Vendor Rebate” to the lines.

  10. Entry No. to be populated on Sell-Thru Vendor Rebate Entries. Copy this into the email as this is your new confrimation number. 

  11. On the failure of the upload, the explicit error message will prompt the user to review the error and fix it before importing the file again.

  12. If you are awaiting further details from the supplier or PRM - such as confirming the amount of a rebate, timeline or type then set your ticket to Pending.

  13. If the date you load the rebate is after the date it starts, forward the email to rebates@winning.com.au with freni.samani@winning.com.au and kelvin.wijaya@winning.com.au.  Please include the below template in your email:
      
      "Hi team,
      
      I have loaded this sell-thru today but it started on DATE. Please ensure you claim from when it began.
      
      Deal number is DEALNUMBER."
      
      

  14. upload into Supplier maintenance - Pricing / SKU / Rebates