RE: [Web-erp-developers] Warehouse Management

[Jesse P. <je...@st...>]

Thanks, that's good to see. I'd have to say I'd be inclined to do =
separate Bins tables - pretty much for the same reason we separated out =
the SerialItems from the StockMoves... it didn't have to be done and it =
made this a litle more complicated, but it leaves alot more room for =
growth in the system.

The one comment I have is on the worries of 'what if this table is not =
updated when xxxx happens' - testing, testing, testing :) It just needs =
to be coded and tested to make sure things are working correctly. I can =
atest to having to start over with a demo system several times working =
with serial stock for exactly the same reason.

Also, Phil is correct about the some of the logic needed being available =
already to help handle most of this... but code & sql-wise, obviously, =
it pretty much will have to be done from scratch... maybe it's more like =
tracing a picture through notebook paper - you kinda having an outline =
to follow, but it's not perfect.

jesse

-----Original Message-----
From: Phil Daintree [mailto:ph...@du...]
Sent: Monday, October 04, 2004 9:14 PM
To: web...@li...
Subject: [Web-erp-developers] Warehouse Management


I hope you dont mind Chris - we had a discussion on warehouse mgt =
earlier=20
today and I though Jesse may well be interested in this project too....

Created on 5 October 2004 14:09:27.
05/10/2004
(09:15:03) chris_bice says:

Phil, Did you say you thought it would be better to add a table called =
Bins,=20
where it would have BinID, LocCode with a Constraint to Locations, =
LocCode,=20
then add a field into LocStock, a BinRef field, Contrainted to BinID in=20
Bins??

(09:15:30 ) Phil Daintree says:

Yes I thought this would be the approach

(09:16:01) chris_bice says:

cool. I have alot of the code done then

(09:16:26 ) Phil Daintree says:

I have done a whouse mgt system before and it is kinda nice to know in =
one=20
table what is where. It was in VB unfortunately

(09:17:04 ) Phil Daintree says:

Not sure about adding a field into Locstock

(09:17:05) chris_bice says:

Im a fan of VB. Its kind fo a hog, but it does a good job

(09:17:20 ) Phil Daintree says:

Not used it since that system

(09:17:36 ) Phil Daintree says:

Why do you need Bin in LocStock?

(09:18:21) chris_bice says:

So you dont have to update two tables when you update your stock

(09:18:37 ) Phil Daintree says:

Right.

(09:18:53 ) Phil Daintree says:

I need to chew this a bit

(09:19:37) chris_bice says:

Cause then all ther exsisting scripts will still work the same. The =
Select=20
Sum(Qty) from LocStock where Location =3D ""Blah" will work fine

(09:20:05 ) Phil Daintree says:

Yeah ok, but what about a qty that is split accross several bays. The=20
Quantity in LocCode is 4000 but this is in a bunch of Bins

(09:20:51 ) Phil Daintree says:

This would mean that there would need to be a gazillion LocStock =
records. We=20
really only have one for each Location and StockID at the mo

(09:21:03 ) Phil Daintree says:

Called away will come back

(09:21:09) chris_bice says:

Here is my idea, from the StockStatus, screen your Location is =
Hyperlinked=20
to a LocStatus screen that shows you the Bin Qty's for the said part, =
with=20
in the Selected Location,and a Picture or diagram of where that bin is =
in=20
the warehouse

(09:21:13) chris_bice says:

k

(09:37:08 ) Phil Daintree says:

Kinda like the serial number/batches inquiry? Have you played with the=20
Serialised stock items yet. May be worth you having a look at - Make a =
new=20
item and define it as controlled - the item can be defined as serialised =
ie=20
only one item per reference or have many items per reference ie =
lot/batch=20
control. When you receive PO items you need to enter the batch/serial no =

references. An inquiry from stock status shows what batches/S/Ns you =
have on=20
hand

(09:39:53 ) Phil Daintree says:

I still like the idea of having the warehouse bins defined separately. =
ie=20
one defines the warehouse bins available separately in the Bins table =
and=20
this table is updated when the stock is booked in with the bin =
references=20
where it is stored. It would easy to make a nice graphical picture of =
the=20
warehouse bins with what is in each bin

(09:45:11) chris_bice says:

The only thing that "scares" me about doing it that way, is what happens =
if=20
a SQL adds the items to the Bins table but doesn't update the LocStock =
with=20
the correct Amount??

(09:47:56 ) Phil Daintree says:

OK it means updating another table at the time of receiving and this is =
a=20
downer, but it preserves all the existing functionality for=20
invoicing/receiving/crediting/adjusting/transfering without a re-write. =
We=20
then have an if $WarehouseManagementActive - not a Chris variable name I =

realise!! then update the bins.

(09:48:29 ) Phil Daintree says:

The bigger scare to me is having the LocStock quantites wrong. This is =
one=20
vital area we cant afford to bugger up!!

(09:49:50) chris_bice says:

But The LocStock would potentially be wrong if your Bin table is =
correct,=20
but your LocStock wasn't updated correctly??

(09:50:01 ) Phil Daintree says:

Also some Locations may have warehouse management active and others not =
- i=20
guess this is a flag in the Locations table. The system would need to=20
inspect this flag on receiving stock to ensure that the appropriate link =
is=20
available to allow allocation of the stock received to bins

(09:50:40 ) Phil Daintree says:

We are not changing anything about the LocStock logic under this =
scenario -=20
so we can be confident it is not compromised

(09:51:12 ) Phil Daintree says:

The bin table stands apart - for those locations where warehouse =
management=20
is active.

(09:51:35) chris_bice says:

K

(10:21:13) chris_bice says:

I dont like that Idea. It seems like we are going to have to create alot =

more scripts. But I see your point. Let me chew on it tonight, and start =

transforming some of my code over.

(10:21:56) chris_bice says:

IM also working on getting my RMA Code switched over as well

(12:55:20 ) Phil Daintree says:

The beauty of the approach is that a lot of the new scripts are already=20
written albeit in a slightly veiled guise - called controlled/serialised =

stock. These would only need to be modified to use the new Bins table =
and=20
Bob's ur fathers auntie!

Phil=20



-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give =
us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out =
more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers