User Tools

Site Tools


start:supplyprocedures

This is an old revision of the document!


Supply Chain Procedures

Container Management

Supply Chain Procedures

After creating a SKU and a UPC, a GTIN also needs to be created. This Excel function may help:

="10"&LEFT($a2,11)&10-MOD(MID("10"&LEFT($a2,11),2,1)+MID("10"&LEFT($a2,11),4,1)+MID("10"&LEFT($a2,11),6,1)+MID("10"&LEFT($a2,11),8,1)+MID("10"&LEFT($a2,11),10,1)+MID("10"&LEFT($a2,11),12,1)+(MID("10"&LEFT($a2,11),1,1)+MID("10"&LEFT($a2,11),3,1)+MID("10"&LEFT($a2,11),5 ,1)+MID("10"&LEFT($a2,11),7,1)+MID("10"&LEFT($a2,11),9,1)+MID("10"&LEFT($a2,11),11,1)+MID("10"&LEFT($a2,11),13,1))*3,10)
start/supplyprocedures.1494281971.txt.gz · Last modified: 2017/05/08 15:19 by andre