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
Day Dispensed Splits weekly scripts into individual days Y  
Pharmacist Clumps rows by Pharmacist who dispensed items   Y
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  

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
Cost Ex Unit cost of the item in a transaction    
Dispense Date Date script was processed in Fred Dispense   Y
Doctor Prescribers who wrote the script   Y
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
Gov Recov Estimated value of Govt recovery attributable to Scripts “sold”    
Margin % [(Profit/Script Amt] x 100    
Markup % [(profit)/Cost ex] x 100    
Nursing Home Name of Nursing Home this account is linked to   Y
Owing Script dispensed as “owing”   Y
Pack Size Supplier’s nominated pack size for this item   Y
Patient Contribution Retail value of script charged to customer    
Patient Directions Patient for whom the item was dispensed   Y
Patient Name Patient for whom the item was dispensed   Y
PBS Code Unique identifier for a medication listed on the Australian Pharmaceutical Benefits Scheme   Y
Pharmacist Pharmacist who dispensed item   Y
Profit Script Amt – Cost ex    
Safety Net Amount Value attributable towards the Safety net target   Y
Script # Script Number of script included in a Transaction    
Script Amt (Patient Contribution + Gov recovery) for script    
Script Type Concession; pension; repat etc    
Unmatched Drug is matched/unmatched to item in   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
Cost Unit cost of the item in a transaction    
Drug Description Drug Name from Fred Dispense Y  
Generic Name generic name of drug used in dispensing   Y
Generic Scripts Scripts dispensed as ‘generic”   Y
Month      
Non Generic Scripts Scripts dispensed as ‘original'   Y
Pharmacist Clumps rows by Pharmacist who dispensed items   Y
Profit Script Amt – Cost ex   Y
Quarter     Y
Usage (Packs) Number of “packs” dispensed in period    
Usage (QTY) Count of items dispensed   Y
Year   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.

This allows for a more accurate report based in date from dispense and data from POS.

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
Cost Unit cost of the item in a transaction   Y
Gov Recov Estimated value of Govt recovery attributable to Scripts “sold”   Y
Month   Y  
Patient Contribution Retail value of script charged to customer   Y
Profit (Total Value) – (Cost Ex)    
Quarter     Y
Script Count Number of Scripts dispensed in period    
Script Type Concession; pension; repat etc Y  
Script %     Y
Tax Value of GST collected (will include GST from Dr Bag, <alt><G> and <?> Dispensing)   Y
Total Value Patient Contribution + Govt Recovery    
Year   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 POS 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 Form Tab; cap; elix etc    
Drug Name Drug Name from Fred Dispense    
Drug Strength mg; mcg; mg/ml; mcg/ml etc    
PDE 1# Reorder code for Supplier shown in supplier code 1    
PDE 2# Reorder code for Supplier shown in supplier code 2   Y
Supplier Code 1 Identifier code for supplier from Fred Dispense    
Supplier Code 2 Identifier code for secondarysupplier from Fred Dispense   Y