Script Reports

In this topic

Script Analysis Report

Daily Totals Breakdown Report

Log of Scripts Report

Owing Scripts Report

Dispense Incentive Analysis Report

S3 Recordables Report

Certification Report

Workload Statistics Report

Script Analysis Report

The Script Analysis Report provides summarised information on scripts that have been dispensed. The report can be configured using additional parameters—for example, scripts dispensed in a particular date range or scripts dispensed for patients in a selected nursing home.

  1. From the Reports menu [Alt+R], select Script [S], then select Script Analysis [A]. The Script Analysis Report dialog displays.

  2. Select the type of patients to be displayed:
    • A for All.
    • H for Nursing Home Patients. Enter a Fast Code or select from the list [CTRL+L]. Leave blank to report on all nursing homes.
    • O for Non-Nursing Home Patients.
  3. Select the date range.
  4. Select Y for the following fields if you want to include them:
    • Owing Scripts
    • UFS Discounts
    • Incentives

  5. In the Drug Cost field, select <= or >= and enter an amount.

    The Drug Cost field is particularly useful in filtering out high cost drugs.

  6. To run the report, select Generate, or press [Enter] twice.

    Click the thumbnail below to see a larger image.

    Analyse the report

    The Script Analysis Report is divided in two sections:

    This section displays the breakdown of dispensed scripts arranged by Script Type.

    • Gen/Con/Rep UnderCo-pay details those items for scripts which did not exceed the patient co-payment.
    • General includes scripts with a claimed amount.
    • Concession, Entitlement, Repat and Doctors Bag
    • CTG Gen, Con and Rep UnderCo-pay includes scripts that do NOT have a
    • claimed amount (no Govt Rec).
    • Private Scripts and S3 Recordable

    The Script Breakdown section shows the same script types as Section 1, where:

    • %Mark-ups is the difference between the total value and the cost price.
    • %Gross Profit is the profit relative to the total value.

    This section details the Number of Customers, Drugs of Addiction dispensed, Cancelled Items, Deferred Items, Owing Items and a GST summary.

Daily Totals Breakdown Report

The Daily Totals Breakdown Report is a summary of scripts dispensed each day and their values for a chosen period. The values are broken down into Patient Contribution, GST Amount and Government Recovery.

  1. From the Reports menu [Alt+R], select Script [S], then select Daily Totals Breakdown [D].

    The Daily Script Totals Breakdown Report popup displays.

  2. Select the type of patients to be reported on:
    • A All Patients
    • H Nursing Home Patients
    • O Non Nursing Home Patients
  3. If Nursing Home Patients are selected, press CRTL+L to select one from a list, enter a fast code, or leave blank if you want to display all nursing home patients.
  4. Select the date range.
  5. For Include Owing Scripts, enter Y to include or N to exclude.

  6. To run the report, select Generate, or press [Enter].

    Click the thumbnail below to see a larger image.

Log of Scripts Report

The log of scripts report details Patient Details, Drug Dispensed, Script Number, Directions, Quantity Supplied, Dispensing Pharmacist’s Initials, Doctor’s Details Patient Price and Safety Net Value for a chosen period.

  1. From the Reports menu [Alt+R], select Script [S], then select Log of Scripts [L].

    The Log of Scripts Report popup displays.

  2. Select the date range.
  3. To report on Only Private Items Dispensed, enter Y.
  4. To report on Only Scripts with GST Added, enter Y.
  5. To Display Scripts in Number Order, enter Y. Otherwise scripts are displayed in date order.

  6. To run the report, select Generate, or press [Enter].

    Click the thumbnail below to see a larger image.

Owing Scripts Report

Report on all owing scripts

  1. From the Reports menu, select Script, then Owing Scripts. The Owing Scripts Report popup displays.
  2. Select the Order of Report from the following options to define the sorting order of the report data:

    1. Select the type of patients to be reported:
      • A for All
      • H for Nursing Home
      • O for Non- Nursing Home Patients
    2. Enter Y or N depending on whether you want to Display both brand and generic names.
    3. Select the date range.

    4. To run the report , select Generate or press [Enter].

      Click the thumbnail below to see a larger image.

    1. For Patient per Page?, enter Y to start a new page for each patient.

      If you select Y, the Assign Mailing Category is displayed. A mail category code allows address labels to be produced easily from the Mailing Labels functionality.

    2. Select the type of patients to be reported:
      • A for All
      • H for Nursing Home Patients
      • O for Non-Nursing Home Patients

    3. Enter Y or N depending on whether you want to Display both brand and generic names.

    4. Select the date range.

    5. To run the report , select Generate or press [Enter].

    1. For Doctor Name, enter the name of a particular doctor or leave this field blank to report on all doctors.
    2. For Doctor per Page?, enter Y to start a new page for each Doctor.
    3. For Doctor owing Costs?, enter Y to report on the costs incurred if an owing script is not recovered. For example, the total of the PBS Govt recovery amount.
    4. Select the type of patients to be reported:
      • A for All
      • H for Nursing Home Patients
      • O for Non-Nursing Home Patients

    5. Enter Y or N depending on whether you want to Display both brand and generic names.

    6. Select the date range.
    7. To run the report , select Generate or press [Enter].

Report on owing scripts for a single patient

  1. In Fred Dispense, select the patient you want to generate a report for.

  2. From the Reports menu, select Patient, then Patient History.

    The Patient History Report popup displays.

  3. Select Owing Scripts.
  4. Select the date range and the other options as required.

  5. To run the report, select Generate or press [Enter].

    Click the thumbnail below to see a larger image.

Dispense Incentive Analysis Report

The Dispensing Incentive Analysis report is available to analyse dispensing patterns of drugs where the dispensing incentive could apply.

  1. From the Reports menu [Alt+R], select Script [S], then select Dispense Incentive Analysis [I].

    The Dispense Incentive Analysis popup displays.

  2. Select the date range.
  3. Enter Y if you want to Report Script Details.

  4. To run the report, select Generate, or press [Enter].

    Click the thumbnail below to see a larger image.

S3 Recordables Report

  1. From the Reports menu, select Script, then S3 Recordables.

    The Owing Scripts Report popup displays.

  2. Select the date range.
  3. For Order Report by Drug Description, enter:
    • Y to order the report by drug descripton.
    • N to order the report by patient.

  4. To run the report, select Generate or press [Enter].

    Click the thumbnail below to see a larger image.

Certification Report

The Certification Report should be printed and signed by all pharmacists at the end of each dispensing day.

  1. From the Reports menu, select Script, then Certification.

    The Script Certification popup displays.

  2. Set the date required.

  3. To run the report, select Generate or press [Enter].

    Click the thumbnail below to see a larger image.

Workload Statistics Report

This report summarises the number of scripts dispensed per hour and per pharmacist (if required).

  1. From the Reports menu, select Script, then Workload Statistics.

    The Workload Statistics Report popup displays.

  2. Select the date range.
  3. For Split Range by Hour?, enter:
    • Y to report on scripts dispensed per hour.
    • N to report on ranges as set in Report Ranges.
  4. For Split by Pharmacist?, enter:
    • Y to report scripts dispensed per pharmacist (per hour or other time range).
    • N to report total scripts dispensed only.

  5. For Report Ranges, set the time ranges to be reported on.

    To report on the whole day, set the Start time to the opening time of the pharmacy, and set the End time to the closing time of the pharmacy. Use multiple ranges to compare different times of day eg pre lunch (9:00 -11:30), lunch(11:31 – 14:00) by setting the times required.

  6. For Report Grand Totals?, enter:
    • Y to only print overall totals and not daily totals
    • N to print daily totals as well.
  7. For Day of Week to Report, leave blank if you want to include each day in the report. Otherwise enter one of the following to specify a particular day of the week:
    • 1 for Sunday.
    • 2 for Monday.
    • 3 for Tuesday.
    • 4 for Wednesday .
    • 5 for Thursday.
    • 6 for Friday.
    • 7 for Saturday.

  8. To run the report, select Generate or press [Enter].

    Click the thumbnail below to see a larger image.