Loading inventory data…
Overview
Inventory
Analytics
Optimization
Tasks
Utilities
Login
Settings
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
Back
Modify Users
Back
Edit Permissions
Role Permissions
Close
Role to edit
Save
Cancel
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
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.
Refresh SQL Analytics
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
Blob File Uploads
Upload selected files to Azure Blob Storage using the listed destination filename.
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
×