客户管理系统

使用说明1订单明细表：颜色区域设有公式，自动显示，其它手动输入2订单查询：输入起始日期和客户名称，其它自动显示3发货 记录 混凝土 养护记录下载土方回填监理旁站记录免费下载集备记录下载集备记录下载集备记录下载 表：颜色区域设有公式，自动显示，其它手动输入4送货单查询：输入起始日期和客户名称，其它自动显示5送货单打印：已设打印格式6产品信息表：手动输入产品信息7收款 记录表 体温记录表下载消防控制室值班记录表下载体温记录表 下载幼儿园关于防溺水的家访记录表绝缘阻值测试记录表下载 ：颜色区域设有公式，自动显示，其它手动输入8客户信息表：颜色区域设有公式，自动显示，自动统计应收账款9客户跟进表：颜色区域设有公式，自动显示，其它手动输入10客户跟踪查询：输入客户名称，颜色区域设有公式，自动显示，其它手动输入客户订单明细辅助列序号订单号下单日期交货日期产品编码产品名称规格型号单位数量单价金额付款方式客户名称业务员是否发货备注3-12020040114/1/204/10/20A0001冰箱规格1件10299929990刷卡公司1张1未发货22020040124/2/204/11/20A0002洗衣机规格2件512996495微信公司2张2未发货32020040134/3/204/12/20A0003豆浆机规格3件85994792现金公司3张3未发货42020040144/4/204/13/20A0004榨汁机规格4件203997980刷卡公司4张4未发货52020040154/5/204/14/20A0005空调规格5件324997497微信公司5张5未发货00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000发货记录表辅助列订单号订单日期送货日期送货单号发货人产品编码产品名称规格型号单位数量单价金额客户联系电话收货地址备注20200410014/1/204/9/20S001李1A0001冰箱规格1件1029992999020200410024/2/204/10/20S002李2A0002洗衣机规格2件51299649520200410034/3/204/11/20S003李3A0003豆浆机规格3件859947920000000000000000000000000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000订单查询表开始日期4/1/20结束日期4/10/20客户名称公司1辅助列订单号下单日期交货日期产品编码产品名称规格单位数量单价金额业务员是否发货备注3-2020040112020/4/12020/4/10A0001冰箱规格1件10299929990张1未发货#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#

VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!送货单查询表开始日期9/20/19结束日期9/30/19客户名称公司1辅助列订单号下单日期送货日期送货单号产品编码产品名称规格单位数量单价金额备注#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!

#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!送货单制成日：9/20/19PAGE:1/1供方送货号S001需方送货号公司名姓名公司名姓名地址电话地址电话业务种类项目业务种类项目0No.品名规格单位数量金额备注12345678910111213TOTAL0摘要订单号：xxxxx送货人收货人参数表产品编码产品名称规格型号单位备注信息A0001冰箱规格1件A0002洗衣机规格2件A0003豆浆机规格3件A0004榨汁机规格4件A0005空调规格5件收款明细日期订单号客户名称订单总额付款人付款方式收款金额收款账户经办人备注43732.02019092010李1转账10000农行张三43733.02019092020李2转账3000农行张三43734.02019092030李3转账4792农行张三000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000客户信息表编号区域公司名称客户级别老板及联系人电话邮箱详细地址累计交易额已收款未收款1锦江区公司1一级客户张1134****9999锦江区299900299902武侯区公司2一级客户张2134****1000武侯区6495064953成华区公司3二级客户张3134****1001成华区4792047924成华区公司4二级客户张4134****1002成华区798007

9805成华区公司5二级客户张5134****1003成华区7497074976000700080009000100001100012000130001400015000160001700018000190002000021000220002300024000250002600027000280002900030000310003200033000340003500036000370003800039000400004100042000430004400045000460004700048000490005000051000520005300054000550005600057000580005900060000610006200063000640006500066000670006800069000700007100072000730007400075000760007700078000790008000081000820008300084000850008600087000880008900090000910009200093000940009500096000970009800099000100000101000102000103000104000105000106000客户跟进记录表辅助列跟进日期客户名称电话地址跟进人跟进方式跟进结果备注32020/4/5公司1134****9999锦江区张三电话良好2020/4/6公司2134****1000武侯区张三电话良好2020/4/7公司3134****1001成华区张三电话良好2020/4/8公司4134****1002成华区张三电话良好客户查询表客户名称公司1联系电话134****9999客户及级别一级客户邮箱0联系人张1详细地址锦江区累计交易额29990已收款0未收款29990备注辅助列跟进日期跟进人跟进方式跟进结果备注32020/4/5张三电话良好00000000000000000000000000000000000000000000000000000000000