raheelkhan
04-03-2018, 12:58 AM
Hi Sir,
I attached one excel file showing my Purchase Order table. Here item column contains two kind of items
CASE:
i) Materials without size wize break down: Showing Master Name of Item/Qty/Rate Directly
ii)Materials with size wize break down: Showing Master Name of Item BUT QTY/Rate/Value is "0", Qty/Rate/Value showing below
as sub item Name with size description in multiple number of rows right below the master description.
Along with attachment also added example below;
MPO
Date
PI #
Item
Qty
Price
Total
18-MPO-0004
1/2/2018
807-2018
Size Label
0.00
0.00
0.00
18-MPO-0004
1/2/2018
807-2018
NAVY - 10 REG - BRWL-122007-CA-BR4
500.00
0.01
6.96
18-MPO-0004
1/2/2018
807-2018
NAVY - 12 REG - BRWL-122007-CA-BR4
500.00
0.01
6.96
18-MPO-0005
1/2/2018
11-2018
239577-CA - -
427.00
0.07
31.17
18-MPO-0005
1/2/2018
11-2018
Hang tag
0.00
0.00
0.00
18-MPO-0005
1/2/2018
11-2018
239577 - -
2,635.00
0.07
192.36
18-MPO-0005
1/2/2018
11-2018
Hang tag
0.00
0.00
0.00
18-MPO-0005
1/2/2018
11-2018
BRHT-239577-CA-PET-RIDER - -
250.00
0.04
10.25
18-MPO-0005
1/2/2018
11-2018
BRHT-239577-CA-RIDER - -
250.00
0.04
10.25
18-MPO-0006
1/2/2018
12-2018
BRHT-172436
0.00
0.00
0.00
18-MPO-0006
1/2/2018
12-2018
172436 - -
881.00
0.07
59.40
Requirement:
Each Master Item sum up the quantity & Value of all sizes mentioned below the master item + showing the rate as well.
Kindly help in this matter.
Regards
raheel
I attached one excel file showing my Purchase Order table. Here item column contains two kind of items
CASE:
i) Materials without size wize break down: Showing Master Name of Item/Qty/Rate Directly
ii)Materials with size wize break down: Showing Master Name of Item BUT QTY/Rate/Value is "0", Qty/Rate/Value showing below
as sub item Name with size description in multiple number of rows right below the master description.
Along with attachment also added example below;
MPO
Date
PI #
Item
Qty
Price
Total
18-MPO-0004
1/2/2018
807-2018
Size Label
0.00
0.00
0.00
18-MPO-0004
1/2/2018
807-2018
NAVY - 10 REG - BRWL-122007-CA-BR4
500.00
0.01
6.96
18-MPO-0004
1/2/2018
807-2018
NAVY - 12 REG - BRWL-122007-CA-BR4
500.00
0.01
6.96
18-MPO-0005
1/2/2018
11-2018
239577-CA - -
427.00
0.07
31.17
18-MPO-0005
1/2/2018
11-2018
Hang tag
0.00
0.00
0.00
18-MPO-0005
1/2/2018
11-2018
239577 - -
2,635.00
0.07
192.36
18-MPO-0005
1/2/2018
11-2018
Hang tag
0.00
0.00
0.00
18-MPO-0005
1/2/2018
11-2018
BRHT-239577-CA-PET-RIDER - -
250.00
0.04
10.25
18-MPO-0005
1/2/2018
11-2018
BRHT-239577-CA-RIDER - -
250.00
0.04
10.25
18-MPO-0006
1/2/2018
12-2018
BRHT-172436
0.00
0.00
0.00
18-MPO-0006
1/2/2018
12-2018
172436 - -
881.00
0.07
59.40
Requirement:
Each Master Item sum up the quantity & Value of all sizes mentioned below the master item + showing the rate as well.
Kindly help in this matter.
Regards
raheel