RE: [Web-erp-developers] Re: some serialised work

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

> As a fundamental criteria for the functionality of serialised stock, =
we need
> to be able to determine and track which serial number items we have at =
any
> point in time and at which location these are stored. We need to be =
able to
> find to whom a particular serial number was sold. We need to be able =
to see
> when a particular serial number item came in. This effectively boils =
down to
> an inquiry as per the current stock movements inquiry but at the lower
> level. ie the stockmovements inquiry looks at the part and location - =
we
> need to look at the part, location and serial number to see the =
movements of
> the individual item.
I believe it satisifies this... you'll probably find that soon. =
Basically the SerialisedStockMoves tables does what you want. First, =
though, realize that the current StockMoveNo for a Serial Items is =
stored in the (soon to be renamed) StockSerialItems table. That gives us =
the current 'status' of the Item at a moments glance. For a Historical =
view, there will be multiple entries in the SerialisedMoves table per =
SerialItem that maintains links to the previous StockMove and the =
CurrentStock move. For example, here's what it might look like:

5 - PO/GoodsReceived
6 - LocationTransfer
7,8,9 - SalesOrders

StockId  from    to
10  		5       6
11  		5       6
12  		5       6
10  		6       7
12  		6       8
11  		6       9
* Note there is no initial record for the PO Received (or what ever the =
1st move is) aside from the StockSerialItems entry w/ the =
CurrentStockMove.

So, I believe the data is available - getting at it will require =
determining how people find the need to get at it... For example, are =
you going to start with a single Item and look for it's history? A whole =
bundle/StockMove of items and find out where they went? This can get =
hairy, but there's really no option as we need to track all the data. =
Consider 1000 items purchased at a main warehouse, sent to 10 different =
warehouses, and then sold separarately to 200 customers. That's alot of =
moves and a fairly large complicated report for some of the options =
above.

Let me know how that goes over with you.... btw, when you get a chance =
to get to the Credit stuff we started talking about, let me know...


jesse