• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Stock allocation

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
 
email2madhusudhan
Could You reread Your thread?
Create an Excel-file, which has Your Sample values.
Add there also needed results with clear rules.
allocation
ProductStyle NoSizerspEANQtySite NameBIN NO
Kurtiabc81 CM (XS)1998122345CT-AHMEDABAD-AMBAVADII need here bin NO
Kurtiabc81 CM (XS)1998122320CT-NAGPUR-POONAM MALL-VIP ROAD
Kurtiabc81 CM (XS)1998122315CT-HYDERABAD-G.S.CENTER POINT
stock
BARCODEBINsohQty
1223F2-R16-P1559
1223F2-R16-P1628
 

vletm

Excel Ninja
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.
 
Top