工厂仓库管理表

,序号品名编码型号规格类型单位放置库位可放置数量待放数量备注,1.09101.0KPF-AA01-a994.0待放数量=可放置数量-库存数量,2.09102.0KPF-AA01-b,3.09103.0KPF-BA02-a,4.09104.0KPF-BA02-b,5.09105.0KPF-CA03-a,6.09106.0KPF-CA03-b,7.09107.0KPF-DA04-a,8.09108.0KPF-DA04-b,9.0合成树脂B0001KPF半成品C01-a,10.0合成树脂B0002KPF995*200半成品C01-b994.0,11.042,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,备注：扫码枪扫码自动上传数据,序号月份日期供应商入库单号二维码品名编码型号规格类型单位入库数量库位经办人待料天数呆料天数,G00011101J0000002511101,2.0G00011102J0000002511102,3.0G00011103J0000002511103,4.0G00011104J0000002511104,5.0G00011105J0000002511105,6.0G00011106J0000002511106,7.0G00011107J0000002511107,G00011108J0000002511108,G00011109J0000002511109,10.0G00011110J0000002511110145.0,11.0G00011111J0000002511111,12.0G00011112J0000002511112,13.0G00011113J0000002511113,14.0G00011114J0000002511114,15.0G00011115J0000002511115,16.0G00011116J0000002511116,17.0G00011117J0000002511117,18.0G00011118J0000002511118,19.0G00011119J0000002511119,20.0G00011120J0000002511120,21.043682.0G00011121J0000002511121141.0,22.0G00011122J0000002511122,23.0G00011123J0000002511123,24.0G00011124J0000002511124,25.0G00011125J0000002511125,26.0G00011126J0000002511126,27.0G00011127J0000002511127,28.0G00011128J0000002511128,29.0G00011129J0000002511129,30.0G00011130J0000002511130,31.0,32.0,33.0,34.0,35.0,备注：扫码枪扫码自动上传数据,序号月份出库单号二维码日期品名编码型号规格类型单位出库数量库位经办人备注,C0001201J00000025111019101.0A01-a,2.0C0001202J0000002511102,3.0C0001203J0000002511103,4.0C0001204J0000002511104,5.0C0001205J0000002511105,6.0C0001206J0000002511106,7.0C0001207J0000002511107,C0001208J0000002511108,C0001209J0000002511109,10.0C0001210J00000025111119101.0A01-a,11.0C0001211J0000002511112,12.0C0001212J0000002511113,13.0C0001213J0000002511114,14.0C0001214J0000002511115,15.0C0001215J0000002511116,16.0C0001216J0000002511117,17.0C0001217J0000002511118,18.0C0001218J0000002511119,19.0C0001219J0000002511120B0002995*200C01-b,20.0C0001220J0000002511122,21.0C0001221J0000002511123,22.0C0001222J0000002511124,23.0C0001223J0000002511125,24.0C0001224J0000002511126,25.0C0001225J0000002511127,26.0C0001226J0000002511128,27.0C0001227J0000002511129,28.0C0001228J0000002511130B0002995*200C01-b,29.0,30.0,31.0,32.0,33.0,序号品名编码型号规格类型放置库位前库存入库数量出库数量现库存备注,1.09101.0KPF-AA01-a,9102.0KPF-AA01-b,9103.0KPF-BA02-a,4.09104.0KPF-BA02-b,9105.0KPF-CA03-a,9106.0KPF-CA03-b,7.09107.0KPF-DA04-a,8.09108.0KPF-DA04-b,9.0合成树脂B0001KPF半成品C01-a,10.0合成树脂B0002KPF995*200半成品C01-b,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,年份月份查询明细,2019.08.0日期入库数量出库数量,43678.0,产品编码43679.0,9102.043680.03.0,43681.04.0,入库合计43682.05.0,43683.06.0,43684.07.0,出库合计43685.08.0,43686.09.0,43687.010.0,库存合计43688.011.0,5.043689.012.0,43690.013.0,43691.014.0,备注：输入编号、年份、月份数据自动汇总生成。43692.015.0,43693.016.0,43694.017.0,43695.018.0,43696.019.0,43697.020.0,43698.021.0,43699.022.0,43700.023.0,43701.024.0,43702.025.0,43703.026.0,43704.027.0,43705.028.0,43706.029.0,43707.030.0,43708.031.0,序号品名编码型号规格类型单位入库数量占比每月入库数量汇总,4.05.06.07.08.09.010.011.012.0,9101.0KPF-A,9102.0KPF-A,9103.0KPF-B,4.09104.0KPF-B,5.09105.0KPF-C,6.09106.0KPF-C,7.09107.0KPF-D,8.09108.0KPF-D,9.0合成树脂B0001KPF半成品,10.0合成树脂B0002KPF995*200半成品,11.0,12.0,13.0,14.0,15.0,序号品名编码型号规格类型单位出库数量占比每月出库数量汇总,4.05.06.07.08.09.010.011.012.0,9101.0KPF-A0.0714285714286,9102.0KPF-A,9103.0KPF-B,4.09104.0KPF-B,5.09105.0KPF-C,6.09106.0KPF-C,7.09107.0KPF-D,8.09108.0KPF-D,9.0合成树脂B0001KPF半成品,10.0合成树脂B0002KPF995*200半成品0.0714285714286,11.0,12.0,13.0,14.0,15.0,序号编码型号规格类型放置库位呆料天数>30原因分析解决对策责任人责任日期状态备注,9101.0KPF-AA01-a人员未按先进先出作业挪动库存异常物料优先出库吴文43758.0Close,2.09102.0KPF-AA01-b,3.09103.0KPF-BA02-a,4.09104.0KPF-BA02-b,5.09105.0KPF-CA03-a,6.09106.0KPF-CA03-b,7.09107.0KPF-DA04-a,8.09108.0KPF-DA04-b,9.0B0001KPF半成品C01-a,10.0B0002KPF995*200半成品C01-b人员未按先进先出作业挪动库存异常物料优先出库吴文43829.0On going未生产此规格产品,11.0,12.0,13.0,14.0,15.0