Create report by merging duplicates items based on low price

[leap out]

Hello
I put the result in REPORT sheet from row2 with some formulas how should calculate for columns H,J,K .
so if the items in column D for SALES sheet contains price for column( I )smaller than price for column (I) for STOCK sheet then should do :
1- merge duplicates items based on column D for SALES sheet in just one case , if SALES sheet contains price for column( I )smaller than price for column (I) for STOCK sheet(should ignore the same duplicates item if the price is equel between two sheets or the price in SALES sheet bigger than STOCK sheet as in item AA-1 for row7,9 in SALES sheet .
2- should merge column H for sales sheet and put in column F for REPORT sheet .
3- should merge J for sales sheet and put in column I for REPORT sheet .
4- should brings price for the same item from STOCK sheet for column I to REPORT sheet and put in column G
5-in REPORT sheet the column H=column I / column F
6-in REPORT sheet column J= column F*(column H-column G)
7- in REPORT sheet column K= column J * column F
8- insert TOTAL (LOSS) row and summing in column K
9-finally any change in STOCK & SALES sheets should automatically in REPORT sheet .

INVEN with single search v0 c (1) (1).xlsm
	A	B	C	D	E	F	G	H	I	J
1	item	INV NO	ORDER NO	CODE	BRAND	TYPE	MANUFACTURE	QTY	UNIT PRICE	AMOUNT
2	1	SS-001	SS-001	AA-1	10W40 208L	Q8	EU	10	222.2	2222
3	2	SS-001	SS-001	AA-2	15W40 208L	CAS	SU	5	80	400
4	3	SS-001	SS-001	AA-3	5W30 208L	Q8	EU	10	80	800
5	4	SS-001	SS-001	AA-4	5W30 12x1L	Q8	EU	5	120	600
6	5	SS-001	SS-001	AA-5	10W40 208L	ENI	IT	15	20	300
7	6	SS-002	SS-002	AA-6	5W30 4x4L	Q8	EU	10	20	200
8	7	SS-002	SS-002	AA-7	10W40 12x1L	Q8	EU	10	12	120
9	8	SS-003	SS-003	AA-8	15W40 12x1L	CAS	SU	5	90	450
10	9	SS-004	SS-004	AA-9	10W40 12x1L	ENI	IT	20	44.5	890
11	10	SS-005	SS-005	AA-10	10W40 4x4L	Q8	EU	5	69	345
12	11	SS-006	SS-006	AA-11	10W40 4x4L	CAS	SU	10	15	150
13	12	SS-007	SS-007	AA-12	10W40 4x4L	ENI	IT	5	24.6	123
14	13	SS-007	SS-007	AA-13	5W40 4x4L	Q8	EU	20	22.8	456
15	14	SS-008	SS-008	AA-14	5W40 4x4L	CAS	SU	5	135.6	678
16	15	SS-009	SS-009	AA-15	5W40 4x4L	ENI	IT	10	123.4	1234
17	16	SS-010	SS-010	AA-16	20W50 4x4L	Q8	EU	5	114	456
Stock

INVEN with single search v0 c (1) (1).xlsm
	A	B	C	D	E	F	G	H	I	J
1	DATE	INV NO	ORDER NO	CODE	BRAND	TYPE	MANUFACTURE	QTY	UNIT PRICE	AMOUNT
2	01/01/2021	SAL-005	SCA-005	AA-5	10W40 208L	ENI	IT	2.00	18.00	36.00
3	02/01/2021	SAL-006	SCA-006	AA-6	5W30 4x4L	Q8	EU	2.00	24.00	48.00
4	03/01/2021	SAL-007	SCA-007	AA-7	10W40 12x1L	Q8	EU	2.00	22.00	44.00
5	05/01/2021	SAL-009	SCA-009	AA-9	10W40 12x1L	ENI	IT	1.00	50.00	50.00
6	06/01/2021	SAL-001	SCA-001	AA-1	10W40 208L	Q8	EU	2.00	220.00	440.00
7	10/01/2021	SAL-010	SCA-010	AA-1	10W40 208L	Q8	EU	2.00	225.00	450.00
8	11/01/2021	SAL-011	SCA-011	AA-11	10W40 4x4L	CAS	SU	1.00	12.00	12.00
9	12/01/2021	SAL-011	SCA-011	AA-1	10W40 208L	Q8	EU	2.00	222.20	444.00
10	13/01/2021	SAL-012	SCA-012	AA-7	10W40 12x1L	Q8	EU	2.00	22.00	90.00
11	14/01/2021	SAL-013	SCA-013	AA-13	5W40 4x4L	Q8	EU	2.00	30.00	60.00
12	15/01/2021	SAL-014	SCA-014	AA-14	5W40 4x4L	CAS	SU	1.00	140.00	140.00
13	16/01/2021	SAL-014	SCA-014	AA-11	10W40 4x4L	CAS	SU	1.00	13.00	13.00
14	18/01/2021	SAL-016	SCA-016	AA-16	20W50 4x4L	Q8	EU	1.00	125.00	125.00
15	19/01/2021	SAL-017	SCA-017	AA-1	10W40 208L	Q8	EU	2.00	219.00	438.00
sales

INVEN with single search v0 c (1) (1).xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	ITEM	CODE	BRAND	TYPE	MANUFACTURE	SALES	STOCK PRICE	SALES PRICE	AMOUNT	COST LOWER	AMOUNT AFTER LOWER
2	1	AA-1	10W40 208L	Q8	EU	4	222.2	219.5	878	-10.8	-43.2
3	2	AA-5	10W40 208L	ENI	IT	2	20	18	36	-4	-8
4	3	AA-11	10W40 4x4L	CAS	SU	2	15	12.5	25	-5	-10
5									TOTAL(LOSS)	-16	-61.2
REPORT

Cell Formulas
Range	Formula
H2:H4	H2	=I2/F2
J2:J4	J2	=F2*(H2-G2)
K2:K4	K2	=J2*F2
K5	K5	=SUM(K2:K4)

also posted here
Merge duplicates items based on price decreasing when compare with another sheet
thanks