Find Jobs
Hire Freelancers

Generate a list of unspent customer -- 2

$30-70 USD

已关闭
已发布超过 3 年前

$30-70 USD

货到付款
Step Description: 1. Get all the data of CustomerTEST.customer_code first, and name it as list of all customer. 2. input the information into interval od date & register in SalesLedgerTEST, and filter out the list of customers who have consumption. 3. Use “list of all customer” to remove the list of customers who have consumption. Then get the list of customer who have not consumption. 4. Total amount of Consumption during interval of date in other register: Use total amount of consumption in interval of date which we input minus total amount of consumption in register which we select (get the SalesLedgerTEST.LineType==”Sale” of [login to view URL] as total amount of consumption)
项目 ID: 28322886

关于此项目

5提案
远程项目
活跃3 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
5威客以平均价$59 USD来参与此工作竞价
用户头像
I am the professional PHP and MYSQL developer with lots of experiences. Reading your job description, I felt that I am an enough qualified candidate to take this job on. Please contact me to get the smart result you want. Regards.
$100 USD 在1天之内
5.0 (5条评论)
3.8
3.8
用户头像
Hello There , I have 4.5 years of experience in PHP. I gone through the definition and the sql and doc attached here .I have done such works many times . I can share my experience in chat .I can start now and can complete this task as your requirement . Would like to do this project. Looking forward for your revert. Thank you Shrushti P.
$55 USD 在2天之内
5.0 (11条评论)
3.1
3.1
用户头像
Hi, I have 9 years of experience on php and MySQL. I gone through your job details and I am confident to complete your job successfully. So, kindly initiate a chat for the further discussion. I am ready to start work immediatly. Thanks, Nitin M.
$40 USD 在1天之内
5.0 (5条评论)
3.0
3.0
用户头像
Hello Pal, What I understand from you project description you want to fetch data from database with specific data range with different register type. You have three different type of register in you db table. I can start this project right now and finish it ASAP. thanks
$70 USD 在1天之内
5.0 (11条评论)
2.7
2.7

关于客户

TAIWAN的国旗
Taipei City, Taiwan
5.0
18
付款方式已验证
会员自6月 5, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。