From: Phil D. <ph...@du...> - 2004-04-24 01:26:11
|
On Saturday 24 April 2004 12:24, jesse wrote: > Hum... let me remind you how I've put this together since it wasn't quite > like you had originally thought of doing it, and some of your answers seem > to be refering to your way rather than how I've coded it....from the top, > > A StockMaster record can be Controlled. If it is Controlled, it can also be > Serialised, but does not have to be. If it is Serialised, a StockModule is > required (that has no bearing on this discussion except that it's part of > my changes). Lastly, the *only* inventory table considered to be 1-to-1 is > StockItems - a StockMoves record could have a Qty of 1, thus being 1-to-1, > but just as easily could have Qty 0.1 (g when StockMaster.Units in kg) or > 100 (Cell Phones w/ SerialNos). Further, Serialised item Qtys are always > Integers - no decimal places. This has just made me remember I need to make > sure I enforce that everywhere! > > Controlled means that anytime a StockMove is being done, the User is > required to enter a Bundle(Id) for it - some sort of Id that can be used to > generally refer to the full Qty involved in that StockMove. That, so far, > entails POs, SOs, Stock Transfers, Stock Adjustments, Credits, ReverseGRNs, > and anything else I run upon that I missed. > But that doesn't really cover it for controlled. What about the sale of a quantity of oil that is in 10 drums - each drum containing 50 litres. Controlled but NOT serialised. The stock movement is for 500 litres, we would only want one stockmove under your scenario? We would need a bundleID referenced to this stockmove for all 10 drums. One bundleID, would only cut it if it were possible to enter multiple items of the same StockID on the same invoice - at the time of confirmDispatch_Invoice.php - maybe this is what you have in mind? One wouldn't want to be pre-allocating bundleids to orders before they are picked .... would you ? So shouldn't affect sales orders.... should it? Same with PO - only really affects the delivery - GoodsReceived.php. I will need to see it and play with it to fully get it I fear!! I am probably not that useful to bounce off coding issues on till I get into it. I do have views on the functionality we should code though, but only from a practical standpoint. Phil |