Dashboard loading
Loading inventory data…
Overview
Inventory
Analytics
Optimization
Tasks
Contacts
Messages
Reports
Utilities
Login
Settings
Alerts
Close
Login
×
Username
Password
Log In
Forgot password?
Don't have an account?
Sign Up
User Info
Log Out
Username:
Role:
Full Name:
Email:
Status:
Dark Mode
Automatically adjusts based on sunset/sunrise
Modify Users
Edit Permissions
AI Feedback
Back
Modify Users
Back
Edit Permissions
Role Permissions
Close
Role to edit
Save
Cancel
Back
AI Feedback
Prompts rated below 4 stars
Export Prompt Logs CSV
Refresh
Admin Assisted Reset
Admin Username
Admin Password
Target Username
New Password
Confirm New Password
Reset Password
Back to login
Log In
Create Account
Name
Username
Password
Confirm Password
Role
Technician
Staff
Lead
Supervisor
Manager
Director
Pharmacist
Admin
Superuser
Sign Up
Already have an account?
Log In
Delete User
Are you sure you want to delete this user?
Cancel
Delete
Edit User
Username
Full Name
Cancel
Save
Authorization Required
Enter authorizing credentials to proceed.
Authorizing Username
Authorizing Password
Cancel
Approve & Create
OK
Select Avatar
×
Settings
×
Inventory Options
Exclude Standard Inventory
Exclude pyxisStandard amount from all calculations (quantity, usage, projections)
GPO Only
Use only GPO pricing for price comparison and item details pricing
Calculation Settings
Usage Calculation Parameters
Trending Threshold
2 weeks
Number of consecutive weeks of increase/decrease to identify trending items
Percentile Cutoff
25th
Values below this percentile are filtered as outliers (supply constraints)
Test Data (comma or space separated):
1,14,8,12,3,3,1,2
Kept
Filtered Out
Original Avg
-
New Avg
-
Filtered
-
Threshold
-
Trend Detection Parameters
Shortage Impact Thresholds
Critical max days supply
Backordered items at or below this day supply are marked critical.
Severe max days supply
Backordered items above critical and at or below this day supply are marked severe; higher values are moderate.
Restock Efficiency Threshold
Threshold Line Position
0.50
Sets the threshold line position (0.2 - 1.0) for the Restock Efficiency ratio chart and filters items below this value
Pyxis Restock Frequency
1.00
Assumed Pyxis restocks per day used for IUR calculations in Optimization (default: 1×/day)
IUR Trend Weight (w)
2.00
Subtracts w × TrendScore from IUR to increase risk sensitivity when usage is trending up (can push IUR negative)
Shelf Life Period
Projection Period (weeks)
52
Period (in weeks) used to project inventory waste based on average usage rate and expected shelf life (default: 52 weeks)
Expiring Window (months)
3
Counts items with any on-hand inventory expiring within the selected number of months (default: 3)
What-if (Optimization)
Apply lead-time adjustments to
Choose which departments receive lead-time what-if adjustments
All
Pharmacy only
Pyxis only
Lead time multiplier
1.00×
Scales replenishment lead time (e.g., delays, staffing constraints, courier issues)
Lead time adjustment (days)
+0.0
Adds/subtracts days to lead time (positive = slower replenishment)
Demand surge multiplier
1.00×
Multiplies daily usage (e.g., flu season, special events, shortages causing substitutions)
Service level
95%
90%
95%
97.5%
99%
Controls safety stock sensitivity (higher = more conservative reorder points)
Review period (days)
1
Time between replenishment decisions (increases coverage horizon for reorder point)
Horizon
Used for probability-based outputs (when enabled)
7 days
14 days
60 days
Admin
Admin-only SQL maintenance actions.
Backfill Transaction Analytics
Rebuilds weekly/monthly rollups, usage metrics, projections, and optimization from item_transactions.
Trend facts not loaded
Last refresh: checking...
Monthly fact audit: checking...
Run Price Comparsion
Price comparison not run
Refresh Inventory Cost Summary
Inventory cost summary not refreshed
Adspace
Open the adspace frame with editor tools when your role allows editing.
Open Adspace Editor
Blob File Uploads
Upload selected files to Azure Blob Storage using the listed destination filename.
Inventory
Item Details
Purchase
Pricing
Other
Download FDA DECRS
Run Pipeline
Inventory
Item Details
Purchase
Pricing
Other
Add File Name
Blob uploads ready
Save Key
Access keys save to dbo.accessKey
Console Logging
Toggle section-level diagnostics without changing behavior.
Dashboard
Inventory
Analytics
Charts
Spike Factors
Transaction Loader (lazy-load scripts)
Transaction Merge (global/store reconcile)
Tx Range Requests (Dashboard)
FDA API + Parsing
RxNorm API + Parsing
Min Suggestion Report
Show Gantt Chart connection debug lines
Apply Settings & Recalculate
Stock Out Items by Pyxis Location
×
Wasted Items by Pyxis Location
×
Unused Items by Pyxis Location
×
Overloaded Items by Pyxis Location
×