Stock allocation

[email2madhusudhan]

TABLE-1
ITEM SO Qty
Chair 11 i need barcode here
Table 5
Chair 1
Chair 16
Table 25
Table 12

TABLE-2
Item Stock
Chair 30 same chair i hav 2barcode one barcode is 890000000078890-18qty
890000000077888-22qty
Tables 50
899000000067888-25qty
896899000000000- 25qty

How to make alocotion

How to make allocation

 

[vletm]

email2madhusudhan
Could You reread Your thread?
Create an Excel-file, which has Your Sample values.
Add there also needed results with clear rules.

 

[email2madhusudhan]

email2madhusudhan
Could You reread Your thread?
Create an Excel-file, which has Your Sample values.
Add there also needed results with clear rules.

• #1

allocation
Product	Style No	Size	rsp	EAN	Qty	Site Name	BIN NO
Kurti	abc	81 CM (XS)	1998	1223	45	CT-AHMEDABAD-AMBAVADI	I need here bin NO
Kurti	abc	81 CM (XS)	1998	1223	20	CT-NAGPUR-POONAM MALL-VIP ROAD
Kurti	abc	81 CM (XS)	1998	1223	15	CT-HYDERABAD-G.S.CENTER POINT
stock
	BARCODE	BIN	sohQty
	1223	F2-R16-P15	59
	1223	F2-R16-P16	28

 

[vletm]

email2madhusudhan
Hmm?
If that Your '#1' really ... If you do cross-post, please put that in your post. ... it would be more clear 'put'.
Should I find Excel-file somewhere?
Your thread is or was about stock allocation ... now ... I need here bin NO.
If You'll change Your original thread to something else ... please, create a new thread.

 

[AlanSidman]

crossposted: https://www.mrexcel.com/board/threads/i-need-allocation-fommula.1128543/#post-5453206

Also a duplicate post in this forum.