Stock counting

[Romano_odK]

Good afternoon,

Today I started counting the stock and with that I am putting all the products on a location. Now all the products are on location A00, but now I am assigning the real location to them. In my sample you can see what I get from the program I am using. A00 has the original stock mount and the other location are the ones we counted them on now. At the end I need to know what the differences are between A00 and the other location where the stock us now. I got a long sheet with 2500 items this way. Is it possible to consolidate this to one line so I can see the difference.

Thank you your time.


Romano

[TABLE]
[TR]
[TD]Itemcode[/TD]
[TD]Batch/Serie[/TD]
[TD]Artikelomschrijving[/TD]
[TD]Warehouse[/TD]
[TD]Warehouse locataion[/TD]
[TD]Stock[/TD]
[TD]Counted stock[/TD]
[TD]Difference[/TD]
[/TR]
[TR]
[TD]100008[/TD]
[TD][/TD]

[TD]Vito Glaserfix 111 9x3 mm wit - 10x25 m[/TD]
[TD]1[/TD]
[TD]A00[/TD]
[TD]232[/TD]
[TD]0[/TD]
[TD]-232[/TD]
[/TR]
[TR]
[TD]100008[/TD]
[TD][/TD]

[TD]Vito Glaserfix 111 9x3 mm wit - 10x25 m[/TD]
[TD]1[/TD]
[TD]Q07A[/TD]
[TD]0[/TD]
[TD]32[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]100008[/TD]
[TD][/TD]

[TD]Vito Glaserfix 111 9x3 mm wit - 10x25 m[/TD]
[TD]1[/TD]
[TD]Q06B[/TD]
[TD]0[/TD]
[TD]90[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]100008[/TD]
[TD][/TD]

[TD]Vito Glaserfix 111 9x3 mm wit - 10x25 m[/TD]
[TD]1[/TD]
[TD]Q08B[/TD]
[TD]0[/TD]
[TD]110[/TD]
[TD]110[/TD]
[/TR]
[TR]
[TD]100009[/TD]
[TD][/TD]

[TD]Vito Glaserfix 111 9x3 mm zwart - 10x25 m[/TD]
[TD]1[/TD]
[TD]A00[/TD]
[TD]388[/TD]
[TD]0[/TD]
[TD]-388[/TD]
[/TR]
[TR]
[TD]100009[/TD]
[TD][/TD]

[TD]Vito Glaserfix 111 9x3 mm zwart - 10x25 m[/TD]
[TD]1[/TD]
[TD]Q07A[/TD]
[TD]0[/TD]
[TD]98[/TD]
[TD]98[/TD]
[/TR]
[TR]
[TD]100009[/TD]
[TD][/TD]

[TD]Vito Glaserfix 111 9x3 mm zwart - 10x25 m[/TD]
[TD]1[/TD]
[TD]Q05B[/TD]
[TD]0[/TD]
[TD]110[/TD]
[TD]110[/TD]
[/TR]
[TR]
[TD]100009[/TD]
[TD][/TD]

[TD]Vito Glaserfix 111 9x3 mm zwart - 10x25 m[/TD]
[TD]1[/TD]
[TD]Q06B[/TD]
[TD]0[/TD]
[TD]270[/TD]
[TD]270[/TD]
[/TR]
[/TABLE]

 

[proficient]

Sample data with the desired result would be a great help.

 

[Romano_odK]

Sample data with the desired result would be a great help.

Good evening,

Good point, I added it to the sheet. Thank you in advance.

Tellingen 
[TABLE]
[TR]
[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD]Disered result[/TD]
[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]Itemcode[/TD]
[TD]Description[/TD]
[TD]Warehouse location[/TD]
[TD]Stock[/TD]
[TD]Counted stock[/TD]
[TD]Difference[/TD]
[TD][/TD]

[TD]Itemcode[/TD]
[TD]Description[/TD]
[TD]Warehouse location[/TD]
[TD]Stock[/TD]
[TD]Counted stock[/TD]
[TD]Difference[/TD]
[/TR]
[TR]
[TD]101000[/TD]
[TD]Vito Glaserfix 111 9x1 mm wit - 33 m[/TD]
[TD]A00[/TD]
[TD]2240[/TD]
[TD]0[/TD]
[TD]-2240[/TD]
[TD][/TD]

[TD]101000[/TD]
[TD]Vito Glaserfix 111 9x1 mm wit - 33 m[/TD]
[TD][/TD]

[TD][RIGHT]2240[/RIGHT][/TD]
[TD][RIGHT]2236[/RIGHT][/TD]
[TD][RIGHT]-4[/RIGHT][/TD]
[/TR]
[TR]
[TD]101000[/TD]
[TD]Vito Glaserfix 111 9x1 mm wit - 33 m[/TD]
[TD]O01A[/TD]
[TD]0[/TD]
[TD]796[/TD]
[TD]796[/TD]
[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]101000[/TD]
[TD]Vito Glaserfix 111 9x1 mm wit - 33 m[/TD]
[TD]O01C[/TD]
[TD]0[/TD]
[TD]1440[/TD]
[TD]1440[/TD]
[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]101001[/TD]
[TD]Vito Glaserfix 111 9x1 mm zwart - 33 m[/TD]
[TD]A00[/TD]
[TD]3785[/TD]
[TD]0[/TD]
[TD]-3785[/TD]
[TD][/TD]

[TD]101001[/TD]
[TD]Vito Glaserfix 111 9x1 mm zwart - 33 m[/TD]
[TD][/TD]

[TD][RIGHT]3785[/RIGHT][/TD]
[TD][RIGHT]3840[/RIGHT][/TD]
[TD][RIGHT]55[/RIGHT][/TD]
[/TR]
[TR]
[TD]101001[/TD]
[TD]Vito Glaserfix 111 9x1 mm zwart - 33 m[/TD]
[TD]O01A[/TD]
[TD]0[/TD]
[TD]1368[/TD]
[TD]1368[/TD]
[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]101001[/TD]
[TD]Vito Glaserfix 111 9x1 mm zwart - 33 m[/TD]
[TD]O01B[/TD]
[TD]0[/TD]
[TD]1044[/TD]
[TD]1044[/TD]
[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]101001[/TD]
[TD]Vito Glaserfix 111 9x1 mm zwart - 33 m[/TD]
[TD]O01C[/TD]
[TD]0[/TD]
[TD]1429[/TD]
[TD]1429[/TD]
[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]
[/TR]
[/TABLE]

 

[Fluff]

Please re-post your data, but DON'T put it in code tags, just paste it into the reply window.

 

[Romano_odK]

Please re-post your data, but DON'T put it in code tags, just paste it into the reply window.

Tellingen

							Disered result
Itemcode	Description	Warehouse location	Stock	Counted stock	Difference		Itemcode	Description	Warehouse location	Stock	Counted stock	Difference
101000	Vito Glaserfix 111 9x1 mm wit - 33 m	A00	2240	0	-2240		101000	Vito Glaserfix 111 9x1 mm wit - 33 m		2240​	2236​	-4​
101000	Vito Glaserfix 111 9x1 mm wit - 33 m	O01A	0	796	796
101000	Vito Glaserfix 111 9x1 mm wit - 33 m	O01C	0	1440	1440
101001	Vito Glaserfix 111 9x1 mm zwart - 33 m	A00	3785	0	-3785		101001	Vito Glaserfix 111 9x1 mm zwart - 33 m		3785​	3840​	55​
101001	Vito Glaserfix 111 9x1 mm zwart - 33 m	O01A	0	1368	1368
101001	Vito Glaserfix 111 9x1 mm zwart - 33 m	O01B	0	1044	1044
101001	Vito Glaserfix 111 9x1 mm zwart - 33 m	O01C	0	1429	1429