Quote layawy

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

Top entries from this contest

View More Entries

Public Clarification Board

  • meanstealth
    Contest Holder
    • 7 years ago

    Contest winner will be awarded today

    • 7 years ago
  • design4pro
    design4pro
    • 7 years ago

    hey.... how is the contest

    • 7 years ago
  • meanstealth
    Contest Holder
    • 7 years ago

    Sorry all , i was out of town and just got back will.

    • 7 years ago
    1. wmvsql
      wmvsql
      • 7 years ago

      all good, please see my updated comments in entry #12 . thanks...

      • 7 years ago
    2. wmvsql
      wmvsql
      • 7 years ago

      Project is now locked, please msg me your comments directly regarding my replies to your questions. Thanks

      • 7 years ago
  • wmvsql
    wmvsql
    • 7 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.

    • 7 years ago
    1. design4pro
      design4pro
      • 7 years ago

      yes... we need go ahead instructions please !

      • 7 years ago
  • design4pro
    design4pro
    • 7 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 !

    • 7 years ago
    1. design4pro
      design4pro
      • 7 years ago

      :)

      • 7 years ago
  • vikasroy63
    vikasroy63
    • 7 years ago

    unable to open inventory database. It says unrecognized file format. Please re-attach the file.

    • 7 years ago
    1. design4pro
      design4pro
      • 7 years ago

      i think it's made from access 10 or higher office version, try upgrading your office package, it'll work...

      • 7 years ago
  • salim789
    salim789
    • 7 years ago

    Hi,i working with you.

    • 7 years ago
  • frech4791
    frech4791
    • 7 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.

    • 7 years ago
  • bizwizz
    bizwizz
    • 7 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.

    • 7 years ago
  • meanstealth
    Contest Holder
    • 7 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.

    • 7 years ago
  • Grunty
    Grunty
    • 7 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.

    • 7 years ago
  • kumarakhil
    kumarakhil
    • 7 years ago

    i have the ability

    • 7 years ago
  • appiahdominicfli
    appiahdominicfli
    • 7 years ago

    hi,i can work on this,thanks

    • 7 years ago
  • wajahataliii
    wajahataliii
    • 7 years ago

    Hi there- I can work on this. Thanks

    • 7 years ago
  • honey2786
    honey2786
    • 7 years ago

    i will do this project

    • 7 years ago
  • mhamdirochdi
    mhamdirochdi
    • 7 years ago

    I will do

    • 7 years ago
  • solutionland2014
    solutionland2014
    • 7 years ago

    I will do this

    • 7 years ago
  • meanstealth
    Contest Holder
    • 7 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.

    • 7 years ago
  • meanstealth
    Contest Holder
    • 7 years ago

    User forms can be done in Excel but data in Access. MS Access 10. Whole application by winner

    • 7 years ago
  • Sshram
    Sshram
    • 7 years ago

    Whole application is to be written to be winner or just give sample ?

    • 7 years ago
  • ingsunkancil
    ingsunkancil
    • 7 years ago

    i can't open layaway inventroy.accdb . what version is this ms access database ?

    • 7 years ago
  • bradyj87
    bradyj87
    • 7 years ago

    Can this all be done in excel (userform), or does it have to be access?

    • 7 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!