Optional Price Update

From QuickSCRIP Wiki
Revision as of 20:11, 6 January 2021 by Cecswiki (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

QuickSCRIP has the ability to import price updates from your wholesaler and insert them into the pricing fields in the Drug File Maintenance screen. This feature is useful for making sure your pricing is based on current market values for your drugs, and getting more a more accurate idea of your cost and profit. In general, QuickSCRIP imports Acquisition Price. We can also setup the price update to import vendor names and order numbers.

Note: This is a separate from the Medispan price Update, which covers AWP prices and are downloaded directly from Cost Effective Computers.

Updating from a downloaded file

The most common method of importing a price update from a file, downloaded from the internet. The file can be downloaded straight onto the server, or it can be saved to another computer on the network (such as your wholesaler ordering computer).

  1. Download the price update from your wholesaler website
    • You will need to consult your wholesaler on how to do this, as the process is different from vendor to vendor
    • NOTE: Make sure you save the update in the location designated for it
  2. In Quickscrip, start in the Pharmacy Main Menu
  3. Choose Option 3 Utilites
  4. Choose 18 Optional Price Update
  5. You will be asked if you want to print price Changes
    • Y will print all the drugs and the values that changed
    • A will print ALL drugs in the price update, regardless of weather it was found in your system
    • N will not print the changes
    • P will only print drugs that have changed over a set percent value. This is ideal for catching drugs that changed dramatically.
  6. Some systems will prompt you to enter your vendor name. Type it if prompted.
  7. Quickscrip will then import the update. You will be given a 1-page printout that will tell you the total number of drugs updated.

When you download the file from your Wholesaler website, it will need to have a specific name.

Wholesaler File Name
McKesson Cost.txt
Smith Costfile.txt
Cardinal Cost.txt
Amerisource/Bergen PRChange.out
Morris Dickson items.txt

Troubleshooting

Once of the most common errors while running a wholesaler price update is "X file not found" after running option 18 in the utilities menu. There are three possible causes for this message:

  • The price update was not saved in the correct location
    • QuickSCRIP is told to look in a specific location for the price update, which is set in the Price Update Customization Screen, Line 1 or 2. If you downloaded the file, but did not save it in the correct folder, you can get this error.
  • The price update was not named correctly
    • The name of the price update varies from wholesaler to wholesaler. When you run a price update in QuickSCRIP, we are looking for a specific file name.
  • The Mapped drive is not connected
    • If you are saving your price update on a wholesaler computer, we may use a mapped network drive copy the price update file from across your network. On the QuickSCRIP Server, check the "My Computer" desktop icon and verify that the mapped network drive icon does not have a red X over it. If so, double-click it to re-establish connection.

Updating from 832 FTP and HD Smith

McKesson, Amerisource, Morris Dickson, and HD Smith offer FTP price updates. These are similar in function to the normal price updates, except that you don't have to download the file from a website. Instead, Quickscrip downloads the price update directly from an FTP site. Contact your wholesaler if you'd like to sign up for this feature.

  1. In Quickscrip, start in the Pharmacy Main Menu
  2. Choose Option 3 Utilities
  3. Choose 18 Optional Price Update
  4. You will be asked if you want to print price Changes
    • Y will print all the drugs and the values that changed
    • A will print ALL drugs in the price update, regardless of weather it was found in your system
    • N will not print the changes
    • P will only print drugs that have changed over a set percent value. This is ideal for catching drugs that changed dramatically.
  5. Some systems will prompt you to enter your vendor name. Type it if prompted.
  6. Quickscrip will then import the update. You will be given a 1-page printout that will tell you the total number of drugs updated.

Rx Price Update Customization Screen

To customize how QuickSCRIP handles price updates, go to the Rx Price Update Customization Screen.

  1. Start in the Pharmacy Main Menu
  2. Choose 3, for Utilities
  3. Choose 3 again, for Business Control File
  4. Finally, choose 8 for Rx Price Update Customization Screen

Quickscrip can store the settings for up to two separate price updates.

  • Lines 1 & 2 determines the location QuickSCRIP checks for the price update file.
  • Lines 3 & 7 set the relevant masks for Wholesaler Price Updates. These are setup by a Cost Effective Help Desk Representative.
  • Lines 4, 8, 5, & 9 sets switches that affect how the Wholesaler Price Update runs.
  • Lines 6 & 10 shows the last dates you successfully ran a Wholesaler Price Update
  • Line 11 sets switches that affect how the Medi-Span AWP Price Update Runs.
  • Line 12 shows the last date you successfully ran a Medi-span AWP price update.
  • Lines 13 - 18 allow you to set if you want your pricing values lowered when you run your price updates.
  • Line 19 Lets you set a number of months for QuickSCRIP to check the price update while filling a prescription. If the last updated date is older than this, then QuickSCRIP will warn you.

There are a number of custom switches you can set on lines 4, 8, 5, & 9 that will impact how price updates are run.

Switch Description
/IL Tells QuickSCRIP to check the specified location for an update
Please do not remove this switch if a CECS representative has set it.
/LW Will NOT lower AWP prices
/LQ Will NOT lower ACQ prices
/L3 WIll NOT lower x340b prices
/AQx Will add x% to the ACQ price
/AWxx Will add x% to the AWP price
/ADxx Will add x% to the DIR price
/A3xx Will add x% to the x340b prices
/AGX Will ONLY add x% for Generic Drugs for /AQ /AW /AD and /A3 switches
/ABn Will ONLY add x% for Brand Drugs for /AQ /AW /AD and /A3 switches
/OR Inserts Order Numbers AND Vendor Names into your Drug File
/OR# Inserts Order Numbers into your Drug File. Leaves Vendor Name
/V Only updates prices for a specified vendor name