仓库先进先出管理表

,方案：,说明：在货架两侧分别装上滑轮（滑轮间隔距离根据栈板设定，不可间隔太远防止受力不均导致栈板前倾卡在滑轮之间），滑换轮用履带串联，在下料端装上动力装置。货架装置层数根据场地而定。,目的：先入库先发出，防止产品防止时间过长受温度、湿度影响发生变异，导致损失。,使用对象：需保质产品,使用方法：货架需设置自动传送功能，商品型号、编码可根据实际设置，查询时根据实际编码、品名、型号 查询。,序号入库单号日期品名编号型号规格单位数量库位经办人备注,1.043617.0,2.043617.0,3.043618.0,4.043620.0,5.043621.0,6.043622.0,7.043623.091007.0A107,8.043624.091008.0A108,9.043625.091009.0A109,10.043626.091010.0A110,11.043627.0,12.043628.0,13.043629.0,14.043630.0,15.043631.0,16.043632.0,17.043633.091007.0A107,18.043634.091008.0A108,19.043635.091009.0A109,20.043636.091010.0A110,21.043637.0,22.043638.0,23.0,24.0,25.0,26.0,序号品名编号型号规格单位入库数量库位备注,1.091001.0KPF-SA101,2.091002.0KPF-SA102,3.091003.0KPF-AA103,4.091004.0KPF-AA104,5.091005.0KPF-HA105,6.091006.0KPF-HA106,7.091007.0KPEA107,8.091008.0KPEA108,9.091009.0FpfA109,10.091010.0FpfA110,11.00.042,12.0,13.0,14.0,序号出库单号日期品名编号型号规格单位数量出货客户经办人备注,1.043626.0,2.043627.0,3.043628.0,4.043629.0,5.043630.0,6.043631.0,7.043632.091007.0,8.043633.0,9.043634.0,10.043635.091010.0,11.043636.0,12.043637.0,13.043638.0,14.043639.0,15.043640.0,16.043641.0,17.043642.0,18.043643.0,19.043644.0,20.043645.0,21.043646.0,22.043647.0,23.043648.0,24.043649.0,25.043650.091007.0,26.043651.0,27.043652.0,28.043653.091010.0,29.043654.0,30.043655.0,31.043656.0,32.043657.0,33.043658.0,34.043659.0,35.043660.0,36.043661.0,序号品名编号型号规格单位出库数量备注,1.091001.0KPF-S,2.091002.0KPF-S,3.091003.0KPF-A,4.091004.0KPF-A,5.091005.0KPF-H,6.091006.0KPF-H,7.091007.0KPE200.0,8.091008.0KPE,9.091009.0Fpf,10.091010.0Fpf200.0,序号品名编号型号规格单位原库存入库数量出库数量现库存库位备注,1.091001.0KPF-SA101,2.091002.0KPF-SA102,3.091003.0KPF-AA103,4.091004.0KPF-AA104,5.091005.0KPF-HA105,6.091006.0KPF-HA106,7.091007.0KPE200.0A107,8.091008.0KPEA108,9.091009.0FpfA109,10.091010.0Fpf200.0A110,11.042,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,型号出入库明细1.0,KPF-S日期入库数量出库数量2.0,43647.03.0,选择年份43648.04.0,2019.043649.05.0,43650.06.0,选择月份43651.07.0,7.043652.08.0,43653.09.0,入库数43654.0100.010.0,43655.0100.011.0,43656.012.0,出库数43657.013.0,200.043658.014.0,43659.015.0,库存43660.016.0,600.043661.017.0,43662.018.0,备注：需手动选择型号、年、月份，后知道显示当月进出明细，自动汇总。43663.019.0,43664.020.0,43665.021.0,43666.022.0,43667.023.0,43668.024.0,43669.025.0,43670.026.0,43671.027.0,43672.028.0,43673.029.0,43674.030.0,43675.031.0,43676.0,43677.0