Sales Report

[john5599]

Hi
please someone help me to make a sales report as per the attached sheet as in the Sheet2 . If someone help me I will be very thankful.


https://www.dropbox.com/s/6lcxtojqs8s977x/Dummy.xlsx?dl=0

 

[john5599]

Here is the screen shot

may someone help me

This is data

In the report sheet Items are selected through the drop down list.

Sheet3

	A	B	C	D	E	F
1	Date	Invoice No	Party Name	Item Description	Qty	Type
2	01/04/18	54845882231	Bajaj Electrical	Bajaj Majesty DX-4 Iron Box	15	purchase
3	15/04/18	JVM/1835/2018	ARUN TRADERS	Bajaj Majesty DX-4 Iron Box	2	SALE
4	10/04/18	3885646851	Almonarod	Almonarod 250 mm shutter Fan	12	purchase
5	12/04/18	JVM/1836/2018	Sangam Electricals	Almonarod 250 mm shutter Fan	8	SALE
6	15/04/18	Credit Note	Sangam Electricals	Almonarod 250 mm shutter Fan	2	Sales Return
7	13/04/18	Credit Note	ARUN TRADERS	Bajaj Majesty DX-4 Iron Box	1	Sales Return
8	13/04/18	JVM/1837/2018	Gopal Marketing	Bajaj Majesty DX-4 Iron Box	1	Sale
9
10
11
12
13
14
15
16		Note	Purchase = Inward
17
18			Sales Return = Inward
19
20			Sale = Outward
21
22			Scheme = Outward
23
24			Foc = Outward
25
26

<thead>
</thead><tbody>
</tbody>

Excel 2007








Output may like this

Report

	A	B	C	D	E	F	G	H	I	J
1	Item	Almonarod 250 mm shutter Fan					Drop down list here
2	Opening Balance			0		Balance
3	Date	Customer Name	Invoice No.	Inwards	Outwards
4	10/04/18	Almonarod		12		12
5	12/04/18	Sangam Electricals	JVM/1836/2018		8	4
6	15/04/18	Sangam Electricals	Credit Note	2		6
7
8
9
10
11
12
13
14
15

<tbody>
</tbody>

Excel 2007



Master

	A	B	C	D	E
1	Item Name	Stock Opening Balance		Customer Name	Address
2	Almonarod 150 mm Metal Fan Almonard	0		Arun Traders
3	Almonarod 150 mm shutter Fan Almonard	0		Gopal Marketing
4	Almonarod 250 mm shutter Fan	0		Sangam Electricals
5	Almonarod HD AIR 300 mm	0		Bajaj Electrical
6	Almonarod HD AIR 380 mm	0		VGuard
7	Almonarod HD AIR 450 mm	0		Almonarod
8	Almonarod Pedestal Fan 450 mm Almonard	0		Varun Traders
9	Almonarod Pedestal Fan Mark II 80 watts Almonard	1		Sagar Electricals
10	Almonarod Wall Fan Mark II Almonarod	8		Bajaj Electrical

<tbody>
</tbody>

Excel 2007

 

[john5599]

Sir no response from any

 

[john5599]

Admin can you pls. remove this my thread from here.