Quote layawy
- Status: Closed
- Prize: $350
- Entries Received: 2
- Winner: tandonshailendra
Contest Brief
Using the included Access DB, create entry screens, table and reports for to track quotes, customers, layaways, and payments. Entry screens must look like a standalone program and not part of Access.
Multiple quotes per customer,
be able to convert any quote to a layaway.
Layaways to be calculated as by week, bi-weekly or monthly. We need to choose which and say how many payments.
Layaway fee of $5.00 minimum total Calculated as $1.00 per week added to payment of $5.00 to first payment whichever is largest,
Ability to cancel a layaway with an option to add a restock fee or forfeiture of money paid.
Ability to import to Products Table from Excel, (sample included). Need to be able to choose the manufacturer it is for and import as follows. If item number exits update pricing, If does not exist add to inventory. Different manufacture could have same inventory number.
Reports to include,
layaways outstanding and past due, Layaways due next 7 days
Import the zip code file into a new table for zip codes (included) . Customer maintenance should use zip code to auto bring in City and state.
Product Table
Do away with list price and add 3 fields. Freight as a percentage, markup as a percentage and Discount markup as a percentage.
Quotes and layaway entry screens need a checkbox for discount yes/no.
Price per item is calculated as
(cost*(1+freight)) * (1+markup) Markup based on yes/no discount . No=markup yes= discount markup.
Recommended Skills
Public Clarification Board
-
Contest Holder - 11 years ago
Contest winner will be awarded today
- 11 years ago
-
design4pro
- 11 years ago
hey.... how is the contest
- 11 years ago
-
Contest Holder - 11 years ago
Sorry all , i was out of town and just got back will.
- 11 years ago
View 1 more message -
wmvsql
- 11 years ago
Any update? I have completed the project along with testing using the input data and a few test customer data, since I poster my entry a few days ago. Would like to know your progressin the selection process. Thanks.
- 11 years ago
-
design4pro
- 11 years ago
yes... we need go ahead instructions please !
- 11 years ago
-
design4pro
- 11 years ago
Please review entry #10 and read the entry description well,I need your quick response to start working on other parts of this software, thank you !
- 11 years ago
-
design4pro
- 11 years ago
:)
- 11 years ago
-
vikasroy63
- 11 years ago
unable to open inventory database. It says unrecognized file format. Please re-attach the file.
- 11 years ago
-
design4pro
- 11 years ago
i think it's made from access 10 or higher office version, try upgrading your office package, it'll work...
- 11 years ago
-
salim789
- 11 years ago
Hi,i working with you.
- 11 years ago
-
frech4791
- 11 years ago
Hi. Setting up the customer and product entry screen has been pretty simple. Please clarify on the formula for calculating the price per item. One of the variables is COST; where can I get the values for this? In your requirements you mentioned that we should do away with the price list field.
- 11 years ago
-
bizwizz
- 11 years ago
Hello..I tried to work on this project and read your description a lot of times. But I still do not get a clear understanding of what you exactly mean by entry screens, what should be entered by the users in these entry screens, what information do we have on quotes etc.. May be this is the reason with other freelancers as well. Can you please rephrase your requirements in a step by step manner. I am sure you will get a lot of responses since it sounds to be a very interesting project. Hope you got what I am trying to say. Thank You for posting the contest.
- 11 years ago
-
Contest Holder - 11 years ago
Layaway (lay-by in Australia, New Zealand)[1] is an agreement in which the seller reserves an item for a consumer until the consumer completes all the payments necessary to pay for that item. Rather than taking the item home and then repaying the debt on a regular schedule, as in most installment plans or hire purchases, the layaway customer does not receive the item until it is completely paid for. There is sometimes a fee associated, since the seller must "lay" the item "away" in storage until the payments are completed. Because there is little risk involved for the seller, layaway can be readily offered to those with bad credit. If the transaction is not completed, the item is returned to stock and the customer's money is returned minus a fee.
- 11 years ago
-
Grunty
- 11 years ago
Guys I would do it too - if I only knew what's a layawy (title) ... no, Lawawy (attachment) ... no, lawway ... ok forget this one.
or what's an inventroy (attachment)
Anyway, I wish you get a nice layawy ... no, Lawawy ... no, Layaways thingie out of this contest.
Cheers all.- 11 years ago
-
kumarakhil
- 11 years ago
i have the ability
- 11 years ago
-
appiahdominicfli
- 11 years ago
hi,i can work on this,thanks
- 11 years ago
-
wajahataliii
- 11 years ago
Hi there- I can work on this. Thanks
- 11 years ago
-
honey2786
- 11 years ago
i will do this project
- 11 years ago
-
mhamdirochdi
- 11 years ago
I will do
- 11 years ago
-
solutionland2014
- 11 years ago
I will do this
- 11 years ago
-
Contest Holder - 11 years ago
I will consider more work if he application is mostly done and I can see that it will work for us. 100% complete is not required but I have to be sure it will do the job.
- 11 years ago
-
Contest Holder - 11 years ago
User forms can be done in Excel but data in Access. MS Access 10. Whole application by winner
- 11 years ago
-
Sshram
- 11 years ago
Whole application is to be written to be winner or just give sample ?
- 11 years ago
-
ingsunkancil
- 11 years ago
i can't open layaway inventroy.accdb . what version is this ms access database ?
- 11 years ago
-
bradyj87
- 11 years ago
Can this all be done in excel (userform), or does it have to be access?
- 11 years ago
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!
