ZERO STOCK REPORT

This Reports to show the items less then 0 by Supplier


SELECT [IMAGE_NAME] ,[ITEM #] ,[ITEM NAME] ,(SELECT TITLE FROM SUPPLIER WHERE SUPPLIER_ID=[SUPPLIER]) ,[UNITS ON HAND],[STATUS],SUPPLIER FROM ITEM WHERE STATUS ='A' AND [UNITS ON HAND] <=0 ORDER BY 7
Found 73 Records
Item Item # Description Supplier Status Stock
Cinque Terre MONITOR_TV_ACSSMON01 17 LCD PROTECTIVE FILTER A 0
Cinque Terre TEMP_0123 PS5 CONTROLER THIRD PARTY A 0
Cinque Terre SECURITY CAMERA ETC._BULLET CAMERA_CCTV CAMERA09 CW202 BULLET SHAPE INFRA RED A 0
Cinque Terre 4.90E+12 WII LUNCHUK A 0
Cinque Terre TEMP_0098 PS4 GAME RESIDENT EVIL 6 A -1
Cinque Terre OPTICAL DRIVE_DVD_SATA_911HWUR432742 LG SATA DVD RW BLACK INTERNAL A 0
Cinque Terre LAPTOP_PARTS_KEYBOARD Original internal keyboard for laptop A 0
Cinque Terre TEMP_0061 PLAYSTATION 4: WHITE DAY A -1
Cinque Terre SECURITY CAMERA ETC._BRACKET_CCTV BRAKET03 LONG BRACKET FOR CAMERA A -3
Cinque Terre TEMP_0030 2.4 GHZ WIRELESS GAMEPAD FOR WINDOWS MAC OS LINUX ANDROID TGZ-706W A -1
Cinque Terre TEMP_0008 BOXING WEEK SALE UP TO 50 % OFF Regular Items A 0
Cinque Terre CELL PHONE AND ACCS_COVER_0430 iPHONE 15 PLUS Clear Case by SPACE COLLECTION A -3
Cinque Terre TEMP_0049 PLAYSTATION 4: MINECRAFT PLAYSTATION 4 EDITION A -1
Cinque Terre ELECTRONICS_TABLET0007 SAMSUNG TABLET CHARGER A -1
Cinque Terre STORAGE_EXTERNAL 3.5_CASE_0001 NEXSTAR TX 3.5 SATA ENCLOSURE 6GBPS HDD A 0
Cinque Terre SOFTWARE_ANTIVIRUS_0020 kaspersky anti virus 1 year subscription A -1
Cinque Terre TEMP_0115 PLAYSTATION 5: WHITEDAY Including Costume DLC A 0
Cinque Terre HEADPHONE_MICROPHONE4 SOMIC SM001 MICROPHONE A -2
Cinque Terre TEMP_0051 PLAYSTATION 4: NHL 18 A 0
Cinque Terre SECURITY CAMERA ETC._CAMERA_0007 EAGLESTAR PRO 23-3355 used INDOOR/OUTDOOR CAMERA POWERONE A 0
Cinque Terre CELL PHONE AND ACCS._HANDFREE_041 Wicked Audio "Pure Sound Sycron" Stereo Earbuds COMPUTER PLUG A 0
Cinque Terre KEYBOARD MOUSE AND ACCS_KBW_0003 KEYBOARD: TARGUS KB214 WIRELESS KEYBOARD QUAD SOURCE A -2
Cinque Terre STORAGE_SATA 2.5_0018 SEAGATE 1TB 2.5 INCH SATA HARD DRIVE QUAD SOURCE A -1
Cinque Terre CABLE_PHONE_001 RJ11 PHONE CABLE 6 FEET QUAD SOURCE A 0
Cinque Terre MEDIA_SDMMC_MEM CARD_0013 kingston microsd sdcs2 256gb class 10 QUAD SOURCE A -2
Cinque Terre LAPTOP_POWER SUPPLY_RP_0008 Type C USB-C, APPLE 87-Watt USB 3.1 AC Power Adapter QUAD SOURCE A -2
Cinque Terre STORAGE_USB DRIVE_0027 KINGSTON USB-C 3.2 TYPE C 64 GB FLASH DDRIVE DT70 64 QUAD SOURCE A 0
Cinque Terre HEADPHONE_PC_HPWM_0012 HP DHE-8002 Gaming Headset Black With Mic QUAD SOURCE A 0
Cinque Terre ELECTRONICS_REMOTE_0007 GE 24944 UNIVERSAL REMOTE QUAD SOURCE A -5
Cinque Terre HEADPHONE_PC_HPWM_0014 OVLENG GT66 Gaming Headset with Mic QUAD SOURCE A 0
Cinque Terre GEN-ACCESSORIES_CABLE TIE_0001 GE NAIL IN CLIPS QUAD SOURCE A 0
Cinque Terre STORAGE_SATA 3.5_0001 SATA 3.5 2TB HDD SEAGATE . QUAD SOURCE A -1
Cinque Terre KEYBOARD MOUSE AND ACCS_PAD_0018 PRINTED GAMING MOUSE PAD 60INC X110 INCH QUAD SOURCE A 0
Cinque Terre NETWORKING_RANGE EXTENDER_0003 TP-LINK RE300 AC1200 MESH WI-FI EXTENDER DUAL-BAND NEW QUAD SOURCE A 0
Cinque Terre TEMP_014 IPOD 5G 32GB USED C A -1
Cinque Terre SR_SERVICE_LAPTOP Laptop Repair IN HOUSE C A -165
Cinque Terre CELL PHONE AND ACCS._SCREEN 14 TEMPERED GLASS: Samsung Galaxy S3 i9300 C A -4
Cinque Terre MONITOR_TV_TV_LED_0005 TCL 32S327-CA 1080p Smart LED Television 2019 32 INCH C A 0
Cinque Terre TEMP_0060 PLAYSTATION 4: CALL OF DUTY WWII C A 0
Cinque Terre CELL PHONE AND ACCS._PHONE_0611 SAMSUNG GALAXY A06 USED 10-10 CONDTION C A -1
Cinque Terre MONITOR_TV_TV_LED_0004 RCA rt3205 HD READY TV, 32 ", NEW WALMART A 0
Cinque Terre CELL PHONE AND ACCS._SCREEN 027 APPLE iPAD AIR SCREEN PROTECTOR (PLAIN) BUDGET ELECTRONICS (C) A -1
Cinque Terre CELL PHONE AND ACCS_COVER_0089 IPHONE 5/5S slim armor BUDGET ELECTRONICS (C) A -2
Cinque Terre CELL PHONE AND ACCS_COVER_0050 SAMSUNG GALAXY S4 OTTER CASE BUDGET ELECTRONICS (C) A -1
Cinque Terre CELL PHONE AND ACCS._POUCH_019 Universal Leather Case with Keyboard - 9 inch Tablets BUDGET ELECTRONICS (C) A 0
Cinque Terre CELL PHONE AND ACCS._CHARGER_0038 DOCKING CHARGER: IPHONE 6, 6 PLUS CHARGING DOCK BUDGET ELECTRONICS (C) A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0081 HTC Battery for DESIRE 601 NEXUS C A 0
Cinque Terre CELL PHONE AND ACCS._SIM_001 Nano Sim Adaptor UR WIRELESS A -22
Cinque Terre CELL PHONE AND ACCS._SCREEN 24 APPLE IPAD 2/3/4 TEMPERED GLASS UR WIRELESS A -2
Cinque Terre CELL PHONE AND ACCS._SCREEN_0041 TEMPERED GLASS: IPHONE XS MAX 6.5 UR WIRELESS A -7
Cinque Terre CELL PHONE AND ACCS._CHARGER_0126 WIRELESS CHARGER: PISEN 15W UR WIRELESS A 0
Cinque Terre CELL PHONE AND ACCS._SIM_005 ROGERS SIM CARD UR WIRELESS A -1
Cinque Terre CELL PHONE AND ACCS_COVER_0196 CREATIVE FASHION CASE LG K4 2017 WALLET CASE UR WIRELESS A -2
Cinque Terre CELL PHONE AND ACCS._SCREEN_0046 TEMPERED GLASS: SAMSUNG GALAXY A10 UR WIRELESS A -5
Cinque Terre ELECTRONICS_OTHER_0002 Square Reader for magstripe with Lightning connector New Open Box IN HOUSE ASSEMBLE A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0251 SAMSUNG GALAXY S6 BACK COVER GOLD ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_LCD_0008 SAMSUNG S10 PLUS LCD REPLACEMENT ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0165 ALCATEL ONE TOUCH IDOL X6040 LCD DIGITIZER White ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0297 SAMSUNG J727 LCD BLACK ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0325 IPHONE X CHARGING PORT FLEX ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS_COVER_0121 Hybrid Case - iPhone 6/6S BUDGET ELECTRONICE A 0
Cinque Terre CELL PHONE AND ACCS._SIM_008 ROGERS SIM CARD TRIPLE COMBO BUDGET ELECTRONICE A -1
Cinque Terre CELL PHONE AND ACCS._GEN_0003 Mobile Phone Screen Magnifier BUDGET ELECTRONICE A -1
Cinque Terre CELL PHONE AND ACCS._PARTS_0063 BLACKBERRY Z10 REPLACEMENT BATTERY BUDGET ELECTRONICE A 0
Cinque Terre CELL PHONE AND ACCS._POUCH_0044 GOOSPERY BLUE MOON LG G6 BLACK WALLET COVER CELLNTELL C A -2
Cinque Terre CELL PHONE AND ACCS_COVER_0146 YESIDO IPHONE 7/8 PLUS FASHION CASE GRAY CELLNTELL C A -2
Cinque Terre CELL PHONE AND ACCS._PARTS_0306 SAMSUNG GALAXY S8 BACK COVER BLACK CELLNTELL A 0
Cinque Terre CELL PHONE AND ACCS_COVER_0298 NOTE 10 PRO RING MAGNET CASE sunny wireless c A -1
Cinque Terre CELL PHONE AND ACCS._CHARGER_0018 WALL CHARGER COMBO: SAMSUNG GALAXY 15W (MICRO USB SUPER FAST CHARGER) sunny wireless c A -6
Cinque Terre ELECTRONICS_CONSUMER_0002 Hoco HP23 Diamond Electric Hair Clipper Hair Styling Key sunny wireless c A 0
Cinque Terre TEMP_0017 KEYBOARD: MARVO 2.4 WIRELESS KEYBOARD AND MOUSE LONGTECH INC A 0
Cinque Terre CELL PHONE AND ACCS._HANDFREE_BT_0118 HOCO EQ3 CRYSTAL TWS HEADSET MOBIFIX A 0
Cinque Terre CELL PHONE AND ACCS._MOUNT_0075 TRIPOD MOBILE PHONE CAMERA TRIPOD Q-L3388 GADGET TECH WORLD A 0