Daily Summary Report

Date Range

Item Name

Inv. Transaction Type

Date Range

Item Name

Inv. Transaction Type

Expired On Date Range

Item ID

Item Name

Last Entry Date Range

Delivery Date Duration

Years Months

Last Delivery Date Range

Received On Date

Item ID

Item Name

Sub Stock

Inventory Type

#	Item ID Item Name	Date MM/YYYY	Catalog Cost/Unit	Begin Qty. Begin Cost	Inv. Transaction Type	In Qty. In Cost	Out Qty. Out Cost	Balance Qty. Balance Cost
1	PHBPADP0 BLUE PAD *1	05/01/2021 01/2021	6.95	10 69.50	Dispensed from ICU NS3 Transfer Req. # 21541651	- 00	- -	10 69.50
2	PHBPADP0 BLUE PAD *1	06/01/2021 01/2021	6.95	10 69.50	Acquisitions (non-PO based) Lorem Ipsum akjfdk asfjln kasfda dsdvg	- -	8 55.60	2 13.90
3	PHBPADP0 BLUE PAD *1	07/01/2021 01/2021	6.95	10 69.50	Dispensed from ICU NS3 Transfer Req. # 21541651	3 20.85	- -	5 34.75
4	PHBPADP0 BLUE PAD *1	08/01/2021 01/2021	6.95	10 69.50	Procured PO#: 654365452 Invoice#: 254652131	30 208.50	- -	35 243.25
5	PHBPADP0 BLUE PAD *1	09/01/2021 01/2021	6.95	10 69.50	Acquisitions (non-PO based) Lorem Ipsum akjfdk asfjln kasfda dsdvg	- -	15 104.25	29 139.00
6	PHBPADP0 BLUE PAD *1	10/01/2021 01/2021	6.95	10 69.50	Procured PO#: 654365452 Invoice#: 254652131	5 34.75	- -	25 173.75
7	PHBPADP0 BLUE PAD *1	11/01/2021 01/2021	6.95	10 69.50	Acquisitions (non-PO based) Lorem Ipsum akjfdk asfjln kasfda dsdvg	- -	4 27.80	21 145.95

#	Item ID Item Name	Date MM/YYYY	Catalog Cost/Unit	Begin Qty. Begin Cost	Inv. Transaction Type	In Qty. In Cost	Out Qty. Out Cost	Balance Qty. Balance Cost
1	PHBPADP0 BLUE PAD *1	05/01/2021 01/2021	6.95	100 695	Dispensed from ICU NS3 Transfer Req. # 21541651	- -	- -	100 695.00
2	PHBPADP0 BLUE PAD *1	06/01/2021 01/2021	6.95	- -	Acquisitions (non-PO based) Lorem Ipsum akjfdk asfjln kasfda dsdvg	30 208.50	- -	130 903.50
3	PHBPADP0 BLUE PAD *1	07/01/2021 01/2021	6.95	- -	Dispensed from ICU NS3 Transfer Req. # 21541651	10 69.50	- -	140 973.00
4	PHBPADP0 BLUE PAD *1	08/01/2021 01/2021	6.95	- -	Procured PO#: 654365452 Invoice#: 254652131	- -	40 278.00	105 729.75
5	PHBPADP0 BLUE PAD *1	09/01/2021 01/2021	6.95	- -	Acquisitions (non-PO based) Lorem Ipsum akjfdk asfjln kasfda dsdvg	5 34.75	- -	105 729.75
6	PHBPADP0 BLUE PAD *1	10/01/2021 01/2021	6.95	- -	Procured PO#: 654365452 Invoice#: 254652131	- -	20 139.00	85 590.75
7	PHBPADP0 BLUE PAD *1	11/01/2021 01/2021	6.95	- -	Acquisitions (non-PO based) Lorem Ipsum akjfdk asfjln kasfda dsdvg	- -	4 27.80	81 562.95

#	Inventory Type	Item ID	Item Name	Unit(DU)	Expiry Date	Remaining Qty	Price Per Unit	Total Amount
1	Equipment	PHBPADP0	BLUE PAD *1	Bottle	21-01-2022	553	142	8326
2	Supply	PHBPADP0	BLUE PAD *1	Strip	16-02-2022	231	586	9753
3	Housekeeping	PHBPADP0	BLUE PAD *1	Capsule	27-05-2022	310	510	9780
4	Equipment	PHBPADP0	BLUE PAD *1	Capsule	26-07-2022	563	496	4659
5	Equipment	PHBPADP0	BLUE PAD *1	Tablet	28-08-2022	597	688	9943
6	Medicine	PHBPADP0	BLUE PAD *1	Bottle	19-08-2022	527	701	5091
7	Supply	PHBPADP0	BLUE PAD *1	Strip	15-08-2022	189	382	4914

#	Item ID	Item Name	Unit (DU)	Price Per Unit	Last Entry Date	Entry Days	Last Delivery Date	Delivery Days	Remaining Qty	Total Price	Expiry Date
1	PHBPADP0	BLUE PAD *1	Bottle	142..52	11-05-2021	04	04-05-2021	11	94	13396.88	04-05-2022
2	PHBPADP0	BLUE PAD *1	Strip	586.35	11-05-2021	04	04-05-2021	11	92	53944.2	04-05-2022
3	PHBPADP0	BLUE PAD *1	Capsule	510.24	11-05-2021	04	04-05-2021	11	58	29593.92	04-05-2022
4	PHBPADP0	BLUE PAD *1	Capsule	496.58	11-05-2021	04	04-05-2021	11	52	25822.16	04-05-2022
5	PHBPADP0	BLUE PAD *1	Tablet	688.84	11-05-2021	04	04-05-2021	11	61	42019.24	04-05-2022
6	PHBPADP0	BLUE PAD *1	Bottle	701.45	11-05-2021	04	04-05-2021	11	25	17536.25	04-05-2022
7	PHBPADP0	BLUE PAD *1	Strip	382.87	11-05-2021	04	04-05-2021	11	83	31778.21	04-05-2022

#	Inventory Type	Item Name Item ID	Vendor Name Vendor ID	PO No.	PRs#	Unit (DU)	Qty (DU)	Price Per Unit	Total Price	Recieved On Date	Invoice No.
1	Housekeeping	BLUE PAD *1 PHBPADP0	ABC 8027 SUPP ABC 9187	8204297	PR76144799 +2	Bottle	200	75.50	15100.50	10-03-2021	9949870
2	Stationery	BLUE PAD *1 PHBPADP0	ABC 6504 SUPP ABC 5844	8563681	PR76144749	Pack	280	60.50	16940.50	12-05-2021	6235116
3	Supply	BLUE PAD *1 PHBPADP0	ABC 7448 SUPP ABC 8540	9018434	PR76144750 +1	Strip	400	50.50	20200.50	20-06-2021	9305128
4	Medicine	BLUE PAD *1 PHBPADP0	ABC 8555 SUPP ABC 6347	7863256	PR76144754	Tablet	670	30.50	20435.50	21-09-2021	6430373
5	Supply	BLUE PAD *1 PHBPADP0	ABC 8058 SUPP ABC 6563	9526059	PR76144766	Strip	550	35.50	19475.50	21-09-2021	7289920
6	Housekeeping	BLUE PAD *1 PHBPADP0	ABC 9279 SUPP ABC 6954	6028426	PR76144778	Syrup	350	40.50	14175.50	25-09-2021	7935348
7	Medicine	BLUE PAD *1 PHBPADP0	ABC 9301 SUPP ABC 6388	6164588	PR76144763	Bottle	800	25.50	20400.50	25-09-2021	5570794

#	Sub Stock Name	Inventory Type	Item ID	Item Name	Unit (DU)	Delivered Qty (DU)	Delivered Date	Delivered Time	Remaining Qty (DU)
1	OPD Nurse Station N2	Housekeeping	PHBPADP0	BLUE PAD *1	Bottle	200	10-03-2021	13:37	4500
2	IPD Nurse Station N7	Stationery	PHBPADP0	BLUE PAD *1	Pack	280	12-05-2021	23:52	520
3	ICU A5	Supply	PHBPADP0	BLUE PAD *1	Strip	400	20-06-2021	10:18	400
4	OR Room 4	Medicine	PHBPADP0	BLUE PAD *1	Tablet	670	21-09-2021	18:50	670
5	CCU C3	Supply	PHBPADP0	BLUE PAD *1	Strip	550	21-09-2021	20:32	750
6	Pharmacy N9	Housekeeping	PHBPADP0	BLUE PAD *1	Syrup	350	25-09-2021	20:26	550
8	Pharmacy N12	Medicine	PHBPADP0/td>	BLUE PAD *1	Bottle	800	25-09-2021	10:30	1000

Daily Summary Report Page Header Name / Inner Page Name