Sales Rep Tool - WebPage (maybe app)
$250-750 AUD
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.
Project ID: #8888788
About the project
11 freelancers are bidding on average $586 for this job
***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
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
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!
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
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