Sales Budget Reporting

Development of a “Sales to budget” report and a weekly “Sales to budget Flash” report for our company web portal.

Please reference this list of Data tables to read data from:

 General Ledger Actual Summarization Table

o On a nightly basis general ledger actual data for the days sales will be compiled in to summary totals.

 General Ledger Budget Table

o This table will contain sales budgets to be matched to actual

 Countries Table

o Lists all countries our company currently does business in.

 Regions Table

o Containing the company’s sales regions

 Territories Table

o Containing our company’s sales territories

 Sales Representatives Table

o Containing the company’s sales representatives

 Region’s Territories Link Table

o Linking Territories to a Region

 Region’s Sales Representatives Link Table

o Linking Regions to a Sales Representative as Regional Manager of the assigned regions

 Territory’s Sales Representatives Link Table

o Linking Territories to a Sales Representative as Territory Manager of the assigned territories

 Manager’s Sales Representatives Link Table

o Linking Regional Manager to a Sales Representative as District Manager of the assigned Regional Managers

Developed reports must adhere to restrictions compiled by our company’s CIO.

When sales representative accesses the company web portal

Territory Managers are only allowed to see their sales data.

Regional Managers are only allowed to see their Territory Managers sales data

District Managers are only allowed to see their Regional Managers sales data

Upper Management and Administrators are allowed to see all sales data

Note: Administrators, Upper Management, District and Regional Managers will be given the

option to see a Detailed or Summary result.

Summarized results can be selected to show totaling up to the requester’s title.

Before bidding on this job, consultant must possess the following skills:

Database Knowledge (MySQL and/or MSSQL),

PHP 5 or better, JavaScript,

Familiarity of Ajax and PHP Frameworks

(Yii would be an example of a PHP Framework and/or If you know the internal working of Morfik

then you would have a good understanding of a PHP Framework)

If you meet the above requirements please submit your bid in order to be considered for the job. Candidates will be considered anonymously via email. Once bid is accepted, consultant will be contacted and engaged for above job. Please do not respond if you do not possess the above-mentioned skills or plan to engage other resource to conduct job.

Habilidades: Design Gráfico, HTML, PHP, Design de Sites

Veja mais: budget sales reporting, sales budget, yii - design, yii design, web development consultant, territory sales manager, territory manager, sales representative job, sales representative company, sales management sales representative regional sales manager, sales management consultant, sales job title, sales job requirements, sales consultant job, regional sales representative, regional sales manager, regional sales consultant job, regional manager, list of ajax frameworks, job of a general manager, javascript ajax frameworks, graphic design manager job, graphic design job candidates, general manager job, frameworks ajax

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #5118190

23 freelancers estão ofertando em média $1658 para esse trabalho


Kindly ignore the bid amount & time-line, as we still need to analyze your requirements more in depth & discuss with you. -------- Dear Sir, I have read your Project Description and understand the initial concept, Mais

$1546 USD in 45 dias
(46 Comentários)

Dear Sir, We have build many complex websites using PHP and MySQL earlier. Waiting for reply, Manpreet Singh

$2000 USD in 30 dias
(224 Comentários)

Hi there, Thanks for posting the project. Let me first introducing ourselves, We are ISO 9001:2008 & BBB accredited WEBSITE & APPS Design - Development Company with 10+ YEARS of field experience. I have initially revie Mais

$1480 USD in 30 dias
(139 Comentários)

**********************.. YOUR SEARCH ENDS HERE .. ********************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and getting started. I've been working in simple and Mais

$1649 USD in 10 dias
(128 Comentários)

1. Invoicing App We already designed and developed a complete online invoicing application in which currently we are handling these modules 1. Place New Order (phone order page from sample) 2. Pending Orders 3. Shi Mais

$1427 USD in 22 dias
(82 Comentários)

Hi, We have read your requirements and would like to discuss things further. We have 5 PHP experts in our company and have strong hands in Core PHP, Yii and other frameworks and have completed over 80 medium sized Mais

$1546 USD in 20 dias
(51 Comentários)

Hi, I have gone through your project description and could assure you the best of the solution. I am taking it as an opportunity and ready to deliver my best. we have done several complex business software like Mais

$1500 USD in 45 dias
(147 Comentários)

Hello We went through project description a very well .Please provide more details about the project .We are professional website design and development company operating in UK and India. We have 8 years of experienc Mais

$2577 USD in 38 dias
(101 Comentários)

Let's discuss in detail for the proper estimation of cost and time. see my recent work for the technical expertise along with reviews & feedback on my profile page. let's discuss and get started.

$1546 USD in 15 dias
(63 Comentários)

Hello Sir, I am from Confianza Technologies. I have gone through your requirements. We have developers who have vast experience in required technologies. We are interested in your project, but before finalizing budget Mais

$1546 USD in 25 dias
(40 Comentários)

Hi, I have understood your requirement I have good experience in handling HTML5/PHP/Java/J2EE/iOS and Android apps/Drupal/Ruby & Ruby on Rails/Javascript/MySQL/ I can handle this task for sure.I Hope we can wo Mais

$4639 USD in 50 dias
(48 Comentários)

Hello, We have gone through your requirement and are confident that we can successfully execute the project within the timeline. We are an established Web Design and Development Company having a defined and qualitat Mais

$1546 USD in 35 dias
(45 Comentários)

Dear Valuable Client, If you look at my ratings, you can see that I can complete medium to large projects successfully with great satisfaction. I specialize in advance scripting and can do even the most complex of pro Mais

$1546 USD in 30 dias
(5 Comentários)

Hi there, I have analysed your project description, needs and requirements and will incorporate every feature that you require. I am confident about delivering the exact solutions that you are looking for. Technical Mais

$1473 USD in 30 dias
(44 Comentários)

Hello Sir, We are an Indian based company, we are having experts to handle this project and can finish in desired time frame,so it will be great if we can discuss more about the work We can also Send our portfolio o Mais

$1394 USD in 45 dias
(22 Comentários)

Hello Hiring manager, Greetings from Evidcomm!!! We have gone through your requirements and would be pleased to work on. We have already done this kind of work in past and surely we will get finished this project Mais

$1000 USD in 25 dias
(31 Comentários)

Hello, Thanks, for giving us a chance to bid on your project. Please check private message box for more details. We are WebGloabalIt is an (ISO 9001:2008) (ISO 27001:2005) certified company which have throught Mais

$1159 USD in 22 dias
(18 Comentários)

Hello We are well reputed IT company in India and we are working legally under the reorganization of Indian [login to view URL] are having more than 500+ satisfied client all over the globe we are mainly focus on ASP.N Mais

$2000 USD in 30 dias
(3 Comentários)

PHP expert... check pm pls! PHP expert... check pm pls! PHP expert... check pm pls! PHP expert... check pm pls!

$1250 USD in 3 dias
(75 Comentários)

Hello, Thank you for reading our project proposal, i had assumed the project scope and here i am briefing the full scope with work and the time line- ------MY WORK PORTFOLIO---- Microsoft Vb.net, Asp.net, C# Mais

$2000 USD in 35 dias
(2 Comentários)