Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Andrew G. <aga...@re...>]

Exson,
Is there any update on this work?
I am considering adding a simple function to  allow this separation of pick/pack/invoice but I do not want to do the work if you have already done it.

Best Regards,
Andrew Galuski
ResMart LLC.
817.615.2038 (Office)
817.821.0544 (Cell)
www.resmart.com


-----Original Message-----
From: ExsonQu [mailto:hex...@gm...] 
Sent: Thursday, May 29, 2014 3:42 AM
To: web...@li...
Subject: Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Andrew Galuski] 

Dear Andrew and Bob,

           Thank you for your comments. 

            But I'm still feel uncertain of this solution. It's not so simple and powerful to meet webERP's style.  I've coded part of them and we've developing a similar solution for a client. But it seems not so generic. 

            The purpose of this feature is to improve the communication between sales and warehouse, accountant and warehouse. 
            The original one in webERP now from Tim has provide a very smart solution. The weak point is that there is no place for warehouse to provide the picked items data. 
            A simple solution maybe like this: 

            1. System automatically create a batch of Picking lists according to some rules. The most important data is Serial/Batch No, A FIFO rules maybe followed. But sometime this cannot be followed for those warehouse keeping not so great, to pick according to serial no will be quite time consuming. 
            2. Then warehouse people can modify those auto generated one to confirm it. 
            3. Sales or accountants invoice it according to the confirmed invoice. 
            
             Any idea are appreciated! 

              Best regards! 

              Exson



*Dear all,*

       I've prepared a table schema.  The work flow is the sales can create a Picking Request to Warehouse, the pr can includes multiple orders order lines. The only limit that they must be delivery from same location. The warehouse can pick after the pr is approved. When the pr is fulfilled, sales(A/R client) can invoice from these fulfilled pr. The pr can be fulfilled several times.

       Any comments are welcome!

       
        

           CREATE table pickrequest (prid int not null,
			initiator varchar(20) not null default '',
			initdate date not null default '0000-00-00',
			approvedate date not null default '0000-00-00',
			status varchar(12) not null default '',
			comments text default null,
			closed tinyint not null default '0',
			loccode varchar(5) not null default '',
			PRIMARY KEY (`prid`),
			key (`initiator`),
			key (`initdate`),
			key (`requestdate`),
			CONSTRAINT FOREIGN KEY(`loccode`) REFERENCES `locations`(`loccode`)) Engine=InnoDB DEFAULT CHARSET=utf8;

CREATE table pickrequestdetails (detailno int not null auto_increment,
	                         prid int not null default '1',
				orderno int not null default '1',
				orderlineno int not null default '0',
				stockid varchar(20) not null default '',
				qtyexpected double not null default '0',
				qtypicked double not null default '0',
				invoicedqty double not null default '0',
				shipqty double not null default '0',
				completed tinyint not null default '0',
				requestdate date not null default '0000-00-00',
				PRIMARY KEY (`detailno`),
				key (`prid`),
				key (`orderno`),
				key (`pickdate`),
				key (`shipdate`),
				constraint foreign key (`stockid`) REFERENCES stockmaster(`stockid`),
				constraint foreign key (`orderno`) REFERENCES salesorders(`orderno`),
				constraint foreign key (`prid`) REFERENCES pickrequest(`prid`))Engine=InnoDB DEFAULT CHARSET=utf8; CREATE table pickfulfill (pickno int not null auto_increment,
			   detailno int not null default '0',
			   stockid varchar(20) not null default '',
			   pickqty double not null default '0',
			   invoqty double not null default '0',
			   shipqty double not null default '0',
			   pickdate date not null default '0000-00-00',
			   invodate date not null default '0000-00-00',
			   shipdate date not null default '0000-00-00',
			   pickby varchar(20) not null default '',
			   shipby varchar(20) not null default '',
			   PRIMARY KEY (`pickno`),
			   KEY (`detailno`),
			   KEY (`pickdate`),
			   KEY (`shipdate`),
			   KEY (`invodate`),
			   CONSTRAINT FOREIGN KEY (`stockid`) REFERENCES stockmaster(`stockid`),
			   CONSTRAINT FOREIGN KEY (`detailno`) REFERENCES pickrequestdetails(`detailno`))Engine=InnoDB DEFAULT CHARSET=utf8;
				
	

CREATE table pickserialmoves (serialmoveid int not null auto_increment,
				pickno int not null default '0',
				stockid varchar(20) not null default '',
				serialno varchar(30) not null default '',
				moveqty double not null default '0',
				PRIMARY KEY (`serialmoveid`),
				key (`pickno`),
				key (`stockid`,`serialno`),
				key (`serialno`),
				CONSTRAINT FOREIGN KEY (`pickno`) REFERENCES pickfullfill(`pickno`),
				CONSTRAINT FOREIGN KEY (`stockid`,`serialno`) REFERENCES `stockserialitems`(`stockid`,`serialno`))Engine=InnoDB DEFAULT CHARSET=utf8;

Best regards!

Exson





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657484.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Time is money. Stop wasting it! Get your web API in 5 minutes.
www.restlet.com/download
http://p.sf.net/sfu/restlet
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers