Items

[dajoem]

Hi there,

 

Is there a way to add an extra column into the item table?

For Example,

Items table – Current

 

Item Description Tax Value Quantity Last Used

A Banana None $8.00 4 31/12/10

B Apple None $15.00 3 31/12/10

C Orange None $10.00 7 31/12/10

D Grape None $12.00 10 31/12/10

 

 

Items table – New

NEW COLUMN

Item Description Tax Value Quantity Last Used Customer

A Banana None $8.00 4 31/12/10 John

B Apple None $15.00 3 31/12/10 John

C Orange None $10.00 7 31/12/10 John

D Grape None $12.00 10 31/12/10 John

A Banana None $6.00 20 31/12/10 Mary

B Apple None $12.00 10 31/12/10 Mary

C Orange None $7.00 30 31/12/10 Mary

D Grape None $8.00 15 31/12/10 Mary

 

So when i go to create an invoice, selected a customer let say Mary, only Mary's items should be display or allow me to add into the invoice.

Why because each buyer will have a set price depends on the volume. If this is allowed, I will buy it. This Express Invoice suits me fine for what I want to do.

Looking forward to your help.

 

Regards,

David