AnsweredAssumed Answered

invoice solution question

Question asked by willrollo on Jan 28, 2012
Latest reply on Aug 8, 2012 by bumper

Title

invoice solution question

Post

Hi

I am creating an invoice solution and am trying to work out the best way to go around it. 

I have four tables - Customers, Invoices, Line items and Products.

 

They are related by using primary and foreign keys as suggested by the Database pros (mark Osborne) video tutorials.

 

I want the user to be able to create a new customer from the "new customer" layout. There are a couple of buttons on this layout to perform the script "new order" or "new quote"

 

What I am having trouble with is:

 

When a quote is created, I would like the option for the user to create an order from this quote  When the order is created, I would like an order number to be created as well.

THe order/quote fields must be editable.

When the order is converted to an invoice, I do not want the user to be able to edit it. 

Can I use the same layout for quote/order/invoice? I would like the layout's background colour to change with each stage of the order process...

 

 

I hope this makes sense!

Help appreciated....

Outcomes