Quote layawy

Résumé du concours

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.

Compétences recommandées

Meilleures propositions de ce concours

Afficher plus de propositions

Tableau de clarification publique

  • meanstealth
    Titulaire du concours
    • il y a 8 ans

    Contest winner will be awarded today

    • il y a 8 ans
  • design4pro
    design4pro
    • il y a 8 ans

    hey.... how is the contest

    • il y a 8 ans
  • meanstealth
    Titulaire du concours
    • il y a 8 ans

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

    • il y a 8 ans
    1. wmvsql
      wmvsql
      • il y a 8 ans

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

      • il y a 8 ans
    2. wmvsql
      wmvsql
      • il y a 8 ans

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

      • il y a 8 ans
  • wmvsql
    wmvsql
    • il y a 8 ans

    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.

    • il y a 8 ans
    1. design4pro
      design4pro
      • il y a 8 ans

      yes... we need go ahead instructions please !

      • il y a 8 ans
  • design4pro
    design4pro
    • il y a 8 ans

    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 !

    • il y a 8 ans
    1. design4pro
      design4pro
      • il y a 8 ans

      :)

      • il y a 8 ans
  • vikasroy63
    vikasroy63
    • il y a 8 ans

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

    • il y a 8 ans
    1. design4pro
      design4pro
      • il y a 8 ans

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

      • il y a 8 ans
  • salim789
    salim789
    • il y a 8 ans

    Hi,i working with you.

    • il y a 8 ans
  • frech4791
    frech4791
    • il y a 8 ans

    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.

    • il y a 8 ans
  • bizwizz
    bizwizz
    • il y a 8 ans

    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.

    • il y a 8 ans
  • meanstealth
    Titulaire du concours
    • il y a 8 ans

    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.

    • il y a 8 ans
  • Grunty
    Grunty
    • il y a 8 ans

    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.

    • il y a 8 ans
  • kumarakhil
    kumarakhil
    • il y a 8 ans

    i have the ability

    • il y a 8 ans
  • appiahdominicfli
    appiahdominicfli
    • il y a 8 ans

    hi,i can work on this,thanks

    • il y a 8 ans
  • wajahataliii
    wajahataliii
    • il y a 8 ans

    Hi there- I can work on this. Thanks

    • il y a 8 ans
  • honey2786
    honey2786
    • il y a 8 ans

    i will do this project

    • il y a 8 ans
  • mhamdirochdi
    mhamdirochdi
    • il y a 8 ans

    I will do

    • il y a 8 ans
  • solutionland2014
    solutionland2014
    • il y a 8 ans

    I will do this

    • il y a 8 ans
  • meanstealth
    Titulaire du concours
    • il y a 8 ans

    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.

    • il y a 8 ans
  • meanstealth
    Titulaire du concours
    • il y a 8 ans

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

    • il y a 8 ans
  • Sshram
    Sshram
    • il y a 8 ans

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

    • il y a 8 ans
  • ingsunkancil
    ingsunkancil
    • il y a 8 ans

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

    • il y a 8 ans
  • bradyj87
    bradyj87
    • il y a 8 ans

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

    • il y a 8 ans

Montrer plus de commentaires

Comment commencez des concours

  • Publiez votre concours

    Publiez votre concours Rapide et facile

  • Obtenez des tonnes de propositions

    Obtenez des tonnes de propositions De partout dans le monde

  • Attribuez la meilleure proposition

    Attribuez la meilleure proposition Télécharger les fichiers - Facile !

Publier un concours maintenant ou rejoignez-nous maintenant !