A complete list and description of the Base Reports.


Dispense

DISPENSE - TRADING TOTALS

Report Code 

Report Title

Description

DISP 001

Trading Totals Summary

Summary of Dispense activity and script payment breakdown

DISP 002

Trading Totals Summary by Day

Trading Totals summary performance by Day


DISPENSE - SCRIPT SUMMARY

Report Code 

Report Title

Description

DISP 100

Script Summary by Day

Script dispensing details by Day

DISP 200

Script Summary by Hour

Script dispensing details by Hour

DISP 210

Script Summary Pivot by Day and Hour

Summary pivot of dispensing details by Day and Hour


Promotions

PROMOTIONS - CONFIGURATION

Report Code

Report Title

Description

PROMO 001 

Promotion Summary 

Summary of Promotions and Configuration setup details.

PROMO 002  

Promotion Setup Detail

Summary of Product Configuration details per Promotion.

 

PROMOTIONS - SALES

Report Code

Report Title

Description

PROMO 100 

 

Promotion Sales - Product Summary

Summary of sales performance by Product for the Promotion.

PROMO 200 

 

Promotion Sales Summary Performance

Summary of sales performance for each Promotion.

PROMO 300 

 

Promotion Sales - Product Performance

Summary of sales performance by Product for each Promotion.

 

 

Sales

SALES - SUMMARY

Report Code

Report Title

Description

SALES 001

Sales Summary

Summary of Sales transactions for the selected pharmacy.

SALES 002

Basket Sales Summary

Summary of Basket Sales details for the selected pharmacies

SALES 003

Product Sales Summary by Department

Product-level sale performance summary with monthly net sales trend and contribution by product overviews. 

SALES 004

Category Sales Summary

Summary sales report by Category (department), including trend and contribution reports.

SALES 005

Department Sales Summary by Brand

Department Summary sales report by Brand, including trend and contribution reports.

 

SALES - YEAR TO DATE

Report Code

Report Title

Description

SALES 100

Sales Comparison Summary - Year to Date

Summary comparison of Sales year on year.

SALES 200

Category Sales Summary - Year to Date

Summary sales report by Category (department), including trend and contribution reports.

SALES 400

Category Sales Summary - Year to Date

Summary sales report by Category (department).

STOCK 401

Category Sales Contribution - Year to Date

Summary sales contribution report by Category (department).

  

SALES - COMPARISON BY STORE

Report Code

Report Title

Description

SALES 901

Sales Comparison Summary by Store

Summary comparison of Sales between stores.

SALES 902

Sales Comparison Summary Trend by Store

Summary comparison of Sales Trend between stores.

SALES 903

Sales Transaction Comparison by Store

Summary of Sales transactions for the selected pharmacies.

SALES 904

Sales Transaction Trend Comparison by Store 

Trend of Sales transactions for the selected pharmacies.

SALES 905

Category Sales Comparison Summary by Store

Summary sales report by Category (department), including trend and contribution reports.

SALES 906

Category Net Sales Pivot Table by Store

Net sales pivot table report by Department and Store.

 

SALES – COMPANION SALES

Report Code

Report Title

Description

SALES 700

Companion Sales Summary by Companion Product

Companion Sales Summary report showing estimated value of Companion Sale opportunities.

SALES 710 

Companion Sales Summary by Trigger Product

Companion Sales Summary report showing estimated value of Companion Sale opportunities for each Trigger Product.

 

 
Stock Control

STOCK CONTROL - SUMMARY

Report Code

Report Title

Description

STOCK 001

Product List Report

Product List reports provide an extract of all stock matching the selected filters to assist with pricing and stock control.

STOCK 002

Stock Movement Overview by Department

Overview of the effect of stock movements into and out of your store. The initial table shows negative values for sales as stock moves out of your store.

STOCK 003

Stock Movement Product Summary by Department

Product level report showing the effect of stock movements into and out of the selected store. The initial table shows negative values for sales as stock moves out of the store.

STOCK 008

Dead Stock Report

Product level information by Department, to assist in obtaining a meaningful summary of dead stock. Use the Dead Stock Age to determine the cut-off for Dead Stock for the selected filters.

 

STOCK CONTROL - TRANSFERS

Report Code

Report Title

Description

STOCK 004

Stock Transfers Summary

Summary of Stock Transfers in and out of the pharmacy. 

Note: Stock Transfer purchases into the pharmacy via Order Maintenance are NOT included on this report.

STOCK 005

Stock Transfers AR Customer Summary

Summary of Stock Transfers by AR Customer with breakdown by Department and Product.

STOCK 006

Stock Transfers Product Summary 

Product level summary of stock transfers into / out of the pharmacy with breakdown by Department and AR Customer. The initial table shows negative values for sales as stock moves out of the store.

STOCK 007

Stock Transfers Product Trend 

Product-level stock transfer trend reporting by Department and AR Customer.

  

STOCK CONTROL – STOCK STATUS

Report Code

Report Title

Description

STOCK 200

Stock Status - Store Overview

Stock summary with breakdown by Sales and Product Status.

STOCK 210

Stock Status - Store Comparison

Summary Comparison of Stock across selected stores by Sales and Product Status.

STOCK 220

Stock Status - By Department

Department Stock status summary with breakdown by Sales and Product Status.

STOCK 230

Stock Status - Store Product List

Sales and Product Status extract by Location and Department.

  

STOCK CONTROL – COMPANION PRODUCTS

Report Code

Report Title

Description

STOCK 700

Companion Product List by Trigger

Product List report of products setup with a Companion product trigger for Till, Dispense, or Both.

STOCK 701

Companion Product List by Companion

Product List report of products setup with a Companion product trigger for Till, Dispense, or Both.