Look Up Product
Adjust:
Inventory Period
▼
| DIN ⇅ | Drug Name ⇅ | Strength ⇅ | Prev. Count ⇅ | Current Stock ⇅ | Divergence ⇅ | Expected | Actions |
|---|
Divergence Summary — Potential Issues
Products where the actual count diverges from what the system expects. Sorted by severity. Click a row to view the full calculation breakdown.
| DIN | Drug Name | Prev. | Purchases | Sales | Adj. | Expected | Actual | Divergence | % | Note |
|---|
Physical Count Checklist
Check off each product as you physically count it. Progress is saved automatically.
Merge Duplicate DINs
Combine two products that share the same DIN or were imported under different names into one. Stock quantities are added together.
Keep this product (primary)
⟵
Merge this into it (will be deleted)
Duplicate DIN Detector
Finds products sharing the same DIN, or with very similar names that may have been imported twice under different labels.
Click "Scan for Duplicates" to check your inventory.
Import Data
Mode:
Option A — Upload CSV File directly
OR
Option B — Copy & Paste from Excel (recommended)
How to Import Sales (Stock OUT)
📤 Ubik — Sales Report (Rapport statistique des produits)
1
In Ubik, go to Gestion → Rapports → Autres → Rapport statistique des produits
2
In the product type filter, select only: Contrôlé, Contrôlé rapportable, Narcotique, Narcotique rapportable, Substance ciblée
3
Generate the report in EXCEL format — open the file in Excel
4
In Excel, go to File → Save As, choose CSV (comma delimited) (*.csv) and save
5
Go to the Import tab, select "Sale — subtract from stock"
6
Click "Upload CSV File" (Option A) and select the .csv file you just saved
💡 Tip: If the file upload doesn't detect the right columns, use Option B (paste) instead: open the CSV in Notepad, press Ctrl+A then Ctrl+C, and paste into the text box.
How to Import Purchases (Stock IN)
📥 Ubik — Purchase Report (Substances narcotiques et contrôlées)
1
In Ubik, go to Accueil → Rapports → Substances narcotiques et contrôlées
2
Generate the report in EXCEL format — open the file in Excel
3
In Excel, go to File → Save As, choose CSV (comma delimited) (*.csv) and save
4
Go to the Import tab, select "Purchase — add to stock"
5
Click "Upload CSV File" (Option A) and select the .csv file you just saved
💡 Tip: Quantity is automatically calculated as boxes ordered × units per box (e.g. 2 boxes of 100 = 200 units). The package size is read from the drug name description.
How to Migrate Your Legacy Inventory
📋 Excel Legacy Report (DECOMPTE)
1
Open your Excel inventory sheet (the one with DIN, PRODUIT, DECOMPTE columns)
2
In Excel, go to File → Save As, choose CSV (comma delimited) (*.csv) and save
3
Go to the Import tab, select "Migrate legacy inventory (DECOMPTE)"
4
Click "Upload CSV File" (Option A) and select the .csv file
5
NarCount will automatically use the DECOMPTE column as the previous count baseline
Stock Adjustments
⚙ Manual Adjustments (Lookup Tab)
1
Expired: Look up the product, select "Expired" and enter the quantity. Logged separately for audit trail.
2
Lost/Damaged: Look up the product, select "Lost/Damaged" and enter quantity with a note explaining the reason.
3
Manufacturer Balance: Look up the product, select "Transfer" and use the note to indicate the manufacturer.