Price Updates

If your stock supplier sends out price updates on a floppy disk or via E-Mail this option will compare your data with that on the disk.

Filename

This is the name of the file received from your supplier.

Update files

This option will compare the cost price held in the update file with the pack cost on the record card. You have an option to restrict the search to those prices that have increased (Higher), decreased (Lower) or are Different. The Update or list option will either list the changes or update the record cards. If your supplier includes barcode details in the update file then these will be updated whenever the prices changes.

Update if	D	(<H>igher, <L>ower or <D>ifferent)
Price difference	.01
Update or list	U	(<U>pdate or <L>ist)
Screen or printer	S	(<S>creen or <P>rinter)

When updating the prices you are asked if you want to check for duplicate codes. This is where you may have more than one stock card using the same supplier code. If you answer Yes then ALL cards with the same code will be updated.

Note: If you don't have multiple records then answer No so the process will complete faster.

When the system has finished updating the records found in the price disk, a list of all codes that are present on your system but NOT on the floppy disk will be printed. This is to ensure the a) you have entered the code correctly and b) the drug supplier has not changed codes. You are advised to restrict the processing of drug disks to one supplier.

Create records

This is used to create stock records, the system will create a stock card from the data held in the update file. Usually this will only be Stock code (supplier), description, barcode and cost price. You have an option to add new records at the end of file (Add) or to Overwrite your existing records.

Add/overwrite	A	(<A>dd or <O>verwrite
Supplier code	1
Default markup	75

List records

This will list on the screen (without pausing) the contents of the update file. This option is useful in determining the correct settings. The data should be displayed nicely in columns. If it is not you may need to alter the setting below. Pressing <ESC> while the listing is taken place will terminate it.

Settings

Premvet 5 needs to know how each line of the update file is made up, so it can extract the product details and store them in the correct fields on you stock record cards. The minimum information is:

Supplier code (Ref) - This is the unique code the supplier has allocated to this item.
Description (Item) - The name of the stock item, only the first 25 characters are used.
Price - The cost price of the item.
Barcode - The barcode allocated to this product.

This information can be obtained by trial and error using the listing option above, or you can ask your supplier.

1.	Update disk REF	1-12
2.	Update disk ITEM	13-30
3.	Update disk PRICE	55-8
4.	Update disk Barcode	63-13

In the above example, the supplier code starts at position 1 and has a length of 12 characters, the description starts at position 13 and is 30 characters long and the price starts at position 55 and is 8 characters long.

Misc Utilities

This menu contains some of the supplier specific options, currently it holds:

• NVS Barcode Update
  This option will use the barcode information held in the price update file and update all records with just the barcode.

  (Note: As of 10th September 2001 NVS are no longer offering this facility).

Disk Copy From Floppy

The disk sent by your supplier has to be copied onto your hard disk before Premvet 5 can use it.

Insert the floppy, the system will list what files are available and prompt you for the one to use. Answer accordingly and the update will be copied to the correct location for the system to use.

Note: As the contents of such drug disks are beyond our control, you should refer any difficulties in installation and use to your supplier.

Send Prices to Remote Site

If you are the master site involved with Cross Updating this option will transfer all prices over to the remotes site(s). Details of how and what are covered in the XUD manual.

Update 'Other' Site Data

If you have multiple sites running from the same server, you may have separate stock files for each. This option will only be visible on branch 1's Utility menu will update all other prices. It will NOT affect any sales figures or quantities.

Note: The last two options (Send Prices and Update Other) are switched off/on according to the system. If you have Cross Updating on and are branch one then 'Send Prices' will appear. If you are not cross updating and have multiple stock branches on and are branch 1 the 'Other' option will appear. Otherwise neither option will be visible.

elm

• From within the vet system access your E-Mail (via a Function key, or Option on Text menu or from a shell prompt.
• Select the message, you will be notified there is an attachment and you should Save it to file.
• Use the default filename Price.zip

mutt

• From within the vet system access your E-Mail (via a Function key, or Option on Text menu or from a shell prompt.
• Select the message, Use the 'Attachment' menu via 'v'.
• Select the attachment 'Price.zip' and press 's' (for save).
• Use the default filename Price.zip

  See attachment section of the Mutt Manual.

Windows Mailer

• Startup the mail, select the message
• Save the attachment to whichever drive you have mapped to the vet System.
• Save it as Price.zip

Now if you select the 'Price Update' menu option within Stock Utilities, the system will automatically detect and 'un-zip' the update file.

You should then process the update as mentioned earlier. The zip'ed file contains the standard filename tcnumf1 which should be entered via the menu if not already set to that.

This does depend on the ZIP/UNZIP utilities being present on the system. These can be obtained from support, the Skunkware CD supplied with the system or from http://www.sco.com/skunkware/shutils/