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. |