Invoicing vs Quoting or Estimating

Posted by FreshCode on Stack Overflow See other posts from Stack Overflow or by FreshCode
Published on 2010-04-28T22:13:35Z Indexed on 2010/04/30 21:27 UTC
Read the original article Hit count: 259

Filed under:

invoice

|

quoting

|

database-design

|

best-practices

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 or Order. 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?

Edit: indicated Job === Order for this particular instance.

© Stack Overflow or respective owner

Related posts about invoice

ASP.NET MVC 2 - Saving child entities on form submit

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, I'm using ASP.NET MVC 2 and am struggling with saving child entities. I have an existing Invoice entity (which I create on a separate form) and then I have a LogHours view that I'd like to use to save InvoiceLog's, which are child entities of Invoice. Here's the view: <%@ Page Title="" Language="C#"… >>> More
XML invoice specification

as seen on Stack Overflow - Search for 'Stack Overflow'
I am writing an application which produces invoices. Yes, it sucks. I was wondering it there was any agreed upon DTD for invoices? It seems like everybody has their own format. Perhaps there is a collection of XSLTs for tranforming a common standard into lesser known formats? >>> More
Excel VBAa: Sum invoice by client id with copying result to new worksheet

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, i have strange problem doing reporting: i have numerous clients with different issued invoices. Problem comes to the point when there are invoices in minus and plus: Column A consists of client unique IDs, Column B invoice number, column C invoice amount A | B | C 0010019991… >>> More
Excel VBA: Sum invoice by client id with copying result to new worksheet

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, i have strange problem doing reporting: i have numerous clients with different issued invoices. Problem comes to the point when there are invoices in minus and plus: Column A consists of client unique IDs, Column B invoice number, column C invoice amount A | B | C 0010019991… >>> More
ASPxGridView Pager disappears

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, I use the ASPxGridView with paging, pager settings is next: <SettingsPager Mode="ShowPager" Position="Bottom" Visible="true"> Also I have a CustomButtonInitialize event: protected void gridViewInvoices_CustomButtonInitialize(object sender, ASPxGridViewCustomButtonEventArgs… >>> More

Related posts about quoting

Quoting of decimal values

as seen on Stack Overflow - Search for 'Stack Overflow'
I am storing a running total in a Decimal(10,2) field and adding to it as items are processed. update foo set bar = bar + '3.15' About 20% of the times a warning is issued "Data truncated for column 'bar' at row 4" This warning is never issued if the update value is not quoted. Should decimal values… >>> More
My Zend Framework 'quoting' mess.

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a probably very simple issue to which I can't find a satisfactory (subjectively seen) answer in the Zend Framework manual or elsewhere... There are so many ways how I can hand over my php variables to my sql queries that I lost the overview and probably I lack some understanding about quoting… >>> More
Invoicing vs Quoting

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More
Is there a Chilton's like site for quoting/Programming

as seen on Stack Overflow - Search for 'Stack Overflow'
Do you know if there is anything out there like Chilton's for cars: http://chilton.cengage.com/ For programming or sites that may be like it. I am trying to get a better grip on quoting jobs and wondering if there is anything like this. >>> More
Windows Batch Scripting Issue - Quoting Variables containing spaces

as seen on Stack Overflow - Search for 'Stack Overflow'
So here's my issue: I want to use %cd% so a user can execute a script anywhere they want to place it, but if %cd% contains spaces, then it will fail (regardless of quotes). If I hardcode the path, it will function with quotes, but if it is a variable, it will fail. Fails: (if %cd% contains spaces) "%cd%\Testing… >>> More