| Discussion Forum: Thread 156824 |
|
 |
| | | Author: | calsbricks  | | Posted: | Aug 16, 2013 03:43 | | Subject: | Ingventory improvements for BL 2 | | Viewed: | 86 times | | Topic: | Suggestions | | Status: | Open | | Vote: | [Yes|No] | |
|
| Have noticed other posts for this subject recently and would like to re-iterate
one we tabled a long time ago.
There needs to be an audit trail of inventory movements for each store, showing
ins/outs, date, quantity, colour, condition and price set. This will help inventory
control enormously. Currently if you have a 'lot' (Unique part no, colour
and condition) it stays as that lot forever. If you sell out of that particular
item and then add another one you get a new lot. The only information that appears
to be available from that is lot specific e.g. when you added it and when you
last sold it. It doesn't tell you the last time you added additional ones
or give any kind of transactional movement for that item.
In simple terms this is 'stock movements' and despite the3 complications
both progamming and otherwise, it should be an essential part of the new system.
If we are going to put all our eggs for inventory control into one basket (e.g.
Bricklink), then there should be a much stronger inventory management system
behind it.
These features go beyond Brickstore and any other system we have looked at since
opening our store, but they would certainly help to control inventories, or at
least be able to trace something.
As we understand the existing database uses SQL server to hold its data and a
very old (progamming language) for its front end, we hope the new development
retains the SQL back end and uses a much more modern web based language for the
front end.
|
|
|
|
|
|
|
United Kingdom, England
