Spreadsheet: 737537d1624458665-vlookup-of-closing-stock-lying-with-the-most-recent-gate-entry-number-closing-stock-vlookup-with-most-recent-purchase
Sheet: Gate Entry Register

Item Code | Gate Entry Number | Description | Curr. Code | UOM | Quantity Purchased | [NAME] | Item Value
ARB-157910 | 78100108 | PC RELAY BOARD ARB-574 | EUR | NOS | 1 | 1
T0000003 | 7810186 | 1/2 INCH WRENCH EXCEL | EUR | NOS | 3 | 1
CAPT0080 | 13100537 | 1Cx16Sq.mm EARTH CABLE -OMAN | EUR | MTR | 500 | 1
SPAUP0022 | 13100002 | 2 x 3/2 WAY VALVE - 0 820 055 101 | EUR | NOS | 1 | 1
SPAUP0021 | 13100002 | 2 x 3/2 WAY VALVE - 0 820 055 201 | EUR | NOS | 1 | 1
1031090037 | 13100187 | 3M Primer 4298 UV | EUR | GLN | 4 | 1
1031090037 | 13100127 | 3M Primer 4298 UV | EUR | GLN | 4 | 1
1031090037 | 12100632 | 3M Primer 4298 UV | EUR | GLN | 4 | 1
1031090037 | 12100631 | 3M Primer 4298 UV | EUR | GLN | 8.5 | 1
CAPT0079 | 13100537 | 4Cx16Sq.mm ARMOURED XLPE CABLE -OMAN | EUR | MTR | 70 | 1
CAPT0082 | 13100537 | 4Cx16Sq.mm FLEXIBLE RUBBER CABLE BLACK | EUR | MTR | 250 | 1
CAPT0081 | 13100537 | 4Cx25Sq.mm FLEXIBLE RUBBER CABLE -BLACK | EUR | MTR | 100 | 1
CAPT0078 | 13100537 | 4Cx35Sq.mm ARMOURED XLPE CABLE-OMAN | EUR | MTR | 60 | 1
CAPT0083 | 13100537 | 4Cx35Sq.mm CABLE JOINT KIT- RAYCHEM EPKJ | EUR | NOS | 4 | 1
SPAUP0023 | 13100002 | 5/2 WAY VALVE - 0 820 055 051 | EUR | NOS | 1 | 1
1011030009 | 15100982 | ABS GA850 | EUR | KGS | 1000 | 1
1011030009 | 15100237 | ABS GA850 | EUR | KGS | 2000 | 1
1011030009 | 15100002 | ABS GA850 | EUR | KGS | 1000 | 1
1011030009 | 14100910 | ABS GA850 | EUR | KGS | 1000 | 1
1011030009 | 14100910 | ABS GA850 | EUR | KGS | 1000 | 1
1011030009 | 14100104 | ABS GA850 | EUR | KGS | 2000 | 1
1011030009 | 13100333 | ABS GA850 | EUR | KGS | 3000 | 1
1011030009 | 13100060 | ABS GA850 | EUR | KGS | 3000 | 1
1011030009 | 12100459 | ABS GA850 | EUR | KGS | 850 | 1
1011030009 | 12100456 | ABS GA850 | EUR | KGS | 150 | 1
1011030009 | 12100297 | ABS GA850 | EUR | KGS | 2000 | 1
1011030009 | 12100006 | ABS GA850 | EUR | KGS | 3000 | 1
1011030009 | 11100138 | ABS GA850 | EUR | KGS | 2450 | 1
1011030009 | 11100077 | ABS GA850 | EUR | KGS | 2000 | 1
1011040069 | 16100902 | ABS Magnum 3416 SC Natural | EUR | KGS | 1000 | 1
1011040069 | 16100897 | ABS Magnum 3416 SC Natural | EUR | KGS | 1000 | 1
1011040069 | 16100358 | ABS Magnum 3416 SC Natural | EUR | KGS | 875 | 1
1011040069 | 15100570 | ABS Magnum 3416 SC Natural | EUR | KGS | 1000 | 1
1011040069 | 15100430 | ABS Magnum 3416 SC Natural | EUR | KGS | 1000 | 1
1011040069 | 14100554 | ABS Magnum 3416 SC Natural | EUR | KGS | 2000 | 1
1011030001 | 14100689 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 14100689 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 14100360 | ABS PA707 | EUR | KGS | 2000 | 1
1011030001 | 14100239 | ABS PA707 | EUR | KGS | 2000 | 1
1011030001 | 14100040 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 13100634 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 13100482 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 12100551 | ABS PA707 | EUR | KGS | 3000 | 1
1011030001 | 11100670 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 11100671 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 11100666 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 11100667 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 11100618 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 11100388 | ABS PA707 | EUR | KGS | 2000 | 1
1011030001 | 11100203 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 90100228 | ABS PA707 | EUR | KGS | 2000 | 1
1011030001 | 90100204 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 89100428 | ABS PA707 | EUR | KGS | 3000 | 1
1011030001 | 78100330 | ABS PA707 | EUR | KGS | 1000 | 1
1011030001 | 78100054 | ABS PA707 | EUR | KGS | 1500 | 1
1011030001 | 7810036 | ABS PA707 | EUR | KGS | 4000 | 1
1011030010 | 16100899 | ABS PA757 | EUR | KGS | 1000 | 1
1011030010 | 16100268 | ABS PA757 | EUR | KGS | 1000 | 1
1011030010 | 15100997 | ABS PA757 | EUR | KGS | 1000 | 1
1011030010 | 15100823 | ABS PA757 | EUR | KGS | 1000 | 1
1011030010 | 15100568 | ABS PA757 | EUR | KGS | 2000 | 1
1011030010 | 15100403 | ABS PA757 | EUR | KGS | 2000 | 1
1011030010 | 15100173 | ABS PA757 | EUR | KGS | 1000 | 1
CAPTASS0001 | 14100363 | Accessories for Machines | EUR | NOS | 2 | 1
CAPTASS0001 | 13100511 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100512 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100513 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100514 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100515 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100516 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100517 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100502 | Accessories for Machines | EUR | NOS | 2 | 1
CAPTASS0001 | 13100503 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100504 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100505 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100506 | Accessories for Machines | EUR | NOS | 2 | 1
CAPTASS0001 | 13100491 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100388 | Accessories for Machines | EUR | NOS | 1 | 1
CAPTASS0001 | 13100390 | Accessories for Machines | EUR | NOS | 23 | 1
1031090067 | 16100432 | [NAME] | EUR | NOS | 37337 | 1
1031090067 | 16100327 | [NAME] | EUR | NOS | 43235 | 1
1031090067 | 16100056 | [NAME] | EUR | NOS | 2783 | 1
CHARGES000 | 14100158 | Additional charges | EUR | NOS | 1 | 1
CHARGES000 | 89100644 | Additional charges | EUR | NOS | 1 | 1
MFS00002 | 7810242 | Additional Kleenoil Filter Cartridge | EUR | NOS | 8 | 1
M900000097 | 7810013 | AIR CONDITIONER, TYPE: WALL SPLIT, 1.5TR | EUR | NOS | 2 | 1
AIR00000 | 89100509 | AIRMAIL COST | EUR | NOS | 1 | 1
ASP000001 | 78100325 | [NAME] | EUR | NOS | 1 | 1
CAPT0041 | 12100101 | AutoCAD LT2011 SLM | EUR | NOS | 1 | 1
ICZ0000001 | 89100452 | Automatic Sorting System (Model - ZONDA) | EUR | NOS | 1 | 1
SPGR0002 | 89100598 | BACK MOUNTING SOCKET P3G-08 | EUR | NOS | 7 | 1
SPMBAH0015 | 89100491 | BACK UP RING UNDIVIDED - 150 X 141.4 X 2 | EUR | NOS | 2 | 1
SPMBAH0013 | 89100491 | BACK UP RING UNDIVIDED - 170 X 161.4 X 2 | EUR | NOS | 4 | 1
SPMBAH0023 | 89100491 | BACKUP RING NONDIVIDED 30 X 34 X 1.4 | EUR | NOS | 2 | 1
SPMBAH0026 | 89100491 | BACKUP RING UNDIVIDED  [NAME] | EUR | NOS | 1 | 1
1011040024 | 12100209 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 1989 | 1
1011040024 | 11100593 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 1990 | 1
1011040024 | 90100286 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 440 | 1
1011040024 | 89100665 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 2000 | 1
1011040024 | 89100627 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 1000 | 1
1011040024 | 89100507 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 1000 | 1
1011040024 | 89100360 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 1000 | 1
1011040024 | 89100362 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 75 | 1
1011040024 | 78100253 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 625 | 1
1011040024 | 78100242 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 1149 | 1
1011040024 | 7810247 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 2000 | 1
1011040024 | 7810194 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 575 | 1
1011040024 | 7810170 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 1000 | 1
1011040024 | 7810164 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 350 | 1
1011040024 | 7810160 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 75 | 1
1011040024 | 7810096 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 500 | 1
1011040024 | 7810048 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 950 | 1
1011040024 | 7810037 | [NAME] 00464(A3R bl)-M08107-0 | EUR | KGS | 50 | 1
1011040049 | 14100034 | [NAME] LB75 SK Natural (M08014-0) | EUR | KGS | 100 | 1
1011040049 | 13100520 | [NAME] LB75 SK Natural (M08014-0) | EUR | KGS | 1225 | 1
1011040049 | 13100366 | [NAME] LB75 SK Natural (M08014-0) | EUR | KGS | 1000 | 1
PC0000003 | 78100179 | Barrel Purging Compound H00002-4 | EUR | NOS | 5 | 1
M15061-0 | 78100285 | Bayblend FR 3000 Nature | EUR | KGS | 150 | 1
M15061-0 | 78100166 | Bayblend FR 3000 Nature | EUR | KGS | 75 | 1
M15061-0 | 7810259 | Bayblend FR 3000 Nature | EUR | KGS | 125 | 1
M15061-0 | 7810215 | Bayblend FR 3000 Nature | EUR | KGS | 50 | 1
M15034-0 | 7810181 | Bayblend T 65 Natur | EUR | KGS | 25 | 1
1011030002 | 11100057 | BAYBLEND T65 (M15011-0) | EUR | KGS | 850 | 1
1011030002 | 89100503 | BAYBLEND T65 (M15011-0) | EUR | KGS | 1000 | 1
1011030002 | 89100359 | BAYBLEND T65 (M15011-0) | EUR | KGS | 1000 | 1
1011030002 | 89100347 | BAYBLEND T65 (M15011-0) | EUR | KGS | 200 | 1
1011030002 | 78100334 | BAYBLEND T65 (M15011-0) | EUR | KGS | 300 | 1
1011030002 | 78100318 | BAYBLEND T65 (M15011-0) | EUR | KGS | 25 | 1
1011030002 | 78100232 | BAYBLEND T65 (M15011-0) | EUR | KGS | 300 | 1
1011090007 | 15100455 | Bayblend [NAME] black | EUR | KGS | 100 | 1
1011090007 | 14100873 | Bayblend [NAME] black | EUR | KGS | 100 | 1
1011090007 | 14100873 | Bayblend [NAME] black | EUR | KGS | 100 | 1
1011090007 | 13100157 | Bayblend [NAME] black | EUR | KGS | 50 | 1
1011090007 | 13100047 | Bayblend [NAME] black | EUR | KGS | 25 | 1
1011090007 | 13100048 | Bayblend [NAME] black | EUR | KGS | 25 | 1
BE000000 | 78100261 | Blade Ejector Z465/4.5x1.2/80 | EUR | NOS | 5 | 1
1011090005 | 13100029 | [NAME] 30 (GB 3114 Black 8229) old | EUR | KGS | 500 | 1
1011090008 | 16100132 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 800 | 1
1011090008 | 15100252 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 500 | 1
1011090008 | 14100927 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 500 | 1
1011090008 | 14100927 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 500 | 1
1011090008 | 14100687 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 200 | 1
1011090008 | 14100687 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 200 | 1
1011090008 | 14100538 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 300 | 1
1011090008 | 14100180 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 500 | 1
1011090008 | 14100031 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 300 | 1
1011090008 | 13100703 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 207 | 1
1011090008 | 13100498 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 10 | 1
1011090008 | 13100496 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 350 | 1
1011090008 | 13100030 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 500 | 1
1011090008 | 12100622 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 75 | 1
1011090008 | 12100579 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 125 | 1
1011090008 | 12100580 | BorealisGF30 (GB 311U-8229) Black | EUR | KGS | 125 | 1
SPMDER0005 | 13100578 | BUFFER BATTERY -06753365 | EUR | NOS | 4 | 1
B00000001 | 78100033 | Bushing 18, L18 | EUR | NOS | 1 | 1
M900000098 | 7810044 | CALIBRATION AND TRAINING FOR QV ACE | EUR | NOS | 1 | 1
[NAME] | 13100026 | CAMERA- PS  SX130 BK CANON | EUR | NOS | 1 | 1
CAPT000026 | 14100594 | Car | EUR | NOS | 1 | 1
CAPT000026 | 14100541 | Car | EUR | NOS | 1 | 1
MISC00409 | 11100703 | CARPANTORY WORK | EUR | NOS | 1 | 1
CAPT0033 | 11100695 | Cash Purchase | EUR | NOS | 1 | 1
CVB00000 | 89100372 | Cavity Bush-M087 | EUR | NOS | 2 | 1
MTN450000 | 78100261 | Cavity Pin 101 (MTL-45) | EUR | NOS | 2 | 1
SK0000001 | 89100426 | Central Lubrication Pump 25 Bar 230 V50Z | EUR | NOS | 1 | 1
DEHUMIDIFIER00 | 89100704 | CENTRALISED DEHUMIDIFIER SET | EUR | NOS | 2 | 1
CAPT0019 | 11100352 | CHAIR 3360 L/B | EUR | NOS | 14 | 1
SPMBAH0024 | 89100491 | CIRCLIP -DIN 471 A 55 | EUR | NOS | 2 | 1
CL000000 | 78100106 | [NAME] | EUR | NOS | 4 | 1
1011040037 | 78100184 | CO PP 000 66 Coral beige | EUR | KGS | 30 | 1
1011040037 | 78100084 | CO PP 000 66 Coral beige | EUR | KGS | 270 | 1
1011040037 | 7810255 | CO PP 000 66 Coral beige | EUR | KGS | 150 | 1
1011040037 | 7820003 | CO PP 000 66 Coral beige | EUR | KGS | 20 | 1
1011040037 | 7820004 | CO PP 000 66 Coral beige | EUR | KGS | 5 | 1
1011040037 | 7810183 | CO PP 000 66 Coral beige | EUR | KGS | 0 | 1
1011040037 | 7810180 | CO PP 000 66 Coral beige | EUR | KGS | 0 | 1
1011040031 | 89100666 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 2000 | 1
1011040031 | 89100577 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 480 | 1
1011040031 | 89100542 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 500 | 1
1011040031 | 89100377 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 250 | 1
1011040031 | 89100358 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 200 | 1
1011040031 | 89100359 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 70 | 1
1011040031 | 78100084 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 200 | 1
1011040031 | 7810261 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 5 | 1
1011040031 | 7810255 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 200 | 1
1011040031 | 7810256 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 25 | 1
1011040031 | 7820003 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 20 | 1
1011040031 | 7820004 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 5 | 1
1011040031 | 7810183 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 0 | 1
1011040031 | 7810180 | CO PP 000 68 Light modern grey(M10231-0) | EUR | KGS | 0 | 1
M90000017 | 7810115 | Co2 10 LBS | EUR | NOS | 6 | 1
CSDME6006 | 89100684 | Coil Spring-DME- SMD6006 | EUR | NOS | 12 | 1
CST4020/32X152 | 89100692 | Coil Spring-Hasco-T4020/32X152 | EUR | NOS | 1 | 1
CAPT0018 | 11100351 | Conference Table CB003 - 3.8 mtr | EUR | NOS | 1 | 1
COC00000 | 89100344 | Connecting Cable VKHM-Z-2.5 | EUR | NOS | 2 | 1
COC00000 | 78100333 | Connecting Cable VKHM-Z-2.5 | EUR | NOS | 2 | 1
CN000000 | 89100437 | Connecting Nozzle 5V ext.heated,tc.con, | EUR | NOS | 1 | 1
CN000000 | 78100146 | Connecting Nozzle 5V ext.heated,tc.con, | EUR | NOS | 1 | 1
HRTC68010208D | 78100048 | [NAME], 8 Zone (68010.208D) | EUR | NOS | 1 | 1
COO00002 | 89100501 | COOLING NIPPLE- HASCO- Z81X9XR1/8 | EUR | NOS | 25 | 1