零售管理系统（会员&进销）表

零售管理系统,密码:123,会员查询,查询编号:123458,登记时间:43713.0,会员名称:text3,联系电话:12345678910,联系地址:lalal,总消费:63.0,总充值:300.0,卡内余额:237.0,卡内积分:43.0,物品查询,查询编号:123460.0,大类:学习用品,名称:text5,型号:text5,单位:个,零售价:10.8,库存:26.0,总销售额:36.0,总采购价:150.0,目前利润:-114.0,销售界面,销售编号:20190905103616汇总:63.0,销售日期:顾客类型:会员编号:123458,会员卡余额:237.0会员卡积分:43.0,物品编号大类名称型号单位单价数量总价备注,123457.0水果1.03.03.0,123459.0生活用品text4text410.020.0注意:表格不要修改格式,不要修改单元格的名称,123458.0零食text3text38.05.040.0,123456123457.0水果1.0,20190905092305蔬菜,123456123456.0蔬菜10.020.0,会员编号登记日期会员名称联系地址充值日期充值金额备注,12345643684.0text1,123457text2,123462text7,123464text9,123467text12,123465text10,123465text10,123467text12,会员编号登记日期会员名称联系电话联系地址总充值会员卡余额总消费总积分消费积分积分余额备注,12345643684.0text137.0,123457text2,123458text3300.0237.020.043.0,123459text4,123460text5,123461text6,123462text7,123463text8,123464text9,123465text10,123466text11,123467text12,会员编号会员名称兑换日期兑换物品最新积分余额消费积分,123458text343713.0卫生纸43.010.0,123458text343713.0卫生纸43.010.0,物品编号大类名称型号单位参考进价建议零售价采购数量销售数量库存数量备注,123456.0text1text110.014.0,123457.0text2text21.01.214.0,123458.0text3text38.09.6250.0238.0,123459.0text4text410.060.048.0,123460.0text5text59.010.84.026.0,123461.0text6text69.711.64,123462.0text7text710.412.48,123463.0text8text811.113.32,123464.0text9text911.814.16,123465.0text10text1012.515.0,123466.0text11text1113.215.84,123467.0text12text1213.916.68,123468.0text13text1314.617.52,123469.0text14text1415.318.36,123470.0text15text1519.2,123471.0text16text1616.720.04,123472.0text17text1717.420.88,123473.0text18text1818.121.72,123474.0text19text1918.822.56,123475.0text20text2019.523.4,123476.0text21text2120.224.24,123477.0text22text2220.925.08,123478.0text23text2321.625.92,123479.0text24text2422.326.76,123480.0text25text2523.027.6,123481.0text26text2623.728.44,123482.0text27text2724.429.28,123483.0text28text2825.130.12,采购编号采购日期物品编号大类名称型号单位实际进价数量总价备注,蔬菜text1text110.0300.0,123457.0水果text2text2,15.0300.0,43714.0,43715.0,43716.0123460.0学习用品text5text5,43717.0123459.0生活用品,43718.0123459.0生活用品,销售编号销售日期顾客类型会员编号物品编号大类名称型号单位单价数量总价备注,123460.0学习用品9.018.0,123460.0学习用品9.018.0,5.040.0,5.040.0,使用说明:,1.首先需要维护的是物品清单,物品清单中的参考进价是取最近值,由于每次采购价不相同,2.蓝色打底部分,是公式计算,不要修改公式,扩展公式,只需要下拉即可,3.编号设置有下拉列表,编号不能重复,重复系统会填充提醒,4.根据销售界面可以自动形成销售记录,销售记录中的数据不要更改,1.本系统包括了销售管理,采购管理以及会员管理,2.会员模式是可以积分,可以充值,3.积分可以兑换物品,4.积分规则是没一块积分1分