Newsagent Account Management System - System with Reports tor managing Customer Accounts

IN PROGRESS
Bids
7
Avg Bid (GBP)
£227
Project Budget (GBP)
£20 - £250

Project Description:
I am looking for a software which is both easy to use and accurate. The software will be used daily and the main aim of it will be to fully automate the calculations and the creating of Invoices for certain customers that the Newsagent (A local Shop which sells Newspaper/Magazines/other items) has.Currently the Newsagent must carry out all tasks using paper and therefore is susceptible to loss. Also all calculations are done manually, so there is a high possibility of miscalculation.The proposed software should fully automate the calculations and the creating of Invoices

This software will be used for creating Invoices for 2 types of Customers that a Newsagent (Local Shop)) deals with, these are Newspaper and Business Customers.

Newspaper Customers have an order of Newspapers or Magazines which is given to the Newsagent and the Newsagent delivers the Customers orders on the specified days. The Customer is then sent an invoice for the Newspapers/Magazines with a delivery charge added. The customer can also add misc items to their bill. The customers can book 'Holidays' where they do not want a delivery, this should be taken of the invoice. Also customers can provide vouchers which can be used to pay for titles and this effects the bill too. Also manufacture issues should be maintainable so that customers are charged correctly.

Business Customers are local businesses which hold an account with the Newsagent. These businesses can put items onto the account and the Newsagent will bill them for these. The business can pay in full amounts of part-pay their bill so a 'live' account balance should be shown.

Software should also be able to backup/restore data, Manage user accounts amongst other functions

Reports
There are about 15 reports required in total. Most are based on the Customer/Business details and their Invoices, there are also some to aid the Newsagent with daily/weekly tasks. Reports should be well laid out and have all the required information. Also paper usage must be kept to a minimum so printing multiple invoices to a page is ideal.The reports should have customisable fields which can be maintained from within the software.

Other Requirements / Information
Formatting
•Weeks run from Monday to Sunday,•Currency in pounds sterling,•Date formats in DD-MON-YYYY,•Time formats in HH24:MI:SS,•Language in English UK

Platform
•Offline system needed
•Software/database should be able to run smoothly on a Windows PC/Laptop without the specification being too high, good specification is provided
•No additional software needs to be purchased, use of free software only
•PC/Laptop will have Windows, Office 2007, IE Explorer (no internet connection)
•MySQL database is pre-installed on Test PC so this would be the ideal database platform, however other DBs are welcome
•Excel sheet with screens designed in VB attached. Optional to use.
•PC has TeamViewer installed and this is the preferred mode of data transfer

Conditions
•All bids must be carefully placed taking into consideration of all points.
•Time scales must be carefully considered and adhered to strictly. The Client can test pilot software builds and provide feedback usually within 3-4 days of installation
•All bids must be final and cannot be increased once the project is taken on. This can change if the Client requests a major change.
•When placing a bid, the user must detail how they will look to achieve the project goals clearly
•The winning bidder must provide a terms and conditions document after having their bid accept. This document must have details with regards to the support of the software, the ownership of the software code, rights etc once development is completed. This must be signed and dated, and sent to the client

I have attached a full specification document along with the reports designed in Excel (All Reports.xlsx). Also, I have attached the screen which are in the specification document in VB format (Screens.xlsm)

Good Luck!

Additional Project Description:
01/21/2013 at 23:13 ICT
The full specification document along with the reports designed in Excel (All Reports.xlsx) have been attached. Sorry to existing bidders if some points were not taken into account when your original bid was submitted. Please have a look at the attached and amend your bids if required.

Skills required:
C Programming, MySQL, PHP, Software Architecture, Visual Basic
Additional Files: Screens.xlsm Newsagent+Account+Management+System.pdf All+Reports.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 250
in 10 days
£ 250
in 35 days
Hire logixauto
£ 200
in 20 days
Hire Pharoa
£ 130
in 10 days
£ 325
in 33 days
£ 232
in 21 days
£ 200
in 10 days
£ 250
in 25 days