Hello all,
I have just created a database (partially) which will bill customers for
work done. However I am stuck when it is comes to different rates for
different works.
REQUIRED: What I intent to have is a form in which I will enter the customer
order no: and then in the subform choose the work done and then based on the
work input calculate the rates and have it billed to the customer. I have no
idea on how to have the rates calculated based on the type of work done and
the number of days.
The fields which will be filled are 'Type Of work' done , also SubCategory
...such as whether ....'new job'; 'edit an old job', 'destroy a job done',
'get help from outside' etc ....for each of these there are different rates.
New job for first day free and later on charged ....similarly editing job
chargable at a single rate for the first day ..then at a particular rate for
the next day.....destroy job done based on the days worked and no of
employees worked at constant rate.....External help done charges. Each
customer bill may also have all of the categories embedded in it.
Bill 100
-------
If work done for CustomerA is new job and for one day then charge A 120$.
Also, work done is Edit job then charge XX based on number of days...etc
Total invoice == Sum of all this.
Please help me out and do let me know if you are having any problems in
understanding.
Regards,
Z