Invoicing vs Quoting
- by FreshCode
If invoices can be voided, should they be used as quotations?
I have an Invoices tables that is created from inventory associated with a Job. I could have a Quotes table as a halfway-house between inventory and invoices, but it feels like I would have duplicate data structures and logic just to handle an "Is this a quote?" bit.
From a business perspective, quotes are different from invoices: a quote is sent prior to an undertaking and an invoice is sent once it is complete and payment is due, but how to represent this in my repository and model.
What is an elegant way to store and manage quotes & invoices in a database?