Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Picking List: only the first item of an order is printed
01-14-2018, 11:56 PM,
#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
Reply


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

Forum Jump:


Users browsing this thread: 1 Guest(s)