Excel进销存表格-仓库进销存表格-简单的库房做账表格-自动计算库存

索引目录:2012012012022012032012042012051月入库2月入库3月入库4月入库5月入库1月出库2月出库3月出库4月出库5月出库1月汇总2月汇总3月汇总4月汇总5月汇总2012072012082012092012102012117月入库8月入库9月入库10月入库11月入库7月出库8月出库9月出库10月出库11月出库7月汇总8月汇总9月汇总10月汇总11月汇总基础数据!2018年度2012066月入库6月出库6月汇总20121212月入库12月出库12月汇总返回首页产品简码货品编码名称规格产品类别单位台用量进货方式备注1B0001AV100中文上壳原材料个12B0002AV100液晶-中文(成)A个13B0003指纹罩C个14B0004AV100喇叭(成)B个15B0005AV100主板(成）A个16B0006AV100指纹仪驱动板光学指纹模块(SM-621)A个17B0007AV/C下壳B个18B0008键盘电路板－AV/AC100B个19B0009蓄电池（6节成）A个8901B000901AV/AC蓄电池电路板B个111B0010网络模块（红）A个112B0011AV100中文外上壳-UB个113B0012USB板(成)-AV/ACA个114B0013AV100英文上壳B个115B0014AV100液晶-英文(成)A个116B0015AV100英文外上壳-UB个117B0017AC100液晶（成）A个118B0018AC100读卡盖C个119B0019AC100主板(061130)(成）以前是0609A个120B0020AC100中文上壳-U半成品个121B0021AC100英文上壳半成品个122B0022OA101上壳(银色)半成品个123B0023OA101下壳(银色)半成品个124B0024OA100液晶(成)新半成品个125B0025232座成半成品个126B0026电源座(成)半成品个127B0027AV200喇叭(成)半成品个128B0028AV200主板-大板(0502)半成品个129B0029AV200主板-小板(0409)半成品个130B0030FE900键盘电路(成)半成品个131B0031调音板(成)半成品个132B0032T8-3主板(0606)（成）半成品个133B0033T8上壳(黑）半成品个234B0034FB300液晶（成）半成品个1635B0035FB300主板半成品个236B0037采集头蓝光半成品个137B003701COMS(成)半成品个438B003702COMS(成)-14P有14P座半成品片39B0038FB300初始化按钮（成）红头半成品个140B0039AV200/300指纹仪光学指纹模块(SM-621)半成品个141B0040AV300喇叭(成)半成品套142B0041USB连接线半成品根143B0042OA101主板(成)半成品个144B0043水滴小PCB板（成）半成品个145B0044水滴控制电路盒(主板盒)半成品个846B0045FB100电路板（成）半成品个847B0046水滴套件半成品个248B0047机械套件半成品个149B0048FB300套件半成品个150B0049FB100套件半成品个151B0050AC100英文上壳-U半成品个452B0051蓄电池(5节装成)半成品个1第3页，共363页53B0052FE900喇叭（成）半成品个154B0055FB100主板半成品个155B0056OA200上壳银色不带ANVIZ字半成品个1256B0057OA200下壳银色半成品个2057B0058AMJ601主板（成）半成品个1558B0059OA200接口板（成）电源板半成品个459B0060OA200-ID主板（成）半成品个460B0061OA200-ID键盘板（成）半成品个161B0063OA200灯板（成）半成品个862B0064OA200喇叭（成）半成品个663B0065OA200液晶（成）半成品个364B0066AV100英文中性上壳半成品个465B0067AC100英文中性上壳半成品个2466B0068AC100中文中性上壳半成品个167B0069AV100英文BIO中性上壳半成品个1668B0070AMJ602主板（成）半成品个169B0071FB300机械套件半成品套170B0072T8-M1主板半成品个171B0073T8-M1读卡模块（小板）半成品个172B0074OA200上壳黑色不带ANVIZ字半成品个173B0075OA200下壳黑色半成品个174B0076AV100英文中性上壳黑色半成品个175B0077AV100英文中性下壳黑色半成品个176B0078OA101上壳(黑色)半成品个177B0079OA101下壳(黑色)半成品个1578B0080OA100蓄电池电路板（成）半成品个379B0081T8上壳（银）半成品个180B0082OA180大板(成)半成品个181B0083OA180小板(成)半成品个182B0085OA2000接口板半成品个183B0086英文AC（smart)上壳半成品个84B0087英文AC（smart)-U上壳半成品个185B0088OA180上壳（银）半成品个86B0089OA180下壳（银）半成品个387B0090OA180上壳（黑）FINGERPRINT半成品个188B0091OA180下壳（黑）半成品个189B0092OA200下壳(黑）老半成品个190B0093OA200上壳黑色带ANVIZ字半成品个191B0094水滴主板盒（印字）半成品个17692B0095OA180按键(黑)左半成品个193B0096OA180电池盖(黑）半成品个194B0097OA180按键（白）左半成品个295B0098FBX00主板(成)半成品个196B0099OA2000液晶屏转接板LCD_V1.2半成品块197B0100T8-ID主板(成)半成品个198B0101OA2000主板（成）半成品个199B0102MSP430F1121A(成）半成品个2100B0103W7854-PLCC44(成)半成品个2101B0104双九电池盒（成）半成品个1102B0105T60主板_V2.2（成）半成品个3103B0106T60液晶（成）半成品片1104B0107X180上壳（黑）BIOELECTRONIX半成品个1105B0108T60主壳(弹性黑)半成品个3106B0109T60外配壳(亮金银色)香槟金半成品个1第4页，共363页107B0110T60按键(白色16键)半成品个1108B0111行程开关（成）带滚轮半成品个1109B0112OA180上壳（白）半成品个1110B0113OA180下壳（白）半成品个1111B0114OA180电池盖(白)半成品个1112B0115OA180喇叭(成)半成品个1113B0116T8-ID线圈线半成品个2114B0117FB200面罩(成)半成品个1115B0118OA200上壳(银色)带ANVIZ字半成品个3116B0119OA200下壳银色带ANVIZ字半成品个4117B0121FB300面罩（成）半成品个1118B0122OA2000喇叭（成）半成品个1119B0123OA2000启动按扭半成品个1120B0124FB200外接电源座(成)半成品个4121B0125FB200液晶屏(成)半成品个2122B0126FE900启动按钮(成)半成品个2123B0127T60喇叭(成)半成品个4124B0129OA2000接口板V1.3(071018)半成品片1125B0132OA200主板(成)半成品块1126B0133OA200键盘板(成)半成品块1127B0134OA180上壳(珍珠黑)BIOELECTRONIXFINGERPRINTTIMEATTENDANCESYSTEM半成品个1128B0135新网络模块半成品片129B0136OA180下壳(珍珠黑)半成品个1130B0137FB200指纹仪罩半成品个1131B0139Laokes按键半成品个1132B0140T8-IDV2.2主板(成)半成品片1133B0141L2000-BACK小板V2.3(成)锁后板半成品片134B0142L2000-FRONT大板V2.3(成)锁前面板半成品片135B0143L2000-USB板(成)半成品片136B0144BF531ModuleV1.1主板半成品块2137B0145QADIS_V1.2(070305)主板(成)半成品片1138B0146OA2000V1.1底板(成)半成品片1139B0147OA200上壳黑色SeMarket半成品个1140B0148OA200上壳银色SeMarket半成品个1141B0149AV100英文BIO中性上壳(有孔)BEATRON半成品个1142B0150L2000电池盒半成品个1143B0151L2000电池盖带ANVIZ半成品个1144B0152L2000装饰环电铬半成品个1145B0153L2000按键(左)半成品个1146B0154L2000导电柱套圈半成品个1147B0155L2000锁体前壳金色半成品个1148B0156L2000锁体后壳金色半成品个1149B0157L2000锁体滑盖金色半成品个1150B0158L2000锁体把手金色半成品个1.5151B0159L2000喇叭半成品个1152B0160FB200外接电源盒半成品个1153B0161MODEM_V0.2主板(成)Si2457.Bom半成品片1154B0162OA280KeyBoardBOMV1.1半成品片1155B0163OA280V1.1BOM大板半成品片1156B0164OA180上壳(珍珠黑)FINGERPRINTTIMEATTENDANCESYSTEM半成品个2157B0165OC200上壳(银)印OC200样字半成品个2158B0166OA200上壳弹性黑色不带ANVIZ字半成品个1159B0167OA200下壳弹性黑色半成品个1第5页，共363页160B0168OA200上壳（黑）印刷TIMEWARE半成品个2161B0170OA180USB线半成品个12162B0171OA101上壳弹性黑半成品个1163B0172OA101下壳弹性黑半成品个1164B0173NR2网络模块半成品片8165B0174RS232=TCP/EP/MODEM接口板半成品个12166B0175指纹仪及驱动板5000枚指纹光学指纹模块(SM-621-16M)半成品个2167B0176OA99上壳印ANVIZ字半成品个1168B0177T60采集头(白光)半成品个1169B017701OA99采集仪COMS板V2.1OA99，OA101+上用半成品片2170B0178OA180接口板V1.5半成品片1171B0179OA180USB板-V1.5(成)半成品片172B0180OA200上壳弹性黑色丝印上有两个人行图半成品个4173B0181OA99下壳半成品个4174B018266J60主板V3半成品片1175B0188OC200上壳珍珠黑带ANVIZ字半成品个1176B0189OC200下壳珍珠黑半成品个1177B0190OA180（白）下壳-U半成品个1178B0191OA99装饰环半成品个1179B0192WIFI_MODElite_ver12主板半成品片1180B0193OC200主板(成)半成品片1181B0194OC200键盘板(成)半成品片1182B0195蓄电池板-OA101_V1.1半成品片1183B0196OA99上壳(中性)无ANVIZ字印OA99半成品1184B0197OA99下壳(中性)无ANVIZ字半成品1185B0198OC200中性上壳无ANVIZ字半成品1186B0199OA180接口板V1.6半成品块1187B0200OA200上壳定制的弹性黑BIOLIVING半成品个1188B0201OC200上壳定制的珍