使用说明: 1,入库: 请填写详细。设计每款产品最多入库5次,如超过5次入库,则另行注明!“总入库数量”栏自动生成。 2,出货: 只需填写“生产单号”栏与出货“日期”和出货“数量”栏,其它栏为自动生成。 3,库存: 此表格不需要任何数据的输入,为自动生成表格。 此系统设计为4500项,请及时清除已出货且无库存之产品项目栏,释放存储空间!Designer:Frankie Date:2012-2-15入库记录出货明细库存查询入库明细货品描述下单日期生产单号客户名称货号产品描述规 格订单数量2/5/2012 SH1888-1AustralianMD111213001 21A-65550*70CM1,000,000 2/5/2012 SH1888-2AustralianMD111213002 428-3860*30*10CM500,000 2/8/2012 SH1889-1USAMD111213012 JE-5165*38*12CM300,000 2/8/2012 SH1889-2USAMD111213013 UP-6940*30*8CM800,000 MD号BOPP印 1C/1SBOPP印 5C/2SBOPP印 3C/1SBOPP印 6C/1S返回界面 入库明细表入 库 明 细装箱量第一次入库第二次入库第三次入库第四次入库第五次入库第五次入库日期日期日期日期日期日期1,500 2/15300,000 2/18500,000 2/24200,000 1,500 2/15200,000 2/18100,000 2/24200,000 1,500 2/15100,000 2/18100,000 2/24100,000 2,000 2/15300,000 2/18300,000 2/24200,000 个/箱数量/Pcs数量/Pcs数量/Pcs数量/Pcs数量/Pcs第五次入库总入库数量个 数箱 数1,000,000 666.7 500,000 333.3 300,000 200.0 800,000 400.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 数量/Pcs0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ...