The project is to manage Newspaper/Magazine invoicing for a local Independent Newsagents.
The software should have the ability to:
- Set up and maintain a Custom Delivery Route
- Automatically adds new starts into the Delivery Route
- Report to show the full delivery route with address and titles for a given day. Must follow the custom Delivery Route
- Customer can have multiple titles for any single day, report in above point should show this under one address
- Each Customer can have an up-to-date invoice produced at any time. Multiple invoice production at any time
- Invoicing takes intot account any promotional prices (maintain promotion start and end times)
- Maintain long-term price changes
- Maintain any holidays the customer has been on, hence not have any deliveries, invoicing should reflect this
- Invoice must show details such as daily cost breakdown, deductions (holidays), delivery charges, Total. Custom Filters required
- Manage Newspaper titles, publication frequencies and pricing
- Manage Magazine titles, publication frequencies and pricing
- Records every change made to the information contained in the customer accounts
- Manages any coupons the customer has provided. Coupon expiry dates, values,
- Possible built-in Backup Procedure
- Maintainable days where there are titles not published
- Possible Web-accessable customer accounts
- Maintain delivery charges
I have tried this in MS Excel and MS Access but I cannot get over some hurdles for example if there are multiple titles for a Customer for a any single day. Or having to link the titles to the invoice as the titles can vary their prices for each day. Also, I am not sure how Magazines (being daily, weekly, etc.) can be factored into the billing process. I have attached both of these so that an idea of what I am trying can be seen.
Many Thanks, good luck!
11 freelancers are bidding on average £279 for this job
As per your requirement...we are very much interested for your project. We can complete your project quickly and efficiently in time. Details will be discussed in the message.
sir, I am a [url removed, login to view] graduate in computer science i have more then six month experience in data base design .i can surely complete this project in within time limit.