Mike Copeland wrote:
Opinion time... (or maybe it's a solid fact and I missed the memo?)
<snip>
I'm thinking due to the client-server design, that it should work like
this...
1. Receive piece of merchandise, add it to "All Inventory" table (date
received, price, etc.) which also has an empty field for "sold"
2. When an item is sold, just update that one and only record for that
unit with the sales document # of the sales ticket.
Done!
Am I creating a bottleneck for data access? Obviously the one table
will be used to query ALL inventory questions...is something in stock?
How many have been sold? How many are not sold? Since I'm using
InnoDB tables there shouldn't be any locking issues...
If there are benefits and disadvantages to each approach, is one the
preferred approach?
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
.
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or
disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd
Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700
Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
BRAVE SOUL
LAUNCHING AT
PURE 2014
STAND C40
3-5th AUGUST
LONDON'S OLYMPIA
_______________________________________________
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.
