Hello -
I hope someone can help me with a problem in creating a lookup for a client. This is a small lawn care company that I'm working with.
I need to add a line items to an invoice. OK no problem right???
The problem I'm having is kind of mulit-faceted.
They have both 'hard items' like sprinkler parts, mower parts, etc. and they have services that, depending on what the service is, is charged differently.
The parts I have no problem with - real similar to AlphaSports setup. Where I'm running in to problems is looking up for the services.
I have several spreadsheets they use (of course no rhyme or reason in the pricing - I'm trying to get them to change still) that I converted to tables. Most of the services are charged out based on square footage of the property they are treating (Fertilizer, insect controll, weed controll, etc. Some are also charged hourly.
The customer table contains a field for lawn area (in sq ft) and account type. Depending on the service I need to find the area measurement in the appropriate range in the servicelookup table and put that cost in the line item based on commercial or residential.
The other problem I'm having is how to put both 'parts' and 'services' on the same invoice. In other words how to choose where I'm looking for the item number to charge out.
I've attached a small test db that I've been playing with. May be some one can see something I'm missing.
Thanks for your help!
Scott
I hope someone can help me with a problem in creating a lookup for a client. This is a small lawn care company that I'm working with.
I need to add a line items to an invoice. OK no problem right???
The problem I'm having is kind of mulit-faceted.
They have both 'hard items' like sprinkler parts, mower parts, etc. and they have services that, depending on what the service is, is charged differently.
The parts I have no problem with - real similar to AlphaSports setup. Where I'm running in to problems is looking up for the services.
I have several spreadsheets they use (of course no rhyme or reason in the pricing - I'm trying to get them to change still) that I converted to tables. Most of the services are charged out based on square footage of the property they are treating (Fertilizer, insect controll, weed controll, etc. Some are also charged hourly.
The customer table contains a field for lawn area (in sq ft) and account type. Depending on the service I need to find the area measurement in the appropriate range in the servicelookup table and put that cost in the line item based on commercial or residential.
The other problem I'm having is how to put both 'parts' and 'services' on the same invoice. In other words how to choose where I'm looking for the item number to charge out.
I've attached a small test db that I've been playing with. May be some one can see something I'm missing.
Thanks for your help!
Scott
Comment