Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Picking List: only the first item of an order is printed
01-14-2018, 11:56 PM
Post: #26
RE: Picking List: only the first item of an order is printed
Obviously pickserialdetails had no equivalent table before so should probably be empty, I would fill the other two tables as follows (Note this is not an exact science but should give us everything we need - though I wouldn't drop the other tables just yet)

CREATE table pickreq (
prid int not null auto_increment, --> pickinglists.pickinglistno
initiator varchar(20) not null default '', -> ''
shippedby varchar(20) not null default '', -> ''
initdate date not null default '0000-00-00', -> -> pickinglists.dateprinted
requestdate date not null default '0000-00-00', > pickinglists.pickinglistdate
shipdate date not null default '0000-00-00', -> pickinglists.deliverynotedate
status varchar(12) not null default '', -> ''
comments text default null, -> ''
closed tinyint not null default '0', (if pickinglistdetails.qtyexpected = pickinglistdetails.qtypicked then 1 else 0)

CREATE table pickreqdetails (
detailno int not null auto_increment, -> pickinglistdetails.pickinglistlineno
prid int not null default '1', -> pickinglistdetails.pickinglistno
orderlineno int not null default '0', -> pickinglistdetails.orderlineno
stockid varchar(20) not null default '', (salesorderdeails.stkcode WHERE orderno = pickinglists.orderno AND orderlineno = pickinglistdetails.orderlineno)
qtyexpected double not null default '0', -> pickinglistdetails.qtyexpected
qtypicked double not null default '0', -> pickinglistdetails.qtypicked
invoicedqty double not null default '0', -> pickinglistdetails.qtypicked
shipqty double not null default '0', -> pickinglistdetails.qtypicked
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Picking List: only the first item of an order is printed - falkoner - 01-14-2018 11:56 PM

Forum Jump:


User(s) browsing this thread: 4 Guest(s)