invoice form... change record from consignment to sold?

[Brook]

I have my frminvoices that I use to create both Cosignment and Sold Invoices.
My inventory is unique in that all my will never have two records with the
same value... size, colour, serialnumber, etc.. so I have it set up to allow
allow one record/inventory item per invoice.

The issue that I have is this, if I have a inventory item on a consigment
invoice that sells, then I have to create a Sold Invoice for that item.
However, since I have my form setup not to allow duplicates, I don't want to
have to go into the consignment invoice, delete the record, then create a new
sold invoice for that Item.

I am trying to figure out a way that I can create my Sold Invoice, select
the record/sold inventory item and have a popup message asking if the rug is
sold or duplicate. If sold then it removes it from the consignment invoice,
and adds it to the new sold invoice.

Is this possible in a somewhat easy way?

Thanks,

Brook

 

[David C. Holley]

Add a field to the table txtStatus and use that to indicate wether or
not its SOLD.

 

[Brook]

I do have an invoicetype either "Consignment" or "Sold". The issue is, is
that when I create a sold invoice for an item that has been sold from
consignment and I choose that Item as being sold for the invoice I cannot add
it to the Sold Invoice b/c it tells me that there are duplicate values, then
I have to delete it from the consignment invoice before I can add it to the
sold invoice...

Is this clear?

Brook