销售订单管理系统-会员管理

使用说明1订单明细表：颜色区域设有 公式 小学单位换算公式大全免费下载公式下载行测公式大全下载excel公式下载逻辑回归公式下载 ，自动显示，其它手动输入2订单查询：输入起始日期和客户名称，其它自动显示3发货记录表：颜色区域设有公式，自动显示，其它手动输入4送货单查询：输入起始日期和客户名称，其它自动显示5送货单打印：已设打印格式6产品信息表：手动输入产品信息7收款记录表：颜色区域设有公式，自动显示，其它手动输入8客户信息表：颜色区域设有公式，自动显示，自动统计应收账款9客户跟进表：颜色区域设有公式，自动显示，其它手动输入10客户跟踪查询：输入客户名称，颜色区域设有公式，自动显示，其它手动输入会员订单明细辅助列序号订单号下单日期交货日期产品编码产品名称规格型号单位数量单价金额付款方式会员名称业务员是否发货备注3-12019092019/20/199/25/19A0001冰箱规格1件10299929990刷卡公司1张1已发货22019092029/21/199/26/19A0002洗衣机规格2件512996495微信公司2张2已发货32019092039/22/199/27/19A0003豆浆机规格3件85994792现金公司3张3已发货42019092049/23/199/28/19A0004榨汁机规格4件203997980刷卡公司4张4未发货52019092059/24/199/29/19A0005空调规格5件324997497微信公司5张5未发货0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000发货记录表辅助列订单号订单日期送货日期送货单号发货人产品编码产品名称规格型号单位数量单价金额会员联系电话收货地址备注3-2019092019/20/199/25/19S001李1A0001冰箱规格1件10299929990公司12019092029/21/199/26/19S002李2A0002洗衣机规格2件512996495公司22019092039/22/199/27/19S003李3A0003豆浆机规格3件85994792公司30000000000000000000000000

00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000订单查询表开始日期9/20/19结束日期9/30/19会员名称公司1辅助列订单号下单日期交货日期产品编码产品名称规格单位数量单价金额业务员是否发货备注3-2019092012019/9/202019/9/25A0001冰箱规格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!#VA

LUE!#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辅助列订单号下单日期送货日期送货单号产品编码产品名称规格单位数量单价金额备注3-2019092012019/9/202019/9/25S001A0001冰箱规格1件10299929990#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!#VA

LUE!#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.0201909201公司129990李1转账10000农行张三43733.0201909202公司26495李2转账3000农行张三43734.0201909203公司34792李3转账4792农行张三000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000客户信息表编号区域公司名称客户级别老板及联系人电话邮箱详细

地址累计交易额已收款未收款1锦江区公司1一级客户张1134****9999锦江区2999010000199902武侯区公司2一级客户张2134****1000武侯区6495300034953成华区公司3二级客户张3134****1001成华区4792479204成华区公司4二级客户张4134****1002成华区7980079805成华区公司5二级客户张5134****1003成华区7497074976000700080009000100001100012000130001400015000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000客户跟进记录表辅助列跟进日期客户名称电话地址跟进人跟进方式跟进结果备注32019/9/27公司1134****9999锦江区张三电话良好2019/9/28公司2134****1000武侯区张三电话良好2019/9/29公司3134****1001成华区张三电话良好2019/9/30公司4134****1002成华区张三电话良好客户查询表客户名称公司1联系电话134****9999客户及级别一级客户邮箱0联系人张1详细地址锦江区累计交易额29990已收款10000未收款19990备注辅助列跟进日期跟进人跟进方式跟进结果备注32019/9/27张三电话良好00000000000000000000000000000000000000000000000000000000000