From: "ExsonQu" <hexinfans-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
To: web-erp-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Sent: Sunday, July 29, 2012 9:45:26 AM
Subject: Re: [webERP-users] Bin management for inventory

*Dear all:*

         Thank you for your nice support!

         We've got a proposal for this project.  After refer to the
specification at this link:
http://www.weberp.org/Old_Site/WareHouseManagementDiscussion
http://www.weberp.org/Old_Site/WareHouseManagementDiscussion , we did some
modification as following:
           In maintenance section, we'll maintain four tables as warehouse
area maintenance. We add an area allocation feature for users to handle such
as finish goods area, materials area; or temporary area, defect goods area;
waiting for dispatching etc. That means  we'll have area->rack->row->bin
instead of rack->row-bin.
           The table for area is as following:
                                                  areacode        var(10)   Primary
key
                                                  loccode        varchar(5)  refer
to locations
                                                  areaname        varchar(30)

           Then another table for rack:

                                                rackid        int(5) auto increment
                                                rackcode        var(10)  
                                                areacode        varchar(2) refer to
area tables
                                                unique key(rackid, areacode)        

           and a table for row:

                                                rowid        int(10) auto increment
                                                rackid        refer to racks
                                                rowcode        varchar(10)
                                                unique key(rackid, rowcode)        

          And last table for bin:
                                                binid        int(11) auto increment
                                                bincode varchar(10)        
                                                rowid        refer to rows
                                                unique(bincode,rowid)        
          So we'll have a unique binid for each bin in a ware house.
Although there is a little chance to adjust the layout of warehouse, we
still need prepare a tool to change the bins for users.

          Since the binid is relative stable, so we'll revise the
stock_locator table as following:

                                              binid        int(11) refer to bin
                                              stockid        varchar(20) refer to
stockmaster
                                              quantity        double

         For binmove table, I'm suspect if we need to keep this table. I
think stockmoves provide enough traceability. If we should keep this table,
the meaning for this table is goods transfer within one warehouse, the moves
between different area as we setting now.

                                      table binmoves                        
                                              stkitmoveno int(11)
                                              stockid varchar(20)
                                              binid int(11) refer to bin
                                              moveqty double
                                              trandate  date

           if we need to keep tracking or bin moves, we'll add the
stockmovesno to above table. But we maybe should not refer to stockmoves,
since the transfer within one warehouse should not be kept.
                

          Any comments are highly appreciated!

          Best regards!

          Exson

    


            





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Bin-management-for-inventory-tp4655446p4655464.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
web-ERP-users mailing list
web-ERP-users-5NWGOfrQmnegEbju0hdhLg@public.gmane.orgorge.net
https://lists.sourceforge.net/lists/listinfo/web-erp-users