仓库电子账及采购物料跟踪系统模板.xls
仓库电子账及采购物料跟踪系统模板.xls
- 配套讲稿：
如PPT文件的首页显示word图标，表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制：
部分文档作品中含有的国旗、国徽等图片，仅作为作品整体效果示例展示，禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词：
- 仓库 电子 采购 物料 跟踪 系统 模板
- 资源描述：
-
序序号号物物料料编编码码标标准准编编码码供供应应商商产产品品名名称称类类别别包包装装物物 单单位位单单重重标标准准包包装装数数量量最最大大容容量量(件件)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展开阅读全文
咨信网温馨提示：1、咨信平台为文档C2C交易模式，即用户上传的文档直接被用户下载，收益归上传人（含作者）所有；本站仅是提供信息存储空间和展示预览，仅对用户上传内容的表现方式做保护处理，对上载内容不做任何修改或编辑。所展示的作品文档包括内容和图片全部来源于网络用户和作者上传投稿，我们不确定上传用户享有完全著作权，根据《信息网络传播权保护条例》，如果侵犯了您的版权、权益或隐私，请联系我们，核实后会尽快下架及时删除，并可随时和客服了解处理情况，尊重保护知识产权我们共同努力。
2、文档的总页数、文档格式和文档大小以系统显示为准(内容中显示的页数不一定正确)，网站客服只以系统显示的页数、文件格式、文档大小作为仲裁依据，个别因单元格分列造成显示页码不一将协商解决，平台无法对文档的真实性、完整性、权威性、准确性、专业性及其观点立场做任何保证或承诺，下载前须认真查看，确认无误后再购买，务必慎重购买；若有违法违纪将进行移交司法处理，若涉侵权平台将进行基本处罚并下架。
3、本站所有内容均由用户上传，付费前请自行鉴别，如您付费，意味着您已接受本站规则且自行承担风险，本站不进行额外附加服务，虚拟产品一经售出概不退款（未进行购买下载可退充值款），文档一经付费（服务费）、不意味着购买了该文档的版权，仅供个人/单位学习、研究之用，不得用于商业用途，未经授权，严禁复制、发行、汇编、翻译或者网络传播等，侵权必究。
4、如你看到网页展示的文档有www.zixin.com.cn水印，是因预览和防盗链等技术需要对页面进行转换压缩成图而已，我们并不对上传的文档进行任何编辑或修改，文档下载后都不会有水印标识（原文档上传前个别存留的除外），下载后原文更清晰；试题试卷类文档，如果标题没有明确说明有答案则都视为没有答案，请知晓；PPT和DOC文档可被视为“模板”，允许上传人保留章节、目录结构的情况下删减部份的内容；PDF文档不管是原文档转换或图片扫描而得，本站不作要求视为允许，下载前可先查看【教您几个在下载文档中可以更好的避免被坑】。
5、本文档所展示的图片、画像、字体、音乐的版权可能需版权方额外授权，请谨慎使用；网站提供的党政主题相关内容(国旗、国徽、党徽－－等)目的在于配合国家政策宣传，仅限个人学习分享使用，禁止用于任何广告和商用目的。
6、文档遇到问题，请及时联系平台进行协调解决，联系【微信客服】、【QQ客服】，若有其他问题请点击或扫码反馈【服务填表】；文档侵犯商业秘密、侵犯著作权、侵犯人身权等，请点击“【版权申诉】”，意见反馈和侵权处理邮箱：1219186828@qq.com；也可以拔打客服电话：0574-28810668；投诉电话：18658249818。
实名认证
平台协调中心【客服】
自信AI助手
微信客服
客服QQ
发送邮件
意见反馈
链接地址：https://www.zixin.com.cn/doc/445008.html