CLONE - Conversion - Need a way insert/copy user locations based for all locations

Issue No: SM-4218
Created 6/21/2018 1:18:32 AM
Type Feature
Priority Major
Status Closed
Resolution Fixed
Fixed Version 19.1
Description Conversion:   We need to convert locations into user roles. Currently, the screen is blank, so the user has to constantly add locations everytime we copy data over.   I need a way to insert locations from tblSMCompanyLocations into User > User Roles > Locations tab.     Requirements:   1. 18.1 Create a stored procedure for me to use.   2. 19.1 Create button before Import Account Status Code in Sales     !pastedImage_d99157_0.png!   In this scenario, if the customer has 30 users with 10 locations, they would have to enter a total of 300 locations in order to allow all their users to access all locations.   300 locations + 300 uer roles + open and saving each record.   !pastedImage_d99157_1.png!   !pastedImage_d99157_2.png!       EXPECTED   dded *Add Location to User* under Import and Conversions \| System Manager   !pastedImage_d99157_3.png! !pastedImage_d99157_4.png!