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

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

I like this.  1 Comment, Currently there is a pick list function - I am not 100% sure it works but it attempts to do something similar.  This should probably be disabled or replaced with this.  The output of that function is very nice though - something similar should be available for picking in the warehouse.  Also - another document (same format ok) but called Packing List should be able to be generated based on what is picked (including lot/serial)

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

*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