Inventory update

[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

 

[Joseph Meehan]

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

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.

 

[Guest]

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

 

[Joseph Meehan]

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.

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.