[Navigation]

Utilities within Stock

Menu Options
The following menu options are covered in this section:

|- Utilities
       |- Branch selection
              |- Select branch
              |- Configure branch
              |- Delete branch files
       |- Validation etc.
              |- Validate files
              |- Reconfigure files
              |- Delete items
       |- Reset end of year
       |- Price update
              |- Filename
              |- Update files
              |- Create records
              |- List records
              |- Settings
              |- Disk - copy from floppy
       |- Flag reset
       |- Global price increase
       |- Print history file
       |- Set minimum amount
       |- Weekly Holdings
       |- Update from HandHeld
       |- Reset On-Order Quantity


Branch selection

( Stock -> Utilities )

If the branch option is switched on this sub- menu allows you to manipulate data files from other branches. As mentioned earlier, the selection of the branch for daily use is automatic.

Select a branch
Change from the branch currently selected, to another. This change will remain in force until you either log- off or re-select this option.

Configure a branch
Creates the necessary empty data files for use in a branch. You will be asked to enter the branch number. If the files already exist you will be warned.

Delete branch files
Removes the files associated with a branch.


Validation

( Stock -> Utilities )

Validate files
Runs through the current branch making sure the records are readable, correcting any errors if needed.

Re-configure files
If there are any 'Killed' items, then the system will re-use the space.

Note: If the system is set up to de-stock records via Automatic pricing codes, then you are advised NOT to use this option, as the stock numbers will change.

Delete items
A global way of deleting a range of stock items. You will be asked:
Record to start at            1
Record to finish at           399
Product code                  0         (0 to ignore)
Supplier code                 0         (0 to ignore)
Manufacturer code             0         (0 to ignore)
Flag mask                ?????????
Individual cards can be removed by using the 'R'emove option on the stock prompt line for that item.


Flag Reset

( Stock -> Utilities )

Runs through the specified stock items and reset's the item's flags to what was specified.


Reset end of year

This routine will reset sales & purchase figures as well as the history file. Please make sure the appropriate print-outs have been obtained, and the necessary backups taken. This option CANNOT be reversed. The password needed is 'SQUID56F'.

You can run this option via cron with vet -p eoy.


Set minimum stock levels

( Stock -> Utilities )

This option will allow you to check (and set) your minimum levels. The system will calculate the average weekly usage and display the calculated minimum level based on the number of weeks stock you wish to hold.

If you enter Zero (0) as the number of weeks to hold the system will show 1 - 5 weeks. If used this way you cannot update the Minimum figures.

If using a specific number of weeks e.g. 2 and the calculated minimum is the same as the current minimum on file the item will not be printed. If when using the Update option, the calculated minimum is less than 1 then the record will NOT be updated. e.g.

No.   Description                  Min       2

  200 ERYTHROMYCIN TABS 250MG      40         4
  201 ETHER (ANAESTHETIC) 500ML   100         0
  209 KETO DIASTIX 50 STRIPS        2         0
  211 NEEDLES 25GX5/8 TERUMO       50        24
  214 CANAURAL DROPS 25ML           1         0
  215 CET FORTE KIT CAT             4         0
  216 FLEXI 3 - 8METRE              1         0
  217 SP FELINE MAINT RABBIT 5K     1         0
  218 WHISK LO PROTEIN CAN BEEF     6        12
  219 FLEXI 2 - 8 Metre             1         0
  221 FLORINEF 0.1MG TABLETS      112       136
  222 FLUORET STRIP                10         4
  223 TAVEGIL TABLETS             300       200


Global Price Increase

( Stock -> Utilities )

This option can be used to alter the Markup of a range of stock items. If 'Markup' is selected then all selected items will have the basic mark-up changed to the % specified, any discounts currently set will be preserved and applied to the new RRP. If price is selected then the prices will be increases by the specified percentage.

The selling price will be increased/decreased automatically by the discount in force on the record card. You can restrict the update by supplier, product or manufacturer codes.

This option affects existing items only, new items will use the mark-up specified in Stock -> Parameters -> Default markup.


Print History File

( Stock -> Utilities )

This option will print the full history of ALL stock items to the print spooler. It will not remove or delete any items.


Reset On-Order

( Stock -> Utilities )

When orders are placed the 'On-Order' field is updated. When orders are received the On_order is adjusted to reflect the received quantity.

However, if you forget to process an order the system still thinks the item is outstanding and will refuse to order any more.

This option will run through all the stock items and reset the On-Order to zero. You have to option to run for a specific supplier, Product code and Manufacturer code as well as a range of items.


Weekly Holdings

( Stock -> Utilities )

This report will list your stock holding by weeks' supply. The system will use the current month and the preceding 3 months sales history to determine the average usage per week and generate a report showing you the product and how many weeks supply you have in stock. The report can be sorted in any order.

No.   Description                  In Stock      Ave per Week      Weeks Supply

  103 CATHETER DOG 8FG                2                0                 9999
  109 CEPOREX 50mg TABLETS           45                8                    6
  106 CEPOREX DROPS 10ml              2                0                 9999
  123 CEPOREX TABS 500MG            307               95                    3
  130 COTTON WOOL 500g (PROPAX)       4                1                    4
  140 DEPOMEDRONE-V INJ              14                1                   14
  150 DEXTROSE INJ 50% wv          1083               12                   90
  154 DIAZEPAM 5MG TABLET           878                1                  878
  158 DIGOXIN 125mcg TABLETS        135               21                    6
  157 DIGOXIN 250MCG                 42                5                    8
  156 DIGOXIN 62.5mcg TABLETS       280              109                    3
  175 E-Z CATH 14G                   10                1                   10
This option will only work with PremVet running under OSR 5.


Update from HandHeld

( Stock -> Utilities )

This option allows you to automatically update the stock quantity by means of a hand held device. The idea is staff use the remote device to log current levels in the stock room, connect to the server and the quantities in stock are adjusted.

In all cases, a report will be generated printing out any quantities that have been changed, any items the system was unable to locate. As this is dealing with supplier packs, the system will assume you are counting the 'outer' quantities. Premvet will convert the outer using the 'Pack to Dispenced' quantities and update the dispensed quantity. You should count/log the supplied pack size. In the case of outers containing tablets/liquid, the system will check THE NUMBER OF OUTERS ONLY. e.g.

If you have 'Drug A' supplied in 50ml bottles, Pack/Dispenced is 50ml, and you have 175mls in stock - that is 3 and a bit bottles i.e. you have 4 bottles on the shelf - that will be treated as 4 bottles.

Any changes will be logged on the stock history screen.

There are three menu options:


Setting up the Hot Sync Software

To enable the Symbol to sync back to the server it requires:

You can also use the Lynx handheld to update your 'Pending Order', use the order entry system on the palm as per the documentation from Genus. Once you are ready bring up the order screen and select 'HotSync' which will update the order list. Any items received from the palm that do not exist on the system will be added.

It is recommended you send one dummy order via the palm modem every week or so, this is to allow the palm to be updated with new stock items from Genus.


Top Classic New-Style Chapters Sections Index Search