excel做的进销存-仓库管理表格-功能强大

销售录入销售数据入库录入入库数据库存查询销售查询主界面货品资料成本价信息进出存主界面条形码货号货品名称大类小类单位吊牌价010101123456洗面奶洗漱用品护肤瓶¥50.00020202321321洗发水洗漱用品洗发瓶¥30.00030303111222奇强洗衣粉洗涤用品洗衣粉袋¥13.80040404333111口红化妆用品口红支¥29.00050505121212红旗渠烟酒用品香烟盒¥5.00060606212121黄金叶烟酒用品香烟盒¥5.00070707323232中南海烟酒用品香烟盒¥4.50080808626262红塔山烟酒用品香烟盒¥7.00090909565656红梅烟酒用品香烟盒¥5.001010天天烟酒用品香烟盒¥8.00日期：条形码输入单号：货号输入输入方式:条形码输入日期单号条形码货号货品名称单位吊牌价售价数量生意额吊牌金额合计:0002011/4/41000004销售单提交输入方式：货号日期单号条形码货号货品名称单位吊牌价售价数量生意额吊牌金额合计:000提交销售日期单号条形码货号货品名称单位吊牌价售价2011/03/011000000010101123456洗面奶瓶50502011/03/101000000010101123456洗面奶瓶50502011/03/151000000020202321321洗发水瓶30302011/03/201000000020202321321洗发水瓶30302011/03/251000001010101123456洗面奶瓶50502011/04/011000002010101123456洗面奶瓶50502011/04/021000003020202321321洗发水瓶3030数量生意额吊牌金额8300400104005003909026060838040052202508240240下个单号1000004日期：单号：日期单号供货商货号货品名称单位吊牌价进货价数量合计:02011/4/42000013入库单吊牌金额进货金额00入库单提交入库日期单号供货商货号货品名称单位吊牌价进货价2011/04/032000000123456洗面奶瓶50302011/04/032000001321321洗发水瓶30182011/04/032000002123456洗面奶瓶50252011/04/032000003123456洗面奶瓶50282011/04/032000004321321洗发水瓶30122011/04/032000005123456洗面奶瓶50262011/04/032000006111222奇强洗衣粉袋13.89.82011/04/032000006333111口红支2913.62011/04/032000007121212红旗渠盒54.82011/04/032000008212121黄金叶盒54.52011/04/032000009323232中南海盒4.53.82011/04/032000010323232中南海盒4.53.82011/04/032000011123456洗面奶瓶50302011/04/042000012123456洗面奶瓶5035数量吊牌金额进货金额1050030010300180201000500105002801030012010500260100138098050145068050250240100500450502251902090765025001500201000700下个单号2000013数据货号货品名称求和项:数量求和项:进货金额123456洗面奶1203540321321洗发水20300111222奇强洗衣粉100980333111口红50680121212红旗渠50240212121黄金叶100450323232中南海70266总计5106456数据货号货品名称单位吊牌价进货数量进货吊牌金额进货成本金额123456洗面奶瓶5012060003540321321洗发水瓶3020600300111222奇强洗衣粉袋13.81001380980333111口红支29501450680121212红旗渠盒550250240212121黄金叶盒5100500450323232中南海盒4.570315266总计510104956456销售库存销售数量销售吊牌金额销售生意额销售成本金额库存数量311550130018600089133903907800700001000000500000500000100000070库存吊牌金额库存成本金额445053400021042001380138000145072500250125005005000031522050库存数据查询条件入库日期单号条形码货号货品名称单位日期范围查询开始日期结束日期入库日期入库日期数据显示区域==入库日期单号条形码货号货品名称单位吊牌价进货价数量吊牌金额进货金额吊牌价进货价数量吊牌金额进货金额0000销售数据查询条件日期单号条形码货号货品名称单位日期范围查询开始日期结束日期销售日期销售日期数据显示区域==日期单号条形码货号货品名称单位吊牌价售价数量生意额吊牌金额吊牌价售价数量生意额吊牌金额000