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)