Need simple ASP forms & access tables for a pricing program.? Ability to add a new customer number and it be assigned a? default price level (via a drop down)? for several different? categories with? a default value? for freight & vendor discount.? ? This information would come from a? category? table.? Will need? a category form? for adding category's with freight (A drop down -? lookup from a freight percentages table)? and vendor discount for each one.? Each customer's? categories will then? require the? ability to be modified with a different discount,? freight and vendor discount and stored for retrieval.? On each of the customer form displays, will need to show the GP for each category, using a simple formula - For each category this would be the? category discount minus the freight percentage plus the vendor discount divided by the GP for that customer.?
Bascially,? a form will have a input box for a new customer id as 110 for example and drop down to pick the default price level it would be assigned.
The customer form for 110, would then show all the categories with their default values for vendor discount, freight percentage (A drop down with the default percentage), and the price discount and it's calculated GP.? Each of those fields would have the ability to be modified and stored for that customer ID.? If that form is updated, the new results would then display.
Will need a simple customer look up form, as well to display the above results for the customer.? Need a form to modify the categories table, to add categories and their discounts & freight.
There may be future changes to this basic program and the need to call upon your assistance.? The price for this project will be no more than? $10.00 with a possible bonus to the person who completes it.
## Deliverables
Rent A Coder requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
ASP/Access
The? excel table attached? is just an example of the data that would go into the tables, it also shows the formulas.