move record?

G

Guest

Good Day all,

I have an invoice form (frminvoices) set up so that the user can add
either a Consignment or Sold Invoice. the frm has a subform
(frminvoicedetailssubform), that the user selects the inventory item for the
invoice. As it is set up right now, there are no duplicates allowed so that
each inventory item is unique and only one specific inventory item can be
selected for either a sold invoice or consignment invoice...

The issue i'm having trouble with is that if one item off a consignment
invoince is sold, I have to go into that consignment invoice delete the item
then add it to the sold invoice. I would like to have the option to set up a
sold invoice, select the item I would like to add and if it is already on a
consignment invoice, have a message box asking if I would like to move or add
it to this invoice?

Is that possible?

Thanks,

Brook
 
T

TC

Say you add inventory item #111 to consignment invoice #222. Later on,
you add the same inventory item #111 to a sold invoice. How do you know
which consignment invoice corresponds to that sold invoice? Do they
have the same Invoice Number?

It might help if you showed us the structure of the relevant tables.
For each table, show the name of the table & the names of all the main
fields. (Their types & lengths are not important here.) Be sure to show
the primary key field(s) for each table.

HTH,
TC
 
G

Guest

Good day,

Thanks for the response,

the Consignment Invoice and Sold invoices are independent of each other, so
that is why I wouldneed to move the item from Cosignment to Sold.

Brook
 
T

TC

Brook, in order for the datbase to automatically remove an item from
the consignment inoice, it would need a rule to answer the question,
"which is the right consignment invoice, to remove this item from?"

Say you added inventory item #111 to consignment invoice #222. Later
on, you added the same inventory item #111 to a sold invoice. What is
the rule that answers the question, "which consignment invoice should I
remove that item from?"

There must be such a rule. It is the rule that you are using when you
do this process manually. If you want to automate this process, by code
within your database, you have to describe or tate that rule, so it can
be programmed-in.

HTH,
TC
 
G

Guest

TC,

I think you have almost hit the nail on the head... if I have item #111
on consignment invoice #222, that item can only be found on that invoice. I
don't have any inventory items the same, so each is unique. So you are right,
I want to automate the process of moving item #111 from consignment invoice
#222 to sold invoice #333.

Right now, what I do is manually delete it from the consignment invoice
and add it to the sold invoice.

Is that clear?

Thanks,

Brook
 
T

TC

No, it's still not clear to me.

Perhaps try giving a mall example with actual data.

Or, try writing out the exct instructions in English - as if you ha to
go awayu at short notice, and you needed for someone else (whose never
done it before), to do it all for you.

HTH,
TC
(off for a while)
 
G

Guest

ok...

here it goes...

first thing is to explain my inventory: I don't have any one item alike, I
produce a custom product and each one has a specific serial number.

When I sent inventory out on consignment I use my fmrinvoices (subform
(frminvoicedetailssubform) to add inventory items (no duplicates allowed) to
the consigment invoice.

If one or all of those inventory items are sold, I need to create a sold
invoice for those items either 1 or 30.

So, lets say that I have consigment invoice #111 with the following
inventory items:

I-0001
I-0002
I-0003
I-0004
I-0005

and the client sells I-0003, so what I need to do is create a Sold Invoice
for the item... but right now its on the consignment invoice
so when I add the Sold Invoice (#555) and go to the frminvoicedetails
subform and select the I-0003 to add, as of now it show and being a duplicate
and won't let me add it, so I need to be able to move it from the
Consignement Invoice to the Sold invoice.

Does this help at all?

Thanks,

Brook
 
T

TC

Hmmm, not sure if I've got it yet. Please answer the questions below.
It would help if you could put your answer right under each question
:)
first thing is to explain my inventory: I don't have any one item alike, I
produce a custom product and each one has a specific serial number.

But surely you have /product/ codes? For example, product code #1 is a
widget, and you've got a hundred widgets (each with their own serial
#); product code #2 is a flange, and you have five hundred flanges
(each wih their own serial #) ...

- Is that correct?

- If so, could two different products have the same serial #? (eg. a
widget and a flange both have serial # 00058)

So, lets say that I have consigment invoice #111 with the following
inventory items:

I-0001
I-0002
I-0003
I-0004
I-0005

- Could you have number I-0001 on /several/ invoices? Or is each of
these numbers, truly unique to a single invoice?

- Are those numbers the "serial numbers" that you spoke of before? If
not, what is the differnce?

Cheers,
TC
 
G

Guest

TC said:
Hmmm, not sure if I've got it yet. Please answer the questions below.
It would help if you could put your answer right under each question
:)


But surely you have /product/ codes? For example, product code #1 is a
widget, and you've got a hundred widgets (each with their own serial
#); product code #2 is a flange, and you have five hundred flanges
(each wih their own serial #) ...

Yes, you are correct in that I have product codes or serial numbers... I
sell custom rugs, so each is unique so I have the following :

Description Serial#
Rug 1 00051
Rug 2 00052
Rug 3 00053
Rug 4 00054

and so on...
- Is that correct?

- If so, could two different products have the same serial #? (eg. a
widget and a flange both have serial # 00058)

------ *** No... not at all, no two products will ever have the same serial
number...
- Could you have number I-0001 on /several/ invoices? Or is each of
these numbers, truly unique to a single invoice?

-- no, each is truly unique to a single invoice...
- Are those numbers the "serial numbers" that you spoke of before? If
not, what is the differnce?

if your refuring to these, these are just examples of a rug serial number...

Thanks, I hope I have answered your questions...

Brook
 
T

TC

Ok! I have it. Every item in your inventory, has a unique number. No
two items ever have the same number. If there were 500 items in your
warehouse, there would be 500 different numbers, one per item.

You have two classes of invoice - consignment invoice, and sold
invoice. When you add an item number to a sold invoice, the system
should automatically remove that item number from any consignment
invoice on which it appears.

So, for example, if you added item number #111 to a sold invoice, the
system should automatically look for item number #111 on a consignmen
invoice - and if found, the system should delete that item number from
the consignment invoice.

In this process thre is no predictable relationship between the invoice
number of th consignment invoice, and the invoice number of the sold
invoice.

Correct?

If so, all you need to do now, is to show me the strcure of each of the
tables (consignment invoice and sold invoice). Please list each of the
fields in those tables. Clearly show the item number field, in each
table.

The actual code, will be quite simple.

HTH,
TC
 
G

Guest

Good Day TC,

I have just returned from an out of town, and got your reponse, not sure
if your still around to help me but please post if you are..

Brook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top