How to Create a New Account Pharmacy for Priority for Pick Up By Barcode

1. Create a new Pharmacy for Priority
2. Create new address for the new Pharmacy
3. Such that a CX Barcode will work with Pick Up by Barcode
4. To create new shipments.

Create a New Pharmacy.

1. Create a new account as usual. Write down the account code.
2. Go to the Rate Wizard, then the zones. Add the new Pharmacy code. Example I added a new zone called “790” that will be used for West Branch.
3. Go to the Account Entry Screen.
1. Type Priority into the Account field
2. Then click edit address book. You are now in Priority Address Book.
3. Then create a new address for the new Pharmacy code so that it looks like this:
   
4. In the above image, the Contact Name is “OMNICARE WEST BRANCH (790)”
5. Then go into the server’s database and update this record with the account code (as per point 1 above) into the address’s notes field. THIS IS DONE IN THE PRIORITY  GLOBAL ADDRESS BOOK!

   
   

   
   

   An example for dayton, 606:
   
   mysql> select mainid, subid, companyname, notes from accounts where mainid='priority' and companyname like 'Omnicare%';
   +----------+-------------------+-------------------------------+-------+
   | mainid   | subid             | companyname                   | notes |
   +----------+-------------------+-------------------------------+-------+
   | priority | ashland           | Omnicare of Ashland           |       | 
   | priority | beattyville       | Omnicare of Beattyville       |       | 
   | priority | cincinnati        | Omnicare of Cincinnati        |       | 
   | priority | dayton            | Omnicare of Dayton            |       | 
   | priority | dover             | Omnicare of Dover             |       | 
   | priority | escanaba          | Omnicare of Escanaba          |       | 
   | priority | grandrapids       | Omnicare of Grand Rapids      |       | 
   | priority | hilliard          | Omnicare of Hilliard          |       | 
   | priority | lexington         | Omnicare of Lexington         |       | 
   | priority | livonia           | Omnicare of Livonia           |       | 
   | priority | omnisouthmichigan | Omnicare of Southern Michigan |       | 
   | priority | perrysburg        | Omnicare of Perrysburg        |       | 
   | priority | wadsworth         | Omnicare of Wadsworth         |       | 
   | priority | WestBranch        | Omnicare of West Branch       |       | 
   +----------+-------------------+-------------------------------+-------+
   14 rows in set (0.00 sec)
   
   mysql> select accountId, description, notes from common_addresses where resellerid='priority' and accountid='priority';
   +-----------+-------------+--------------------+
   | accountId | description | notes              |
   +-----------+-------------+--------------------+
   | priority  | 790         | WestBranch         | 
   | priority  | 496         | ashland            | 
   | priority  | 653         | beattyville        | 
   | priority  | 677         | lexington          | 
   | priority  | 495         | cincinnati         | 
   | priority  | 606         |                    | 
   | priority  | 788         | grandrapids        | 
   | priority  | 789         | escanaba           | 
   | priority  | 735         | idsprioritytest    | 
   | priority  | 623         | wadsworth          | 
   | priority  | 742         | hilliard           | 
   | priority  | 793         | livonia            | 
   | priority  | 00002       | livonia            | 
   | priority  | 743         | perrysburg         | 
   | priority  | 766         | toledo             | 
   | priority  | 795         | dover              | 
   | priority  | 121         | RemediPhoenixville | 
   | priority  | 1600        | RemediMI           | 
   | priority  | 96237       | RemediTroy         | 
   | priority  | 1010        | omnisouthmichigan  | 
   +-----------+-------------+--------------------+
   20 rows in set (0.00 sec)
   
   mysql> update common_addresses set notes='dayton' where resellerid='priority' and accountid='priority' and description = '606'\G
   Query OK, 1 row affected (0.00 sec)
   Rows matched: 1  Changed: 1  Warnings: 0
   
   mysql> select accountId, description, notes from common_addresses where resellerid='priority' and accountid='priority';
   +-----------+-------------+--------------------+
   | accountId | description | notes              |
   +-----------+-------------+--------------------+
   | priority  | 790         | WestBranch         | 
   | priority  | 496         | ashland            | 
   | priority  | 653         | beattyville        | 
   | priority  | 677         | lexington          | 
   | priority  | 495         | cincinnati         | 
   | priority  | 606         | dayton             | 
   | priority  | 788         | grandrapids        | 
   | priority  | 789         | escanaba           | 
   | priority  | 735         | idsprioritytest    | 
   | priority  | 623         | wadsworth          | 
   | priority  | 742         | hilliard           | 
   | priority  | 793         | livonia            | 
   | priority  | 00002       | livonia            | 
   | priority  | 743         | perrysburg         | 
   | priority  | 766         | toledo             | 
   | priority  | 795         | dover              | 
   | priority  | 121         | RemediPhoenixville | 
   | priority  | 1600        | RemediMI           | 
   | priority  | 96237       | RemediTroy         | 
   | priority  | 1010        | omnisouthmichigan  | 
   +-----------+-------------+--------------------+
   20 rows in set (0.00 sec)
   
   

Create a New Address

1. A new address needs to be entered/imported such that it looks like this:
   
2. The above image breaks down in the following manner:
1. Description / Company Name: [Facility ID]–[nursing station]. Example above, 038 is the facility id and ALZH is the nursing station. DON’T!!!! put any spaces in this field, especially before or after the –
2. Street as street
3. City as City
4. Zip as Zip
5. Prov/State as State
6. Country as Country
7. Contact Name: [Facility’s Name] ([Facility ID]–[nursing station]). Example above is SYLVANIA CENTER (038-ALZH). Note, [Facility ID]–[nursing station] follows the same format and rules as per 2a above.