仓库快捷管理表

,序号品名编码型号规格类型放置库位可放置数量备注,1.09101.0KPF-AA01-a,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-b,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,备注：扫码枪扫码自动上传数据,序号月份日期二维码品名编码型号规格类型单位入库数量库位待料天数呆料天数,J0000002511101,2.0J0000002511102,3.0J0000002511103,4.0J0000002511104,5.0J0000002511105,6.0J0000002511106,7.0J0000002511107,J0000002511108,J0000002511109,10.0J0000002511110142.0,11.0J0000002511111,12.0J0000002511112,13.0J0000002511113,14.0J0000002511114,15.0J0000002511115,16.0J0000002511116,17.0J0000002511117,18.0J0000002511118,19.0J0000002511119,20.0J0000002511120,21.043682.0J0000002511121138.0,22.0J0000002511122,23.0J0000002511123,24.0J0000002511124,25.0J0000002511125,26.0J0000002511126,27.0J0000002511127,28.0J0000002511128,29.0J0000002511129,30.0J0000002511130,31.0,32.0,33.0,34.0,35.0,备注：扫码枪扫码自动上传数据,序号月份二维码日期品名编码型号规格类型单位出库数量库位备注,J00000025111019101.0A01-a,2.0J0000002511102,3.0J0000002511103,4.0J0000002511104,5.0J0000002511105,6.0J0000002511106,7.0J0000002511107,J0000002511108,J0000002511109,10.0J00000025111119101.0A01-a,11.0J0000002511112,12.0J0000002511113,13.0J0000002511114,14.0J0000002511115,15.0J0000002511116,16.0J0000002511117,17.0J0000002511118,18.0J0000002511119,19.0J0000002511120B0002995*200C01-b,20.0J0000002511122,21.0J0000002511123,22.0J0000002511124,23.0J0000002511125,24.0J0000002511126,25.0J0000002511127,26.0J0000002511128,27.0J0000002511129,28.0J0000002511130B0002995*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,产品编号查询明细,9101.0日期入库数量出库数量,43678.0,年份43679.02.0,2019.043680.03.0,43681.04.0,月份43682.05.0,8.043683.06.0,43684.07.0,入库合计43685.08.0,3.043686.09.0,43687.010.0,出库合计43688.011.0,2.043689.012.0,43690.013.0,库存43691.014.0,6.043692.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,序号编码型号规格类型放置库位呆料天数>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