ASP Reporting from Access Database

Please see Deliverables. ## Deliverables I have an Access database, and some asp code that needs to be put together to provide online reports for three levels of user-specific access. Most of the database work is done, some logic for commission calculation needs to be put in. The database should be able to generate an excel report or a report in a list format that lists all of the above fields for all deals-to-date in date ascending order with headings. A method should be provided for me to be able to upload this said list from Excel into the Access database and over-write all of the non-required fields for individual deals. The database needs to be able to compute commissions at two levels, and generate reports for: o Account Manager: Paid on month-to-date booked revenue. Percentile of commission will be provided. Automated monthly records of commissions paid once a magic ‘final monthly approval’ button is hit need to be created in a separate table. I should be able to go to this table to see what an account manager was paid in any month/year, and be able to compute group totals. I also need a way to add new employees to the account manager list. Special Requirement: If an ‘install complete date’ has not been populated within 120 days of a deal being marked ‘paid’, then a re-computation needs to occur for the last 3 months to see if the commission tier would have been different, and if different, there needs to be a chargeback reflected on the report. When this occurs, the deal needs to be marked ‘not paid’ and should figure in future month’s commission tiers whenever the ‘install complete date’ is populated. There also needs to be a provision to ‘cancel’ a deal, i.e. hold it in booked MRR numbers, but mark it as not-payable for commission. Agents: All deals marked ‘Agent’ need to be commissioned. A flat percentile rate should be automatically assigned to a deal based on the revenue being billed that month. It is assumed that revenue is being billed if an ‘install complete date’ is present in the deal record. This rate will carry for the term of the deal. A ‘commission paid for the term of the deal’ number should be able to generate at that point. A monthly commission no. should then be generated by adding commissions on individual deals. Deals are only paid for the term: 12, 24, or 36 months. So they should fall off the ‘to-be-paid’ list when the said number of months have been paid. The first ‘payable’ month will start when the ‘install complete date’ field has been populated. A # of months remaining record should also auto-update. Like account manager commissions, an auto-generated record should be created when the magical ‘final monthly approval’ button has been hit that records billed MRR tier, # of deals being paid on, and commission paid this month, and cumulative per agent. Special Requirement: There also needs to be a provision to ‘cancel’ a deal, i.e. hold it in booked MRR numbers, but mark it as not-payable for commission. My requirements are that the work be completed using Visual Studio (VB, VBscript, Interdev, VJ++ etc.) We can break this down into two phases: Phase I will provide deal status reports per partner, Phase II should provide commission reports for partners and employees, and record this info in history tables. Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. ## Deadline information phase i must be completed by sun, jan 27th, 2002 12pm est. phase II must be completed by sunday feb 3rd, 2002.