Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »



Bulk Rep Reassignment User Guide

Introduction

This guide provides instructions on how to reassign reps in bulk.

Table of Contents

Locating Reports

Click on images to expand them.


This section provides instructions on reassigning reps to different clients in bulk.

Change Rep Domains

Change Rep Domains

Step 1: Navigate to one of the Change rep domains.

  • Administration> List Domains> Change Rep – Account Process Level
  • Administration> List Domains> Change Rep – Client Process Level

Rep Code Domain PageRep Code Domain Page





Select Rep Codes to EditSelect Rep Codes to Edit

Step 2: Select the rep code, or rep codes you would like to edit.

Are you missing required report columns?

If the appropriate columns are not visible to use the "customize report" button to add the necessary columns. Enter the following columns from left to right.



  1. Process Level (Client or Account)
  2. Client Last Name
  3. Client SSN
  4. Account (Only Applicable when running by Account Level)
  5. Current Rep
  6. Rep Code To Process (New Rep Code to Add or Replace, Same to Remove)
  7. Process Type (Add, Remove, or Replace)





Export Fields Button

Export Fields Button


Step 3: Click the Export menu and select (XLS)-Current Fields from the drop-down list.

(XLS) All Fields

If you select (XLS)-All Fields, you MUST remove rows that you DO NOT want to process.


Step 4: Open the spreadsheet in Excel and update the remaining rows with any changes.

Step 5: Add any new line items.

Step 6: In the Process Type column, enter either “Add,” “Remove,” or “Replace.”

  • Add- This process type tells the system to add the information in the row as a new entry.
  • Remove-This process type tells the system to remove the information in the row.
  • Replace-This process tells the system to replace the existing information with an update.

Saving the File as a .CSV

Saving the file as a .CSV



Step 7: Save the file as a .CSV, NOT as an .XLS file and close Excel.



Changing the File Extension

Changing the File Extension






Step 8: Change the extension from .CSV to .RCG.

Changing File Extensions

Windows Users

  1. Launch File Explorer
  2. Click the View tab at the top of the window.
  3. Make sure File name extensions is checked on.
  4. Locate your file.
  5. Right click and select to Rename
  6. Change .CSV to .RCG
  7. Hit the Enter key to save your changes.

Mac Users

  1. Launch Finder
  2. Locate your file.
  3. Click on the file name twice (slower than a double-click)
  4. Change .CSV to .RCG.
  5. An alert will appear. Click Use .RCG to confirm the change.

Uploading Files

Uploading Files

Step 9: Click on New and select Upload file from the dropdown list.

Step 10: Click on Add File(s) and select the file you want to upload.

Step 11: Click Start Upload. Rep reassignments will be processed.

SSN/TIN

 If the SSN/TIN does not match what is already in the system, then the requested changes will be ignored.





Load Report

Load Report

Step 12: Navigate to the load report to check that all changes were successful.

 

Administration> Reports> Load Report

Definitions: Columns

  1. Process:
    1. # of items to be processed from the load
  2. Errors:
    1. # of errors (Did not process)
  3. Warnings:
    1. # of warnings (Processed with caution(s))
  4. Inserted:
    1. # of records added
  5. Updated:
    1. # of records replaced
  6. Deleted:
    1. # of records removed
  7. Execute:
    1. Time to process the request

What Do My Choices Mean?

Click on images to expand them.


This section of the guide defines the logic that the system follows based on your choices.

ChoiceDescriptionClient LogicAccount Logic

Change Rep – Client Process Level

If you select this list, then the system will search for the client using "Client SSN" and "Current Rep."N/AN/A

Change Rep – Account Process Level

If you select this list, the system will search for the account using “Account.”N/AN/A

Add

When you write ADD in the Process Type column on the CSV file (prior to converting to an RCG) the system will add a rep code to a client folder and subfolder.

If the system finds a client folder, it adds in the rep code you entered into the .RCG file. The system records this change by adding an entry to the client folder notes history. (Rep Added: "Rep code to process")


If the system does not find a client folder, it skips the row and adds an entry to the error log.

If the account and client subfolder is found, the rep code is added to the client folder and subfolder and an entry is added to the client folder and subfolder Notes History. (Rep Added: "Rep code to process")


If the account or client subfolder are not found, an entry is made to the error log and the row is skipped.

Remove

Allows the ability to remove a rep code from a client folder and subfolder. Designate REMOVE in the Process Type column on the CSV file prior to converting to an RCG. The system searches for a client subfolder with "Rep code to process"


If the client subfolder is found and there are multiple Reps on the client subfolder folder then "Rep code to process" is removed from the client subfolder and add entry in client subfolder Notes History (Rep removed: "Rep code to process")


If the client folder is found and a single rep is on the client folder, an entry is made to the error log and the row is skipped.


If the client folder is not found, an entry is made to the error log and the row is skipped.

If the client subfolder is found and there are multiple Reps on the client folder then the "Rep code to process" is removed from the client subfolder and from the client folder and an entry is added in the client folder and subfolder Notes History (Rep removed: "Rep code to process")


If the Account is empty, an entry is made to the error log and the row is skipped.


If the client subfolder folder is found and a single Rep is on the client subfolder, an entry is made to the error log and the row is skipped.


If the client subfolder is not found, an entry is made to the error log and the row is skipped.

Replace

Allows the ability to replace (change) a rep code from a client folder and/or subfolder. Designate REPLACE in the Process Type column on the CSV file prior to converting to an RCG.

If client folder is found, replace "Current Rep" on the client folder and all client subfolders with the value from "Rep code to process" and an entry is added to the client and subfolder folder Notes History (Rep change - from Rep: "Current Rep" to Rep: "Rep code to process")


If the client folder is not found, an entry is made to the error log and the row is skipped.

If the client is found by account number, replace "Current Rep" on the client folder and client subfolder with the value from "Rep code to process" and an entry is added to the client and subfolder folder. Notes History (Rep change - from Rep: "Current Rep" to Rep: "Rep code to process")


When an update on the client subfolder is done, a check is run to determine if all client subfolders with account numbers within this client folder have a "Rep code to process"


If yes, then "Current Rep" on the client subfolders without account numbers is replaced (e.g. General subfolder) with the value from "Rep code to process" and an entry is added to the client folder Notes History (Rep change - from Rep: "Current Rep" to Rep: "Rep code to process")


If the Account is empty, an entry is made to the error log and the row is skipped.


If the client subfolder is not found, an entry is made to the error log and the row is skipped.

  • No labels

© Docupace Technologies 2020 | Documentation Dashboard