[Revised Nov 2014]
The Supplier Update Utility can be used to create new stock cards for suppliers who provide the Help Desk with suitable price lists and it can also be used to update prices for existing stock cards. You can add Product Groups/Classes at the same time.
To Create Stockcards
If a supplier has sent us a file, you can use the supplier update to download the new stock items with their partcodes, barcodes, List costs and Recommended Retail Prices.
-From RxOne Start Menu, go to 'Tools' and 'Supplier Update'.
-Find the supplier file you would like. Check the date of the file under ‘Price File date’ is current.
- Highlight the file, and <OK>.
- On the next panel, consider the first 2 options under 'New Items Options', change if desire. Then <OK>
- Select the 'New Items' tab. This shows the items that are not yet in your database. Before accepting items you can edit them on the list by doubling clicking the item.
- then either
a) Highlight the items you want to add and select 'Accept', Or
b) If the new stock is in the pharmacy, select 'Add Item by Scanning Barcode/Partcode' and scan the EAN code on the product. When using this option, the SoH can be updated at the same time. Or
c) You can ''Accept All' to create stock cards for all the items in the list, however this is only recommended for supplier list that are quite small. If you create stock cards for items that you don't have, this will increase the size of the database to an unacceptable size and slow down lookups etc.
How do I download the Special Buys from the main wholesalers e.g. Access Buying Group, Bulletin Vantage etc?
- Go to 'Supplier Update', highlight the file you want.
- Select 'Update Supplier List Cost'.
- This will not change the 'normal' list cost or retail price but you will still be able to look up the "special buying price'' under real cost. (Note: Updating list cost will change the retail price).
- <Ok> to open up file.
- On opening the file, even if no price changes are accepted, the old file is removed and a new file is created so that only products currently available from that supplier will appear on an order for that supplier.
- Accept any price changes on the 'Changed Item' screen if desired.
Note - Under the "Buying Group" tab, the second box for the supplier will no longer show. When processing the file, set the Supplier to the buying groups name e.g. Vantage, PDC, Access Buying Group, etc. Do NOT set it to the Wholesaler name.
What's a quick way of downloading the new Recommended Retail Prices from a particular supplier?
- From Supplier Update, select the file you want (check the date is current).
- Select update Recommended Retail Price. This will also automatically tick the update list cost box. A new markup will be worked out based on these two figures.
- Select Print stickers/shelf labels if you want them
- It is also best to select 'Update Partcode', 'Update Barcode' and 'Update Outers' to download any changes to this information.
- <OK> will take you to the 'Changed Items' tab.
- Either 'Accept' highlighted items or 'Accept All' to accept changes to all the items.
If a supplier file contains product groups, this can be downloaded to your system by selecting 'Update Product groups'
NOTE: QVS/Via files – The Via and TLC product range supplied by QVS is in a separate file under the Supplier "Via".
Related Topic