From: Daintree F. <p.d...@xt...> - 2003-08-22 22:36:02
|
Hi Richard, This looks like a great development. In principle my personal preference is one integrated application in preference to two. Serialising the stock needs modifications to all areas that produce stock movements: -invocing -crediting -receiving, -adjusting, -transfers. > In Web-Erp > - On the StockMaster add a field to indicate that Serial Numbers are > required for this item. From here on all comments below apply only > to such items. There is such a flag - its a little cryptically named "controlled". It is not currently used for any other purpose and to flag serialised or lot control was the intention. > Goods Received [TBD Where is this in Web-ERP?] Select an Outstanding purchase order and hit the receive link. Point well made though. > -------------- > In Web-Erp > - In Goods Received, on the header of a Receiving Note, when receiving a > known purchase order, a button leads to the import of the updated XML > file. This creates the Receiving line items as well as adding lines to > the new StockSerialNo Table. > [TBD - Is there a post/commit stage for the PO that could be expanded] > I would like to build functionality to enable this data to be keyed too. On the receiving of controlled items a further step is required to enter the serial numbers lots or batches of the stock received, that then reconciles to the total received. > ============================================================================ > Sales Order > ----------- > > Outside Web-Erp > - The the serial number collection App will create a new XML file for a > customer sale. > > -------------------------------------------------------------------------- -- > In Web-Erp > - In Sales Order Entry a button leads to the import of an XML file. > This creates the Sales Order line items as well as updating the New > StockSerialNo Table. > [TBD - Is there a post/commit stage for the SO that could be expanded] > ============================================================================ The order -> invoice cycle is a two stage process, the order is created, packing slip printed, order picked, packing slip comes back with quantities dispatched, order confirmed with quantites dispatched and invoice produced. Maybe the order doesn't need the serial number on it, but there is a need to record the serial numbers of the items picked? This would be part of the order confirmation then to spell out the serial numbers of the items picked. Could these confirmations be done with the aid of a bar code reader which read off the serial numbers of the items picked that perhaps had a tear off sticky bar code that could be stuck too the office copy of the packing slip ?? Not entirely sure what the aims are. > Stock Take > ---------- > > Outside Web-Erp > - The the serial number collection App will create a new XML file for a > Stock Take. > > -------------------------------------------------------------------------- -- > In Web-Erp > - In Stock Take [TBD Where is this in Web-ERP?] a button leads to the > import of an XML file. This updates StockSerialNo.LastStockTakeDate > ============================================================================ There is no stock check functionality in web-erp (as yet) - maybe this comes before serialisation! Just my 2c Phil |