Re: [Web-erp-developers] Serialised stock - how to code this up

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

>
>
>Only "assembly" item BOMs - manufacturing items would of course need BOMs
>that contain serialised items. Assembly items are just ghosted codes that
>refer to a final assembly put together by the pickers rather than
>manufacturing - there is no opportunity to enter serial numbers for the
>components in this situation.
>  
>
ok, I think I need to look over how all those types work again...

>
>I'm coming round .... but still need a little more flesh on the idea ...
>sorry:
> - what would this subsidiary serialstockmoves table look like?
>  
>
Like the StockItemMoves table I sent you in those diffs. It would not 
hold a record for the inital move (in stockmoves and breaks ref. 
integrity), and would hole the item#,orig_stkmove, and new_stkmove .

> - how would the system deal with lots and batches?
>  
>
non controlled, non serialised item - no conept of batches at all - 
StockMoves.Bundles defaults to 1
controlled, non serialised item - bundle serves as an id for a stock 
move. The move maybe for, say, 25 items...maybe hundreds. That can count 
as a Lot, right?

> - would there be any control on quantities in batches/lots/bundles or could
>these be any amount?
>  
>
Any amount  for now.  If needed, it could be a StockMaster field and 
something like 0 or -1 could be unlimited. Alternatively, this could be 
implemented in a Sales or Product Catalog that 'templates' the contents 
of a StockMove like a BOM does. That would, I believe, require the 
Catalog to be setup and used separate of the StockMaster... still 
something I'm thinking about.

> - Don't understand you templatey idea?
>  
>
Do you mean the above, my plan on how to allow easy extension of 
stockitem details, or the original mention of using templates for pages. 
No worries on the last, the middle is better explained once I have code 
written...

> - how do we display all the serial numbers of items on hand at any one time?
>  
>
I realized this a while ago as well. All Items will have their current 
StockMove associated with them in their table - upkeep necessary during 
adds/moves/etc. I figure to select on-hand items the base criteria will 
be based on selecting a set of StockMoves with appropriate SysTypes, 
then selecting Items still tagged with those StockMoves. Do you know the 
SysTypes necessary without me digging around to find them?

> - how do we display on invoices the serial numbers of items sold - if we
>wanted to ?
>  
>
This can be an option specified in the StockMaster table, in 
StockModules, or even at the time of printing/viewing the invoice, and a 
combination of those...I also forsee situations like I have where I want 
to invoice someone for 50,000 cards on a regular invoice (obviously 
without serialised line items) and have the option to provide/retrieve 
the invoice detail in some other format, say a csv list of serial 
numbers and possibly other data that can be sent to a customer for their 
own inventory requirements.