带销售指标考核销售管理系统表

日期凭证单号出入类别收入发出结存,单价成本单价均价,销 售 管 理 系 统,198.0,89.0,序号说明,1、【货品资料】【客户资料】【其他信息】中，录入相应资料,编码列一定不能为空,不要纯数字的编码,2、【销售录入】双击选择日期，单位编号，商品编号，制单人，金额自动计算，其他信息手录,3、【销售查询】录入日期，双击选择客户，品名，自动检索记录,4、【客户总览】点击查询按钮,选择起止日期,自动生成报表,5、【客户对账】点击查询按钮,选择客户和起止日期,自动生成对帐单,6、插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw,必看：此模板为宏模板，若下载不能启用宏。可下载插件启用。插件安装后，重新下载打开模板即可正常使用。插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw,序号商品编号商品名称规格单位进价售价备注,1.070251989.0333ML/瓶1.671.673.0,2.070251198.0513ML/瓶1.771.773.5,3.070254265.04.5L/瓶13.3813.3818.0,4.070242096.0百两茶3.625kg/支支258.06258.06450.0,5.070271031.0千两茶36.25kg/支支2580.62580.64500.0,6.070242104.0盛唐黑金薄片50片50片/盒215.05215.05499.0,7.070271033.0千年皇家薄片20片20片/盒299.0,8.070271032.0高山手筑茯砖1000g1000g/盒299.0,9.070272998.0黑茶饮310ml/罐罐3.653.656.0,10.0,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,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,序号客户编号客户名称联系地址联系电话联系人备注第一季度第二季度第三季度第四季度年度,1.0KH001客户113687387710.0联系人1,2.0KH002客户218858313279.0联系人2,3.0KH003客户313316962896.0联系人3,5.0KH004客户4娄底13819041569.0联系人4,4.0KH005客户5娄底18858313230.0联系人5,6.0KH006客户6谭株18858313210.0联系人6,7.0KH007客户7衡阳18627508708.0联系人7,8.0KH008客户8衡阳13638444731.0联系人8,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.00.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,序号制单人,1.0张三,2.0李四,3.0王五,4.0,5.0,6.0,7.0,8.0,9.0,10.0,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,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,日期单号单位编号往来单位商品编号名称规格单位数量单价应收金额实收金额未收金额备注制单人,43191.0KH001客户170251989.0矿泉水333ML/瓶瓶100.01.67167.0167.0张三,43191.0KH002客户270251198.0矿泉水513ML/瓶瓶100.01.77177.0177.0李四,开始日期43101.0截至日期43220.0,客户,产品编码名称,日期单号单位编号往来单位商品编号名称规格单位数量单价应收金额实收金额未收金额备注制单人,43191.0KH001客户170251989.0矿泉水333ML/瓶瓶100.01.67167.0167.0张三,43191.0KH002客户270251198.0矿泉水513ML/瓶瓶100.01.77177.0177.0李四,客户总览,2018/4/1~2018/4/30金额单位：元,序号编号客户名称上期应收余额本期应收本期已收方向期末余额备注,1.0KH001客户1167.0借167.0,2.0KH002客户2177.0借177.0,3.0KH003客户3,4.0KH004客户4,5.0KH005客户5,6.0KH006客户6,7.0KH007客户7,8.0KH008客户8,任务完成情况统计表,金额单位：元,序号编号客户名称年度任务量季度任务量年度完成量年度完成率%季度完成量季度完成率%季度剩余量年度剩余量,1.0KH001客户1167.00.000167999833.0,2.0KH002客户2177.00.000177999823.0,3.0KH003客户3,4.0KH004客户4,5.0KH005客户5,6.0KH006客户6,7.0KH007客户7,8.0KH008客户8,应收明细账,编码：KH001客户:客户12018/4/1~2018/4/30,月日单号编号品名规格单位数量单价应收金额已收金额余额备注,上期结转,4.01.070251989.0矿泉水333ML/瓶瓶100.01.67,4月本月合计0.0,4月本年累计0.0,