Scripts reports

Summary of report

Summarises the number of scripts dispensed per hour, per day.

With this pivot report, users can alter how the report displays information.

Use for:

  • Compare weekly scripts dispensed totals

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Script count Number of Scripts dispensed in period    
Time Dispensed Splits daily sales into hours    
Weekly Scripts Clumps rows of report into weekly periods Y  
Day Dispensed Splits weekly scripts into individual days Y  
Pharmacist Clumps rows by Pharmacist who dispensed items   Y

Summary of report

A chronological display of scripts that have been dispensed over a selected date range.

Use for:

  • Find a script that was dispensed within a certain date range.

  • Find a script that was dispensed to a particular patient.

  • Find script dispense to a nursing home.

  • Find scripts dispensed from a doctor.

  • Find script dispensed from a pharmacist.

  • Find script currently marked as owing.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Script # Script Number of script included in a Transaction    
Script Type Concession; pension; repat etc    
Patient Contribution Retail value of script charged to customer    
Gov Recov Estimated value of Govt recovery attributable to Scripts “sold”    
Script Amt (Patient Contribution + Gov recovery) for script    
Cost Ex Unit cost of the item in a transaction    
Profit Script Amt – Cost ex    
Markup % [(profit)/Cost ex} x 100    
Drug Description Drug Name from Fred Dispense   Y
Drug From Tab; cap; elix etc   Y
Drug Strength mg; mcg; mg/ml; mcg/ml etc   Y
Pack Size Supplier’s nominated pack size for this item   Y
Unmatched Drug is matched/unmatched to item in Fred Office Plus   Y
Owing Script dispensed as “owing”   Y
Patient Name Patient for whom the item was dispensed   Y
Nursing Home Name of Nursing Home this account is linked to   Y
Pharmacist Clumps rows by Pharmacist who dispensed items   Y
Margin % [(Profit/Script Amt] x 100   Y
Doctor prescriber who wrote the script   Y
Saftey Net Amount Value attributable towards the Safety net target   Y

Summary of report

An advanced “pivot” style report displaying comparative drug information.

Uses can alter the views to dispense information to their liking.

It also include a new brand comparison capability to allow drug bran comparison by month or by year.

Use for:

  • Compare pack or quantity usage by month, year, quarter.

  • Compare cost or profit by drug, month, year or quarter.

  • Compare brand or drug (profit, packs, qty or cost, by month year, quarter.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Year   Y  
Quarter     Y
Month      
Drug Description Drug Name from Fred Dispense Y  
Generic Name generic name of drug used in dispensing   Y
Usage (QTY) Count of items dispensed   Y
Usage (Packs) Number of “packs” dispensed in period    
Cost Unit cost of the item in a transaction    
Profit Script Amt – Cost ex   Y
Pharmacist Clumps rows by Pharmacist who dispensed items   Y
Generic Scripts Scripts dispensed as ‘generic”   Y
Non Generic Scripts Scripts dispensed as ‘original'   Y

Summary of report

Replicate the basic script analysis report found in Fred Dispense.

However, will utilise the accurate costing information available from the POS to determine a true profit value.

Use for:

  • Determine script profitability over a given period in time.

Column Definitions

NIL

Summary of report

An advanced “pivot” style report that displays comparative script analysis information.

Uses can alter the view to display the information to their liking.

Allows uses to compare script type, performance by month, year, quester to determine comparative dispense profitability.

Use for:

  • Compare script type information by month, year or quarter.

  • Compare profitability of scripts by month, year or quarter.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Script Count Number of Scripts dispensed in period    
Year   Y  
Month   Y  
Quarter     Y
Script Type Concession; pension; repat etc    
Total Value Patient Contribution + Govt Recovery    
Cost Unit cost of the item in a transaction   Y
Profit (Total Value) – (Cost Ex)    
Gov Recov Estimated value of Govt recovery attributable to Scripts “sold”   Y
Patient Contribution Retail value of script charged to customer   Y
Tax Value of GST collected (will include GST from Dr Bag, <alt><G> and <?> Dispensing)   Y
Script %     Y

Summary of report

Displays information regarding each script, in particular whether the drug dispensed matched a physical product at the POS.

This report allows uses to review these items that where considered unmatched and resolve them

If the script has already been sold it will not fix that script, but it will ensure that future uses of this drug will correctly track OPS sales data.

Use for:

  • Find drugs that where not matched to an item and resolve them for future dispensing.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Drug Code Code assigned in Fred Dispense to Drug    
Drug Name Drug Name from Fred Dispense    
Drug Form Tab; cap; elix etc    
Drug Strength mg; mcg; mg/ml; mcg/ml etc    
Supplier Code 1 Identifier code for supplier from Fred Dispense    
PDE 1# Reorder code for Supplier shown in supplier code 1    
Supplier Code 2 Identifier code for secondarysupplier from Fred Dispense   Y
PDE 2# Reorder code for Supplier shown in supplier code 2   Y