Sales Rep Tool - WebPage (maybe app)

Closed Posted Nov 12, 2015 Paid on delivery
Closed Paid on delivery

Sales Rep Tool

(Please do not respond until you have understood the details and reviewed the tables attached.)

(This app is to be designed for use with Sage Evolution Data (SQL Server) remotely access, all resources for this will be provided)

Preferably in .Net

We require the ability to easily view product sales for a specific customer/delivery address on a pc, tablet or mobile device.

This will need to be a developed web page linked to live Sage Evolution data. (SQL Server, remotely accessed, we will provide a database to use for this project) The address of these source database needs to be changeable no hard coding. We need to install multiple instances of this app/site and therefore connect to a different database per site.

A web page for tablets/PC/mobile needs to show the following information:

An initial security login will allow access to the information.

Initial Selection:

Customer Code = Held Against Order Header Table (join to Customer Table by id)

Sales Person = Held against an Order Header Table (join to a Sales Person Table by id)

(Can be left blank to allow ALL)

Delivery Address WildCard to filter the orders selected = (searches 6 fields in Order Header Address1, Address2,……)

Date Range = From/To, defaulting to from 1dst of six months ago, to today.

Read the Order header table based on the detail above and assess qty sold of products whilst interrogating the order details table.

The screen will show:

Customer Name

Delivery Address wildcard

Product Code / Product Description / Sales Qty (as a table)

BV1234 Widget Description 250

HH5444 Another Description 254

JT5EE4 And Another hhh 4102

The quantity is made up of Processed Sales Order Invoices less processed Credits within the given date range. Details will be provided of the criteria required to extract the records being sought.

The user will have the ability to click on one of the product lines and drill down on a product to show the Document No, Date and Quantity table.

e.g.

INV003456 01/04/2015 25

INV003603 10/04/2015 30

CR004521 11/04/2015 10

The user will then be able to click and select the document line above and see what was actually sold on it. i.e. What other purchases were made at the time.

Order Header Details

Followed By a table of all line items on the order. (not just the product being looked at)

The user will then have the ability to select another Customer/Delivery Address or to logout.

Data tables are included in the attached document.

SlideRule are looking for a partner to develop many applications, so a good job will stand you in good stead.

.NET PHP Software Architecture

Project ID: #8888788

About the project

11 proposals Remote project Active Dec 19, 2015

11 freelancers are bidding on average $586 for this job

techwizzard2012

***WE HAVE DEVELOPED SEVERAL SIMILAR SOFTWARE, PLEASE ASK FOR DEMO*** Hello, Hope you are doing great. I am Srinibash Saha, Business Development Associate, Techwizzard2012. About Us: We are a Genuine Website, Mo More

$666 AUD in 21 days
(34 Reviews)
5.0
mcdperera

Hi Employer, I have 7 + years of experience of doing several domain related software such as school/university Management, eLearning system , restaurant based management /POS / ordering systems also ecommerce based s More

$555 AUD in 10 days
(4 Reviews)
3.4
AwaisChaudhry

A proposal has not yet been provided

$618 AUD in 10 days
(2 Reviews)
3.0
keystrickers

A proposal has not yet been provided

$515 AUD in 10 days
(2 Reviews)
2.7
dineshmore

Hi Myself expert in asp.net webforms, asp.net mvc5, c# and sql server with 10 yrs of experience in software development. Developed various applications for finacne, insurance, education and research domains. Wil More

$250 AUD in 20 days
(3 Reviews)
2.2
joses7

Dear You, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Thanks!

$526 AUD in 10 days
(1 Review)
1.9
shankarjay785App

Service Description We provides IT services in the following areas: - - Mobile Programming * iOS 7 and 8 application * SWIFT programming * Xamarin ( MVVMCross for multi-platform) * iPhone / iPad * Android and N More

$944 AUD in 35 days
(0 Reviews)
0.0
SmolkoMatic

Dear sir, I would be a right choice for your project since a have extensive knowledge of .NET programming (c#) and MS SQL databases. I have a lot of experience in many larger projects than this one and I can provid More

$722 AUD in 8 days
(0 Reviews)
0.0
erubelee

A proposal has not yet been provided

$555 AUD in 10 days
(0 Reviews)
0.0