仓库电子账及采购物料跟踪系统模板.xls

序序号号物物料料编编码码标标准准编编码码供供应应商商产产品品名名称称类类别别包包装装物物 单单位位单单重重标标准准包包装装数数量量最最大大容容量量(件件)1308520000201-001张三U8钢笔办公用品盒支100050箱2308620000201-001李四U8钢笔办公用品盒支100050箱3308720000201-001王五U8钢笔办公用品盒支100050箱4308820000201-002李四M7水笔办公用品盒支100050箱5308920000201-003张三M5笔芯办公用品盒支100050箱6309020000201-003李四M5笔芯办公用品盒支100050箱7309120000201-003王五M5笔芯办公用品盒支100050箱8309220000201-004 张三M1.5钢笔办公用品盒支100050箱9309320000201-005张三M2水笔办公用品盒支100050箱10309420000201-005李四M2水笔办公用品盒支100050箱11309520000201-005王五M2水笔办公用品盒支100050箱12309620000201-005王老二M2水笔办公用品盒支100050箱13309720000201-005小陈M2水笔办公用品盒支100050箱启启用用盘盘点点数数量量存存放放区区 最最低低存存量量 最最高高存存量量备备 注注ERPERP品品名名ERPERP规规格格500A-1区10002000国标U8钢笔M1.5*2.5合金500A-1区10002000国标U8钢笔M1.5*2.5合金500A-1区10002000国标U8钢笔M1.5*2.5合金500A-2区10002000国标M7水笔PC合金200A-3区10002000国标M5笔芯PC合金200A-3区10002000国标M5笔芯PC合金200A-3区10002000国标M5笔芯PC合金1000A-4区10002000国标M1.5钢笔PC合金1000A-5区10002000国标M2水笔PC合金1000A-5区10002000国标M2水笔PC合金1000A-5区10002000国标M2水笔PC合金1000A-5区10002000国标M2水笔PC合金1000A-5区10002000国标M2水笔PC合金某某某某公公司司某某某某仓仓采采购购物物料料供供应应状状况况表表序序号号 老老编编码码老老产产品品名名称称ERPERP料料件件编编号号ERPERP品品名名ERPERP规规格格类类别别单单位位标标准准包包装装数数量量供供应应商商13085 U8钢笔20000201-001 国标U8钢笔M1.5*2.5合金办公用品支1000张三23086 U8钢笔20000201-001 国标U8钢笔M1.5*2.5合金办公用品支1000李四33087 U8钢笔20000201-001 国标U8钢笔M1.5*2.5合金办公用品支1000王五43088 M7水笔20000201-002 国标M7水笔PC合金办公用品支1000李四53089 M5笔芯20000201-003 国标M5笔芯PC合金办公用品支1000张三63090 M5笔芯20000201-003 国标M5笔芯PC合金办公用品支1000李四73091 M5笔芯20000201-003 国标M5笔芯PC合金办公用品支1000王五83092 M1.5钢笔20000201-004 国标M1.5钢笔PC合金办公用品支1000张三93093 M2水笔20000201-005 国标M2水笔PC合金办公用品支1000张三103094 M2水笔20000201-005 国标M2水笔PC合金办公用品支1000李四113095 M2水笔20000201-005 国标M2水笔PC合金办公用品支1000王五123096 M2水笔20000201-005 国标M2水笔PC合金办公用品支1000王老二133097 M2水笔20000201-005 国标M2水笔PC合金办公用品支1000小陈14151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798上上月月计计划划未未回回数数量量本本期期已已送送数数量量未未回回数数量量退退回回数数量量采采购购数数量量仓仓库库库库存存状状态态存存放放区区备备 注注100300180002000800正常A-1区1000210002000200正常A-1区1005001600020001000正常A-1区1005901510020001090正常A-2区10030080001000500正常A-3区50020030000323正常A-3区100100000200超超订订A-3区1001000001100超超订订A-4区101010100500正常A-5区1020152500500正常A-5区1030123200700正常A-5区1040104000正常A-5区105010500800正常A-5区0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常某某某某公公司司某某某某仓仓采采购购物物料料供供应应状状况况表表0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常当当前前时时间间:2012/9/8 17:20某某某某公公司司某某某某仓仓进进销销存存月月报报表表-模模板板老老产产品品名名称称ERPERP料料件件编编号号ERPERP品品名名ERPERP规规格格类类别别装装箱箱数数 包包装装物物 单单位位 上上月月结结存存本本月月入入库库车车间间退退回回退退供供应应商商本本月月出出库库本本月月结结存存结结存存状状态态最最低低安安全全库库存存量量8600860020902090707070702977297777137713库库存存周周转转率率U8钢笔20000201-001国标U8钢笔M1.5*2.5合金办公用品1000盒支15008000030020001000支2盒尾数0支3000M7水笔20000201-002国标M7水笔PC合金办公用品1000盒支5005900001090 1000支1盒尾数90支1000M5笔芯20000201-003国标M5笔芯PC合金办公用品1000盒支600600001771023 1000支1盒尾数23支3000M1.5钢笔20000201-004国标M1.5钢笔PC合金办公用品1000盒支10001000001100 1000支1盒尾数100支1000M2水笔20000201-005国标M2水笔PC合金办公用品1000盒支50000707025002500 1000支2盒尾数500支500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000状状态态存存放放区区备备 注注36.50%36.50%报报警警A-1区0正常A-2区0报报警警A-3区0正常A-4区0报报警警A-5区0当库存低于最低安全库存量时，自动就会报警。报警字体颜色为红色，正常为蓝色。甘国辉库存周转率=本月出库/）（上月结存+本月结存）/2）到了月末不需要重新计算，自动会算出来。甘国辉库库存存周周转转率率当当前前时时间间:2012/9/8 17:20某某某某公公司司某某某某仓仓进进销销存存月月报报表表序序号号物物料料编编码码老老产产品品名名称称供供应应商商 ERPERP料料件件编编号号 ERPERP品品名名ERPERP规规格格类类别别装装箱箱数数 包包装装物物 单单位位 上上月月结结存存本本月月入入库库车车间间退退回回退退供供应应商商本本月月出出库库本本月月结结存存合合 计计860086002090209070707070297729777713771313085U8钢笔张三20000201-001国标U8钢笔M1.5*2.5合金 办公用品 1,000盒支50030000080023086U8钢笔李四20000201-001国标U8钢笔M1.5*2.5合金 办公用品 1,000盒支50000030020033087U8钢笔王五20000201-001国标U8钢笔M1.5*2.5合金 办公用品 1,000盒支500500000100043088M7水笔李四20000201-002国标M7水笔PC合金办公用品 1,000盒支500590000109053089M5笔芯张三20000201-003国标M5笔芯PC合金办公用品 1,000盒支20030000050063090M5笔芯李四20000201-003国标M5笔芯PC合金办公用品 1,000盒支200200007732373091M5笔芯王五20000201-003国标M5笔芯PC合金办公用品 1,000盒支2001000010020083092M1.5钢笔张三20000201-004国标M1.5钢笔PC合金办公用品 1,000盒支1000100000110093093M2水笔张三20000201-005国标M2水笔PC合金办公用品 1,000盒支1000000500500103094M2水笔李四20000201-005国标M2水笔PC合金办公用品 1,000盒支100005050500500113095M2水笔王五20000201-005国标M2水笔PC合金办公用品 1,000盒支100002020300700123096M2水笔王老二 20000201-005国标M2水笔PC合金办公用品 1,000盒支100000010000133097M2水笔小陈20000201-005国标M2水笔PC合金办公用品 1,000盒支1000000200800140000150000160000170000180000190000200000210000220000230000240000250000260000270000280000290000300000310000320000330000340000350000360000370000380000390000400000410000420000430000440000450000460000470000480000490000500000510000520000530000540000550000560000570000580000590000600000610000620000630000640000650000660000670000680000690000700000710000720000730000740000750000760000770000780000790000800000810000820000830000840000850000860000870000880000890000900000910000920000930000940000950000960000970000结结存存状状态态存存放放区区 备备 注注库库存存周周转转率率36.50%36.50%1000支0盒尾数800支A-1区01000支0盒尾数200支A-1区01000支1盒尾数0支 A-1区01000支1盒尾数90支A-2区01000支0盒尾数500支A-3区01000支0盒尾数323支A-3区01000支0盒尾数200支A-3区01000支1盒尾数100支A-4区01000支0盒尾数500支A-5区01000支0盒尾数500支A-5区1000支0盒尾数700支A-5区1000支0盒尾数0支 A-5区1000支0盒尾数800支A-5区某某某某公公司司某某某某仓仓采采购购订订单单明明细细老老编编码码老老产产品品名名称称ERPERP料料件件编编号号ERPERP品品名名ERPERP规规格格类类别别单单位位供供应应商商3085 U8钢笔20000201-001国标U8钢笔M1.5*2.5合金办公用品 支张三3086 U8钢笔20000201-001国标U8钢笔M1.5*2.5合金办公用品 支李四3087 U8钢笔20000201-001国标U8钢笔M1.5*2.5合金办公用品 支王五3088 M7水笔20000201-002国标M7水笔PC合金办公用品 支李四3089 M5笔芯20000201-003国标M5笔芯PC合金办公用品 支张三3085 U8钢笔20000201-001国标U8钢笔M1.5*2.5合金办公用品 支张三3086 U8钢笔20000201-001国标U8钢笔M1.5*2.5合金办公用品 支李四3087 U8钢笔20000201-001国标U8钢笔M1.5*2.5合金办公用品 支王五3088 M7水笔20000201-002国标M7水笔PC合金办公用品 支李四日日期期单单据据号号码码 订订购购数数量量 订订购购单单价价 订订购购总总额额备备注注10月7日 0000028910001.9190010月8日 0000029010001.9190010月9日 0000029110001.8180010月10日 0000029210001100010月11日 0000029310002.2220010月12日 0000029410001.9190010月13日 0000029510001.5150010月14日 0000029610001.9190010月15日 0000029710001.919000 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0某某某某公公司司某某某某仓仓采采购购订订单单明明细细0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0某某某某公公司司某某某某仓仓出出入入库库明明细细账账当当前前时时间间:2012/9/82012/9/8老老编编码码老老产产品品名名称称 ERPERP料料件件编编号号ERPERP品品名名ERPERP规规格格类类别别单单位位供供应应商商领领料料部部门门日日期期单单据据号号码码进进仓仓数数量量出出仓仓数数量量当当前前结结存存车车间间退退料料退退回回供供应应商商备备注注单单位位名名称称3085U8钢笔20000201-001国标U8钢笔M1.5*2.5合金办公用品支张三10/20 0000001300800一车间3086U8钢笔20000201-001国标U8钢笔M1.5*2.5合金办公用品支李四九车间10/20 0000002300200二车间3087U8钢笔20000201-001国标U8钢笔M1.5*2.5合金办公用品支王五10/21 00000035001000三车间3088M7水笔20000201-002国标M7水笔PC合金办公用品支李四10/22 00000045901090四车间3089M5笔芯20000201-003国标M5笔芯PC合金办公用品支张三10/23 0000005300500五车间3090M5笔芯20000201-003国标M5笔芯PC合金办公用品支李四10/24 0000006200323六车间3091M5笔芯20000201-003国标M5笔芯PC合金办公用品支王五10/25 0000007100200七车间3092M1.5钢笔20000201-004国标M1.5钢笔PC合金办公用品支张三10/26 00000081001100八车间3093M2水笔20000201-005国标M2水笔PC合金办公用品支张三二车间 10/27 0000009500500九车间3094M2水笔20000201-005国标M2水笔PC合金办公用品支李四四车间 10/28 0000010500500张三3095M2水笔20000201-005国标M2水笔PC合金办公用品支王五四车间 10/29 0000011300700李四3096M2水笔20000201-005国标M2水笔PC合金办公用品支王老二四车间 10/30 000001210000王五3097M2水笔20000201-005国标M2水笔PC合金办公用品支小陈四车间 10/31 0000013200800小陈3090M5笔芯20000201-003国标M5笔芯PC合金办公用品支李四二车间11/1 000001477323王老二3091M5笔芯20000201-003国标M5笔芯PC合金办公用品支王五三车间11/2 00000151002003094M2水笔20000201-005国标M2水笔PC合金办公用品支李四二车间11/3 0000016500503095M2水笔20000201-005国标M2水笔PC合金办公用品支王五三车间11/4 0000017700203094M2水笔20000201-005国标M2水笔PC合金办公用品支李四11/5 0000018500503095M2水笔20000201-005国标M2水笔PC合金办公用品支王五11/6 00000197002062.11