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

[Phil D. <ph...@du...>]

> > StockItems could be called something like StockSerialItems or such to
avoid
> > confusion with a stock master and specify that the table is to do with
> > serialised stuff.
> yeah, yeah, yeah - makes sense :) shall I fix it in the next set of
changes I send?

Yes please!

I am finding the diff great for working through the changes, but to a large
extent your mods look as though they could go straight in without me
"interfering", it seems your changes to the existing code are beneficial
from a readability and maintainence perspective of those I have seen, so its
good to have the actual scripts as well. I have an installation set up with
your db and scripts for testing. The only thing is you would have to make
sure you work off the very latest CVS - wouldn't want to lose all the little
bits I have changed over the last month or so - noticed your config.php was
old - notices came up again.

I am yet to really understand the other table SerialisedStockMoves table
referencing the stockmoveto and stockmovefrom. i like your idea of retaining
the existing structure and having a sub level of data that keeps the
serialised record keeping in tact. I will get there ... without
understanding it intuitively I would prefer to record all movements of each
serialised item, in a separate table - I realise that this would be a busy
table. I just don't see how we could satisfy the requirements for
serialisable stock without it.

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 am sure you have thought of all this and as you will be able to tell I am
some way from understanding your system.

Phil