- Status: Closed
- Prize: $350
- Entries Received: 2
- Winner: tandonshailendra
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.
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.