Total SKUs
0
unique products
Total Units
0
in stock
Low Stock
0
below threshold
Negative
0
below zero
Scan or Enter DIN / Barcode
Adjust:
Inventory Period
βΌ
| DIN β | Drug Name β | Manufacturer β | Prev. Count β | Current Stock β | Divergence | Threshold | 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. Count | Purchases | Sales | Adjustments | Expected | Actual | Divergence | % |
|---|
Import Data
Mode:
Option A β Upload CSV File directly
OR
Option B β Copy & Paste from Excel (recommended β no re-saving needed)
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
RxStock will automatically use the 2nd DECOMPTE column (the physical count) as starting stock
Stock Adjustments
β Manual Adjustments (Scan Tab)
1
Expired: Scan the product, select "Expired" and enter the quantity. Logged separately for audit trail.
2
Lost/Damaged: Scan the product, select "Lost/Damaged" and enter quantity with a note explaining the reason.
3
Manufacturer Balance: Scan the product, select "Transfer (balance mfr)" and use the note to indicate which manufacturer the units were originally attributed to.