Match item to drug

Drugs from Fred Dispense MUST be matched or linked to Items in Fred Office Plus. Stock on hand and sales information is recorded against Items (not drugs).  Correct linking ensures stock on hand information will be correctly recorded.  In addition, item liking affects usage information as well as Ordering and Reporting. When a drug is created in Fred Office Plus (following a drug update in Fred Dispense), Fred Office Plus attempts to automatically match it to an existing item.  If it cannot find a match the drug must then be manually matched to an item.

Auto Match/Create Drug Item

Fred Office Plus can auto match to both the Drug and AppCAT and apply Core item data. This means new alias and supplier details will be added to the newly created/matched drug item and it will be ready to order/scan.

To enable Auto Match/Create Drug Items:

  1. Select Tools > Script > Options.

  2. On the POS tab, select the Auto Match/Create Drug Items checkbox.

There are four methods to manually match drugs in Fred Office Plus.

  1. Click Inventory, then Items.

  2. Search for and open the item of interest.

  3. Click Links, then Auto Match.
    1. Click OK then Match.
    2. Enter the drug description or FRED drug code and click Search.
    3. Select the drug and the forward arrow to add the item(s) to Selected.

      The <CTRL> and <SHIFT> keys can be used to select multiple drugs.  The single forward arrow can then be used to add all the selected/ highlighted items to Selected.

    4. The matched drug(s)is displayed.

    Before closing the item stockcard, click General and review SOH and Committed quantities to ensure their accuracy. Also click Links and review the AppCAT and drug matching for the item to ensure accuracy. 

  4. Click Save and Close.
  1. Click Inventory, then Drugs.
  2. Search for and open the drug of interest.

    To find the drugs which have been dispensed and not matched to items, the Unmatched Scripts report can be used.

  3. From this report right-click and open the drug card to perform matching.
  4. Click Item, then Auto Match.
    1. Click Find.
    2. Enter the item description and click Search.
    3. Select the item and click OK.

    The matched (or linked) item is displayed.

    Before closing the drug card you might also want to open the item to ensure stock levels and AppCAT linking are accurate and prevent future issues.

  5. Click View to open the item stockcard.
  6. Click Save and Close.

Before running this wizard, it is recommended that AppCAT Differences are reviewed and applied. This is to ensure that any relevant FRED drug codes and alias (APN/ barcodes) for items have been updated.  This in turn ensures the maximum number of drug to item matches will occur when this wizard is run.

  1. Click Tools menu, then Item, then Bulk Drug Matching.
  2. Click Nextat the welcome screen displays.

  3. Ensure New Match is selected, then click Next.

    The Incorrect Matches option performs an auto match on all items in your system. It will then display any drugs where a different auto match item was found than that currently matched to the drug. The Invalid Matches option performs an auto match on all items in your system. It will then display any drugs where an item match exists, but the auto match could not validate this match.

  4. Select Accept as appropriate.
  5. Click Next (twice) to complete.

Fred Office Plus recognises any unmatched drugs that have been dispensed, and, if the item does not already exist, auto creates a new item in Fred Office Plus to link to, using the known information from the drug. If the item did exist (ie matched by alias) then the drug will simply be linked to this item automatically.

To enable the Unmatched Drug feature

  1. Select Tools > Script > Options.

  2. On the POS tab, select the Auto Match/Create Drug Items checkbox.

See Resolve Autocreated Drugs for more details.

Related resources

Drug Matching