Spreadsheet: 737537d1624458665-vlookup-of-closing-stock-lying-with-the-most-recent-gate-entry-number-closing-stock-vlookup-with-most-recent-purchase
Sheet: Closing Stock

 |  |  |  | This Closing Stock is related to these-these Gate Entry Numbers (Most Recent Gate Entry to be used First in Closing Stock)
 |  |  |  | Ist Lot |  | 2nd Lot |  | 3rd Lot |  | 4th Lot
Item Code | Description | Closing Stock as on today |  | Gate Entry No. | Stock | Gate Entry No. | Stock | Gate Entry No. | Stock | Gate Entry No. | Stock | Total | Check Point (should be Zero)
ARB-157910 | PC RELAY BOARD ARB-574 | 1 | [NAME] required here->>
T0000003 | 1/2 INCH WRENCH EXCEL | 3 | [NAME] required here->>
CAPT0080 | 1Cx16Sq.mm EARTH CABLE -OMAN | 500 | [NAME] required here->>
SPAUP0022 | 2 x 3/2 WAY VALVE - 0 820 055 101 | 1 | [NAME] required here->>
SPAUP0021 | 2 x 3/2 WAY VALVE - 0 820 055 201 | 1 | [NAME] required here->>
1031090037 | 3M Primer 4298 UV | 20.5 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
CAPT0079 | 4Cx16Sq.mm ARMOURED XLPE CABLE -OMAN | 70 | [NAME] required here->>
CAPT0082 | 4Cx16Sq.mm FLEXIBLE RUBBER CABLE BLACK | 250 | [NAME] required here->>
CAPT0081 | 4Cx25Sq.mm FLEXIBLE RUBBER CABLE -BLACK | 100 | [NAME] required here->>
CAPT0078 | 4Cx35Sq.mm ARMOURED XLPE CABLE-OMAN | 60 | [NAME] required here->>
CAPT0083 | 4Cx35Sq.mm CABLE JOINT KIT- RAYCHEM EPKJ | 4 | [NAME] required here->>
SPAUP0023 | 5/2 WAY VALVE - 0 820 055 051 | 1 | [NAME] required here->>
1011030009 | ABS GA850 | 24450 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
1011040069 | ABS Magnum 3416 SC Natural | 6875 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
1011030001 | ABS PA707 | 32500 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
1011030010 | ABS PA757 | 9000 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
CAPTASS0001 | Accessories for Machines | 41 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
1031090067 | [NAME] | 83355 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
CHARGES000 | Additional charges | 2 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
MFS00002 | Additional Kleenoil Filter Cartridge | 8 | [NAME] required here->>
M900000097 | AIR CONDITIONER, TYPE: WALL SPLIT, 1.5TR | 2 | [NAME] required here->>
AIR00000 | AIRMAIL COST | 1 | [NAME] required here->>
ASP000001 | [NAME] | 1 | [NAME] required here->>
CAPT0041 | AutoCAD LT2011 SLM | 1 | [NAME] required here->>
ICZ0000001 | Automatic Sorting System (Model - ZONDA) | 1 | [NAME] required here->>
SPGR0002 | BACK MOUNTING SOCKET P3G-08 | 7 | [NAME] required here->>
SPMBAH0015 | BACK UP RING UNDIVIDED - 150 X 141.4 X 2 | 2 | [NAME] required here->>
SPMBAH0013 | BACK UP RING UNDIVIDED - 170 X 161.4 X 2 | 4 | [NAME] required here->>
SPMBAH0023 | BACKUP RING NONDIVIDED 30 X 34 X 1.4 | 2 | [NAME] required here->>
SPMBAH0026 | BACKUP RING UNDIVIDED  [NAME] | 1 | [NAME] required here->>
1011040024 | [NAME] 00464(A3R bl)-M08107-0 | 16768 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
1011040049 | [NAME] LB75 SK Natural (M08014-0) | 2325 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
PC0000003 | Barrel Purging Compound H00002-4 | 5 | [NAME] required here->>
M15061-0 | Bayblend FR 3000 Nature | 400 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
M15034-0 | Bayblend T 65 Natur | 25 | [NAME] required here->>
1011030002 | BAYBLEND T65 (M15011-0) | 3675 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
1011090007 | Bayblend [NAME] black | 400 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
BE000000 | Blade Ejector Z465/4.5x1.2/80 | 5 | [NAME] required here->>
1011090005 | [NAME] 30 (GB 3114 Black 8229) old | 500 | [NAME] required here->>
1011090008 | BorealisGF30 (GB 311U-8229) Black | 5192 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
SPMDER0005 | BUFFER BATTERY -06753365 | 4 | [NAME] required here->>
B00000001 | Bushing 18, L18 | 1 | [NAME] required here->>
M900000098 | CALIBRATION AND TRAINING FOR QV ACE | 1 | [NAME] required here->>
[NAME] | CAMERA- PS  SX130 BK CANON | 1 | [NAME] required here->>
CAPT000026 | Car | 2 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
MISC00409 | CARPANTORY WORK | 1 | [NAME] required here->>
CAPT0033 | Cash Purchase | 1 | [NAME] required here->>
CVB00000 | Cavity Bush-M087 | 2 | [NAME] required here->>
MTN450000 | Cavity Pin 101 (MTL-45) | 2 | [NAME] required here->>
SK0000001 | Central Lubrication Pump 25 Bar 230 V50Z | 1 | [NAME] required here->>
DEHUMIDIFIER00 | CENTRALISED DEHUMIDIFIER SET | 2 | [NAME] required here->>
CAPT0019 | CHAIR 3360 L/B | 14 | [NAME] required here->>
SPMBAH0024 | CIRCLIP -DIN 471 A 55 | 2 | [NAME] required here->>
CL000000 | [NAME] | 4 | [NAME] required here->>
1011040037 | CO PP 000 66 Coral beige | 475 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
1011040031 | CO PP 000 68 Light modern grey(M10231-0) | 3955 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
M90000017 | Co2 10 LBS | 6 | [NAME] required here->>
CSDME6006 | Coil Spring-DME- SMD6006 | 12 | [NAME] required here->>
CST4020/32X152 | Coil Spring-Hasco-T4020/32X152 | 1 | [NAME] required here->>
CAPT0018 | Conference Table CB003 - 3.8 mtr | 1 | [NAME] required here->>
COC00000 | Connecting Cable VKHM-Z-2.5 | 4 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
CN000000 | Connecting Nozzle 5V ext.heated,tc.con, | 2 | [NAME] required here->> |  |  | ?? | ?? | ?? | ?? | ?? | ??
HRTC68010208D | [NAME], 8 Zone (68010.208D) | 1 | [NAME] required here->>
COO00002 | COOLING NIPPLE- HASCO- Z81X9XR1/8 | 25 | [NAME] required here->>