Inventory update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a table to save stock delived in.
As well as stock shipped.
In between I want to run a table to monitor stock levels + and -.
How do I get the deliv and shipment table to update to this table?
Thank you
 
Esrei said:
I have designed a table to save stock delived in.
As well as stock shipped.
In between I want to run a table to monitor stock levels + and -.
How do I get the deliv and shipment table to update to this table?
Thank you
Click to expand...

You don't.

You want to compute it live rather than trying to populate and then
correct an always out of date table.

You can create a query to compute the difference between the two.
 
OK I understand but my problem is this I actualy want to do a couple of things.
1. I want to see what stock is left when I compile a shipment
2. Not all on the deliv note is shipped on one shipment.
3. I want to store how a deliv note was split up in shipments to allocate
sales later.

Hope I make sence
 
Esrei said:
OK I understand but my problem is this I actualy want to do a couple
of things.
1. I want to see what stock is left when I compile a shipment
2. Not all on the deliv note is shipped on one shipment.
3. I want to store how a deliv note was split up in shipments to
allocate sales later.
Click to expand...

1. No problem using computed stock quantities vs stored stock quantities. I
would think it would be even easier.
2. No problem that I can see for a computed stock on hand system.
3. No problem that I can see for a computed stock on hand system, you just
keep the delivery information which you would naturally do.
 
Back
Top