Peter Cushing wrote:
The way our stock system here works (very basic overview) is you have
an inventory table that has totals for
In stock (physically in warehouse)
Allocated (sold)
Free stock (In stock - allocated I.e free to sell)
Quantity on order (ordered but not arrived)
These totals should be able to answer the questions above (and more)
We also have a stock transaction table which has entries of type
Receipts - goods arrive
Allocated (sold)
Deallocated (cancel order)
Issue (send the goods out)
+ various others.
Having a transaction table is good because you can use it to find out
who you sold the goods to and when plus you can roll up the totals to
check your instock and allocated figures.
HTH
Peter
Thanks Peter!
In trying to keep my original question simple and generic, I didn't
point out that the inventory my system tracks is serialized (big ticket
items) and needs to have unit-specific detail tracked...date of receipt,
serial number, color, supplier, cost...all of which is usually different
for each item, even with identical SKUs. So each row in the table is for
one item. My largest software user used to go through about 15,000 units
a year until recently when their volume (due to multiple outlets and
aggressive growth) has cranked up to around 250,000 a year.
I tried to keep running totals for inventory years ago and found it was
much easier and more accurate to just tally the #s when they were
needed. Thanks to the speed of the Fox's data engine, no one ever
complained about how long the calculating took, until recently when we
started using the Internet to link retail locations together.
Mike
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
