Hello,
I run a horse training business and have made an access database to track all of our customer info, horse info, care and training reports as well as invoicing. However, we have a few issues with the invoicing portion - the chief of which is that 3rd party care (vet, farrier, chiro etc) prices are different each appointment - so having a single entry price list does not work (because when you change the price to invoice a customer it changes the price in every entry)
Is there a way around this?
What I am working on is a system that would have a table for our standard services with set pricing, and one for 3rd parts charges where each entry would hold its own price.
What I'm also trying to do is make a charge and invoice system so that when a horse receives a service, a charge can be entered on that day instead of having to keep track and remember at the end of the month to invoice for everything that happened. Then when we want to invoice a customer we could select which charges to invoice for, and populate an invoice.
Is this possible, and if so how would I set it up?