To export price info from Walsh Lumpkin Version 3



To export price info from Walsh Lumpkin Version 3.1.5,

Start WL and choose Utilities/Export Files.

[pic]

If you have already defined an export, follow these steps:

A) Use the small window where it initially says , to find the export you have defined. In this example it is "Custom_Price".

[pic]

B) Once Custom_Price is chosen, you must click on the EXPORT button.

You will be prompted for the location/destination for the price file it is about to create:

[pic]

C) Enter the file name as it is shown, including the C:\ for the drive and then click Save.

D) If the file already exists, you might first see a prompt telling you that the file already exists, and "do you want to replace it?". If you see this prompt, say yes:

[pic]

E) You should see a progress meter indicating that records are being written out.

You should see a progress meter indicating that records are being written out.

When the file has been written you will be returned to the Export Wizard Screen:

[pic]

G) You can click EXIT to close the wizard. The price update data has been put on the (C: ) hard drive.

If your Walsh software is on a computer separate from your network and RxLink, you need to move this big price update file onto a floppy so you can transport it to RxLink.

H) Go to the desktop of the Walsh PC by minimizing all other programs, and choose the shortcut on the desktop that will ZIP the file to a floppy. In this example, the shortcut is a dollarbill and is titled "Prices To Floppy". It will prompt you to insert a floppy diskette and then warn you that all data will be wiped as it is formatted, and then it will put the price update file onto the diskette. Since the file is huge, it must be "zipped" to fit, and then unzipped at the RxLink computer.

Here's what the shortcut will look like when you run "Prices to Floppy":

[pic]

When it asks "QuickFormat another (Y/N)?" you must hit "N" for NO and then hit ENTER for the process to continue. You will see this when it is done:

[pic]

So press any key and you will be back to the desktop.

Take the floppy to the RxLink workstation and use the shortcut on the desktop there, titled "PriceUpdate", to inload the diskette's PriceUpdate file to the hard drive.

It will be copied to the C:\crown subdirectory. Once this is done, sign on to RxLink and run menu choice 244, choose 21, and press F2 and Enter.

You will see it count numbers in red at the top of the screen for about a minute and then you will be back at the 244 menu.

[pic]

Choose 22, and press F2 TWICE to run the report that will actually update your AWP and Contract Prices – it looks like this before you press the second F2 key:

[pic]

You will get a printout that shows what the old prices were and what the new prices are. Check it for accuracy and "oddball" changes.

The next report to run is still on the 244 menu, it is choice 66 (“New Patient Prices”), which calculates the prices per dose for all the drugs using your formulas.

This report looks like [pic]

The formulas are found in a file at menu choice 676: [pic]

You can run the report 244, 66 once with the defaults to test what would chance, and look through the printout for really odd or weird prices, and then fix the errors in the drug master record (such as package size, billable doses per container, NDC number, etc.) before you run the 244,66 report "for real".

To run 244, 66 "for real" you must change the option for the second field from N for NO to Y for YES, so that the drug records are actually updated with the calculated prices.

Give the printout to the business office or your CFO to insure that the latest prices are in the business office billing system.

IF YOU HAVE NOT YET CREATED THE EXPORT REPORT IN WALSH LUMPKIN:

For the first time only, you must define an export. After this, you can simply choose to run it as outlined above.

To define an Export Routine:

1. Make sure the Type of File to export is is

[pic]

2. Click on the Edit Layout button to start the Export File Wizard.

[pic]

3. Click on the plus sign to the left of ItemMaster in the left-hand window to be able to see the fields available to export. You will choose only the fields needed to perform the update, and they must be selected in the proper order indicated below.

4. Click on the word NDC in the left window and then the Add Field/Table button: [pic]

The NDC will then have a checkmark beside it, and the right hand window will display the first item to be listed in the export file, "ItemMaster.NDC"

5. Now left-click the cross beside ItemCustomer and then click on EPIC in the left hand window and then Add Field/Table to make the ItemCustomer.Epic number be the second thing in the right-hand window.

6. Now in the left hand window, left-click on the ItemCustomer.Cost", and then left-click on the Add Field/Table.

7. Scroll Back up the left-hand window to the ItemMaster items and click on "AWP", Add Field/Table, and then "ItemDesc", and Add Field/Table for that as well.

8. Your Wizard window's right hand window should look exactly like this:

[pic]

9. Click Next

10. If you have more than one account, the screen that then appears lets you choose which account you will export prices for. Just choose NEXT if you only have one account.

[pic]

11. The next three screens are options that do not need choices (we like their defaults), so just click Next three times.

[pic]

and

[pic]

and the third(just click Next): [pic]

12. The next screen you see will control the format. Click on the radio button (circle/dot) to the left of the words "FIXED LENGTH", and then choose Next.

[pic]

13. ON the next screen, you must make a few changes. Use this picture to change the number of digits for the WIDTH of the NDC to 11, and choose Alignment to be "RIGHT". Make sure all widths and decimal places are as pictured below. It works best if you use the TAB key to move from cell to cell in the table so that the wizard checks each field as you go. You only need to fix the cell values for the first four items: ItemMaster.NDC, ItemMaster.Epic, Inventory.ItemCost, and ItemMaster.AWP.

[pic]

14. Click NEXT.

15. Choose to save the layout as something you can remember, such as Price or RxLink, and click FINISH.

[pic]

16. It will now ask you where you wish the export file to be written. You want to write it to C:\Price.txt as in the example below:

[pic]

When you click Save the computer will immediately start exporting the records.

Note: if you have already run this export, you will be prompted to overwrite the old file:

[pic] - just click YES to replace the old with the new.

You will see a progress bar. When it disappears the export is done. You can exit the Walsh program and use the shortcut on the desktop to ZIP the export file to a floppy diskette for transfer to the RxLink computer (if need be).

In the future, to run the export, you choose the export wizard, and then choose the export name you saved it as. If you saved the export as "Price" or "RxLink, then you will see "Custom_Price" or "Custom_RxLink" as the name:

[pic]

Then choose the EXPORT button, and tell it where to save the price export file (C:\price.txt) , just as before. You must be consistent with this each time you run it in order to get price updates successfully. Remember that it will prompt you to replace the old file each time.

Programming Note:

A shortcut on the Walsh Computer's desktop runs this batch file to move the too-large export file to the floppy:

@echo off

cls

echo This moves the price.txt file into a ZIP/Compressed file

echo on a floppy diskette.

echo...

echo The diskette will be quick-formatted first -

echo WARNING! ALL DATA ON THE DISKETTE WILL BE WIPED FIRST!

format a: /q /v:PharmacyPRC

c:\windows\pkzip -ex -a a:\price.zip c:\price.txt

pause

echo All done with exporting the prices.

echo Take the floppy to RxLink computer for the rest of the process.

pause

exit

and a shortcut on the RxLink computer desktop runs this batch file to unzip the price file to the C:\crown subdirectory:

@ECHO OFF

CLS

ECHO PLEASE INSERT THE PRICE UPDATE DISKETTE INTO DRIVE A:

PAUSE

C:

CD\CROWN

IF EXIST PRICE.ZIP DEL PRICE.ZIP

IF EXIST PRICE.TXT DEL PRICE.TXT

XCOPY A:\PRICE.ZIP

C:\DEASE\PKUNZIP A:\PRICE.ZIP

DIR C:\CROWN\PRICE.TXT

ECHO THIS FILE WILL BE IMPORTED IN RXLINK

PAUSE

______________________________________________

The contents of the Price Update File created will appear like this:

05963041190323535 37.12 46.83PRENATE ELITE TAB 9X10S

05464310560323543 25.76 32.50ARISTOSPAN INJ SUSP 20MG/ML 5ML

05464310550323659 10.26 12.96ARISTOSPAN INJ SUSP 20MG/ML 1ML

05099143601323808 54.36 74.92FLEXTRA CAPS 100S

04598565130323832 12.19 15.30CARDIOTEK RX TAB 30S

00591319689324012 32.44 40.93TERCONAZOLE 7 VAG CR .4% 45GM

00591319752324103 32.44 40.93TERCONAZOLE 3 VAG CR .8% 20GM

06170323716981530 3.21 30.65ENALAPRILAT VL 1.25MG/ML 2ML

00074490034323709 25.89 34.25SOD BICARB ABJ LS 8.4% 10ML 10

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download