This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Does anyone have the code for the standard POPRINT report, with the PR Line Long Description included? I'm trying to add it, but getting errors.
Thanks.
Shannon
Shannon,
Here is what I am using. This is the sqlText for my polineDataSet and
it works well. I highlighted what I think are the key lines since I
have extra fields.
sqlText = ""
+ " select poline.polinenum, poline.catalogcode, poline.itemnum,
poline.manufacturer, poline.glcreditacct, poline.gldebitacct, "
+ " poline.conditioncode, po.currencycode,poline.description,
po.totalcost, poline.loadedcost, poline.polineid, "
+ " poline.orderqty, poline.orderunit, poline.modelnum,
poline.unitcost, poline.plin1, poline.requestedby, "
+ " poline.linecost, po.inclusive1, poline.linecost, poline.tax1,
poline.refwo, poline.issue, poline.category, poline.storeloc, "
+ " address.address1 as siteaddr1, address.address2 as siteaddr2,
address.description as siteaddrdescription,"
+ " address.address3 as siteaddr3, address.address4 as siteaddr4,
po.shipto, longdescription.ldtext lineld, prline.prnum,
prline.description prlinedesc, "
+ " (select longdescription.ldtext from longdescription where
longdescription.ldownertable = 'PRLINE' and longdescription.ldownercol =
'DESCRIPTION' and prline.prlineid = longdescription.ldkey) prlineld, "
+ " (Select inventory.binnum from inventory where
inventory.itemnum = poline.itemnum and poline.storeloc =
inventory.location and poline.siteid = inventory.siteid) as binnum "
+ " from (po left outer join address on po.shipto =
address.addresscode and po.orgid = address.orgid), poline "
+ " LEFT OUTER JOIN SITE ON POLINE.TOSITEID = SITE.SITEID AND
POLINE.ORGID = SITE.ORGID "
+ " LEFT OUTER JOIN longdescription on longdescription.ldownertable =
'POLINE' and longdescription.ldownercol = 'DESCRIPTION' and
poline.polineid = longdescription.ldkey "
+ " LEFT OUTER JOIN prline ON POLINE.POLINEID = PRLINE.POLINEID AND
POLINE.SITEID = PRLINE.SITEID AND POLINE.ORGID = SITE.ORGID "
+ " where po.ponum = poline.ponum"
+ " and po.siteid=poline.siteid"
+ " and po.siteid = '" + rows[0]["siteid"] + "'"
+ " and po.ponum = '" + rows[0]["ponum"].replace(/'/g,"''") + "'"
+ " order by poline.polinenum"
;
Bruce
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
Of shannonrotz
Sent: Tuesday, July 26, 2011 12:50 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] PR Line Long Description - BIRT
Does anyone have the code for the standard POPRINT report, with the PR
Line Long Description included? I'm trying to add it, but getting
errors.
Thanks.
Shannon
Thanks Bruce ... I was using something similar, but for some reason I'm getting "unhandled exception when executing the script." Needless to say, this is annoying :(
Shannon
--- In MAXIMO@yahoogroups.com, "Summers, Bruce" <bsummers@...> wrote:
>
> Shannon,
>
>
>
> Here is what I am using. This is the sqlText for my polineDataSet and
> it works well. I highlighted what I think are the key lines since I
> have extra fields.
>
>
>
> sqlText = ""
>
> + " select poline.polinenum, poline.catalogcode, poline.itemnum,
> poline.manufacturer, poline.glcreditacct, poline.gldebitacct, "
>
> + " poline.conditioncode, po.currencycode,poline.description,
> po.totalcost, poline.loadedcost, poline.polineid, "
>
> + " poline.orderqty, poline.orderunit, poline.modelnum,
> poline.unitcost, poline.plin1, poline.requestedby, "
>
> + " poline.linecost, po.inclusive1, poline.linecost, poline.tax1,
> poline.refwo, poline.issue, poline.category, poline.storeloc, "
>
> + " address.address1 as siteaddr1, address.address2 as siteaddr2,
> address.description as siteaddrdescription,"
>
> + " address.address3 as siteaddr3, address.address4 as siteaddr4,
> po.shipto, longdescription.ldtext lineld, prline.prnum,
> prline.description prlinedesc, "
>
> + " (select longdescription.ldtext from longdescription where
> longdescription.ldownertable = 'PRLINE' and longdescription.ldownercol =
> 'DESCRIPTION' and prline.prlineid = longdescription.ldkey) prlineld, "
>
> + " (Select inventory.binnum from inventory where
> inventory.itemnum = poline.itemnum and poline.storeloc =
> inventory.location and poline.siteid = inventory.siteid) as binnum "
>
> + " from (po left outer join address on po.shipto =
> address.addresscode and po.orgid = address.orgid), poline "
>
> + " LEFT OUTER JOIN SITE ON POLINE.TOSITEID = SITE.SITEID AND
> POLINE.ORGID = SITE.ORGID "
>
> + " LEFT OUTER JOIN longdescription on longdescription.ldownertable =
> 'POLINE' and longdescription.ldownercol = 'DESCRIPTION' and
> poline.polineid = longdescription.ldkey "
>
> + " LEFT OUTER JOIN prline ON POLINE.POLINEID = PRLINE.POLINEID AND
> POLINE.SITEID = PRLINE.SITEID AND POLINE.ORGID = SITE.ORGID "
>
> + " where po.ponum = poline.ponum"
>
> + " and po.siteid=poline.siteid"
>
> + " and po.siteid = '" + rows[0]["siteid"] + "'"
>
> + " and po.ponum = '" + rows[0]["ponum"].replace(/'/g,"''") + "'"
>
> + " order by poline.polinenum"
>
> ;
>
>
>
> Bruce
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
> Of shannonrotz
> Sent: Tuesday, July 26, 2011 12:50 PM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] PR Line Long Description - BIRT
>
>
>
>
>
> Does anyone have the code for the standard POPRINT report, with the PR
> Line Long Description included? I'm trying to add it, but getting
> errors.
>
> Thanks.
>
> Shannon
>
>
>
>
>
>
>
Never mind ... I'm an idiot. I forgot to put ldtext in the "select" clause!
Shannon
--- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@...> wrote:
>
> Thanks Bruce ... I was using something similar, but for some reason I'm getting "unhandled exception when executing the script." Needless to say, this is annoying :(
>
>
> Shannon
>
> --- In MAXIMO@yahoogroups.com, "Summers, Bruce" <bsummers@> wrote:
> >
> > Shannon,
> >
> >
> >
> > Here is what I am using. This is the sqlText for my polineDataSet and
> > it works well. I highlighted what I think are the key lines since I
> > have extra fields.
> >
> >
> >
> > sqlText = ""
> >
> > + " select poline.polinenum, poline.catalogcode, poline.itemnum,
> > poline.manufacturer, poline.glcreditacct, poline.gldebitacct, "
> >
> > + " poline.conditioncode, po.currencycode,poline.description,
> > po.totalcost, poline.loadedcost, poline.polineid, "
> >
> > + " poline.orderqty, poline.orderunit, poline.modelnum,
> > poline.unitcost, poline.plin1, poline.requestedby, "
> >
> > + " poline.linecost, po.inclusive1, poline.linecost, poline.tax1,
> > poline.refwo, poline.issue, poline.category, poline.storeloc, "
> >
> > + " address.address1 as siteaddr1, address.address2 as siteaddr2,
> > address.description as siteaddrdescription,"
> >
> > + " address.address3 as siteaddr3, address.address4 as siteaddr4,
> > po.shipto, longdescription.ldtext lineld, prline.prnum,
> > prline.description prlinedesc, "
> >
> > + " (select longdescription.ldtext from longdescription where
> > longdescription.ldownertable = 'PRLINE' and longdescription.ldownercol =
> > 'DESCRIPTION' and prline.prlineid = longdescription.ldkey) prlineld, "
> >
> > + " (Select inventory.binnum from inventory where
> > inventory.itemnum = poline.itemnum and poline.storeloc =
> > inventory.location and poline.siteid = inventory.siteid) as binnum "
> >
> > + " from (po left outer join address on po.shipto =
> > address.addresscode and po.orgid = address.orgid), poline "
> >
> > + " LEFT OUTER JOIN SITE ON POLINE.TOSITEID = SITE.SITEID AND
> > POLINE.ORGID = SITE.ORGID "
> >
> > + " LEFT OUTER JOIN longdescription on longdescription.ldownertable =
> > 'POLINE' and longdescription.ldownercol = 'DESCRIPTION' and
> > poline.polineid = longdescription.ldkey "
> >
> > + " LEFT OUTER JOIN prline ON POLINE.POLINEID = PRLINE.POLINEID AND
> > POLINE.SITEID = PRLINE.SITEID AND POLINE.ORGID = SITE.ORGID "
> >
> > + " where po.ponum = poline.ponum"
> >
> > + " and po.siteid=poline.siteid"
> >
> > + " and po.siteid = '" + rows[0]["siteid"] + "'"
> >
> > + " and po.ponum = '" + rows[0]["ponum"].replace(/'/g,"''") + "'"
> >
> > + " order by poline.polinenum"
> >
> > ;
> >
> >
> >
> > Bruce
> >
> > From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
> > Of shannonrotz
> > Sent: Tuesday, July 26, 2011 12:50 PM
> > To: MAXIMO@yahoogroups.com
> > Subject: [MAXIMO List] PR Line Long Description - BIRT
> >
> >
> >
> >
> >
> > Does anyone have the code for the standard POPRINT report, with the PR
> > Line Long Description included? I'm trying to add it, but getting
> > errors.
> >
> > Thanks.
> >
> > Shannon
> >
> >
> >
> >
> >
> >
> >
>
We have all been there before. :-)
Wes Williams
http://www.williamsconnell.com
________________________________
From: shannonrotz <shannonrotz@yahoo.ca>
To: MAXIMO@yahoogroups.com
Sent: Tuesday, July 26, 2011 4:26 PM
Subject: Re: [MAXIMO List] PR Line Long Description - BIRT
Never mind ... I'm an idiot. I forgot to put ldtext in the "select" clause!
Shannon
--- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@...> wrote:
>
> Thanks Bruce ... I was using something similar, but for some reason I'm getting "unhandled exception when executing the script." Needless to say, this is annoying :(
>
>
> Shannon
>
> --- In MAXIMO@yahoogroups.com, "Summers, Bruce" <bsummers@> wrote:
> >
> > Shannon,
> >
> >
> >
> > Here is what I am using. This is the sqlText for my polineDataSet and
> > it works well. I highlighted what I think are the key lines since I
> > have extra fields.
> >
> >
> >
> > sqlText = ""
> >
> > + " select poline.polinenum, poline.catalogcode, poline.itemnum,
> > poline.manufacturer, poline.glcreditacct, poline.gldebitacct, "
> >
> > + " poline.conditioncode, po.currencycode,poline.description,
> > po.totalcost, poline.loadedcost, poline.polineid, "
> >
> > + " poline.orderqty, poline.orderunit, poline.modelnum,
> > poline.unitcost, poline.plin1, poline.requestedby, "
> >
> > + " poline.linecost, po.inclusive1, poline.linecost, poline.tax1,
> > poline.refwo, poline.issue, poline.category, poline.storeloc, "
> >
> > + " address.address1 as siteaddr1, address.address2 as siteaddr2,
> > address.description as siteaddrdescription,"
> >
> > + " address.address3 as siteaddr3, address.address4 as siteaddr4,
> > po.shipto, longdescription.ldtext lineld, prline.prnum,
> > prline.description prlinedesc, "
> >
> > + " (select longdescription.ldtext from longdescription where
> > longdescription.ldownertable = 'PRLINE' and longdescription.ldownercol =
> > 'DESCRIPTION' and prline.prlineid = longdescription.ldkey) prlineld, "
> >
> > + " (Select inventory.binnum from inventory where
> > inventory.itemnum = poline.itemnum and poline.storeloc =
> > inventory.location and poline.siteid = inventory.siteid) as binnum "
> >
> > + " from (po left outer join address on po.shipto =
> > address.addresscode and po.orgid = address.orgid), poline "
> >
> > + " LEFT OUTER JOIN SITE ON POLINE.TOSITEID = SITE.SITEID AND
> > POLINE.ORGID = SITE.ORGID "
> >
> > + " LEFT OUTER JOIN longdescription on longdescription.ldownertable =
> > 'POLINE' and longdescription.ldownercol = 'DESCRIPTION' and
> > poline.polineid = longdescription.ldkey "
> >
> > + " LEFT OUTER JOIN prline ON POLINE.POLINEID = PRLINE.POLINEID AND
> > POLINE.SITEID = PRLINE.SITEID AND POLINE.ORGID = SITE.ORGID "
> >
> > + " where po.ponum = poline.ponum"
> >
> > + " and po.siteid=poline.siteid"
> >
> > + " and po.siteid = '" + rows[0]["siteid"] + "'"
> >
> > + " and po.ponum = '" + rows[0]["ponum"].replace(/'/g,"''") + "'"
> >
> > + " order by poline.polinenum"
> >
> > ;
> >
> >
> >
> > Bruce
> >
> > From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
> > Of shannonrotz
> > Sent: Tuesday, July 26, 2011 12:50 PM
> > To: MAXIMO@yahoogroups.com
> > Subject: [MAXIMO List] PR Line Long Description - BIRT
> >
> >
> >
> >
> >
> > Does anyone have the code for the standard POPRINT report, with the PR
> > Line Long Description included? I'm trying to add it, but getting
> > errors.
> >
> > Thanks.
> >
> > Shannon
> >
> >
> >
> >
> >
> >
> >
>
It would be helpful to have a more descriptive error message – sort of reminds me of the classic “null pointer exception”. Gee, thanks again, Java …
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of wwilliams@rocketmail.com
Sent: July-26-11 3:13 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] PR Line Long Description - BIRT
We have all been there before. :-)
Wes Williams
http://www.williamsconnell.com
________________________________
From: shannonrotz <shannonrotz@yahoo.ca <mailto:shannonrotz%40yahoo.ca> >
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Sent: Tuesday, July 26, 2011 4:26 PM
Subject: Re: [MAXIMO List] PR Line Long Description - BIRT
Never mind ... I'm an idiot. I forgot to put ldtext in the "select" clause!
Shannon
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> , "shannonrotz" <shannonrotz@...> wrote:
>
> Thanks Bruce ... I was using something similar, but for some reason I'm getting "unhandled exception when executing the script." Needless to say, this is annoying :(
>
>
> Shannon
>
> --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> , "Summers, Bruce" <bsummers@> wrote:
> >
> > Shannon,
> >
> >
> >
> > Here is what I am using. This is the sqlText for my polineDataSet and
> > it works well. I highlighted what I think are the key lines since I
> > have extra fields.
> >
> >
> >
> > sqlText = ""
> >
> > + " select poline.polinenum, poline.catalogcode, poline.itemnum,
> > poline.manufacturer, poline.glcreditacct, poline.gldebitacct, "
> >
> > + " poline.conditioncode, po.currencycode,poline.description,
> > po.totalcost, poline.loadedcost, poline.polineid, "
> >
> > + " poline.orderqty, poline.orderunit, poline.modelnum,
> > poline.unitcost, poline.plin1, poline.requestedby, "
> >
> > + " poline.linecost, po.inclusive1, poline.linecost, poline.tax1,
> > poline.refwo, poline.issue, poline.category, poline.storeloc, "
> >
> > + " address.address1 as siteaddr1, address.address2 as siteaddr2,
> > address.description as siteaddrdescription,"
> >
> > + " address.address3 as siteaddr3, address.address4 as siteaddr4,
> > po.shipto, longdescription.ldtext lineld, prline.prnum,
> > prline.description prlinedesc, "
> >
> > + " (select longdescription.ldtext from longdescription where
> > longdescription.ldownertable = 'PRLINE' and longdescription.ldownercol =
> > 'DESCRIPTION' and prline.prlineid = longdescription.ldkey) prlineld, "
> >
> > + " (Select inventory.binnum from inventory where
> > inventory.itemnum = poline.itemnum and poline.storeloc =
> > inventory.location and poline.siteid = inventory.siteid) as binnum "
> >
> > + " from (po left outer join address on po.shipto =
> > address.addresscode and po.orgid = address.orgid), poline "
> >
> > + " LEFT OUTER JOIN SITE ON POLINE.TOSITEID = SITE.SITEID AND
> > POLINE.ORGID = SITE.ORGID "
> >
> > + " LEFT OUTER JOIN longdescription on longdescription.ldownertable =
> > 'POLINE' and longdescription.ldownercol = 'DESCRIPTION' and
> > poline.polineid = longdescription.ldkey "
> >
> > + " LEFT OUTER JOIN prline ON POLINE.POLINEID = PRLINE.POLINEID AND
> > POLINE.SITEID = PRLINE.SITEID AND POLINE.ORGID = SITE.ORGID "
> >
> > + " where po.ponum = poline.ponum"
> >
> > + " and po.siteid=poline.siteid"
> >
> > + " and po.siteid = '" + rows[0]["siteid"] + "'"
> >
> > + " and po.ponum = '" + rows[0]["ponum"].replace(/'/g,"''") + "'"
> >
> > + " order by poline.polinenum"
> >
> > ;
> >
> >
> >
> > Bruce
> >
> > From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf
> > Of shannonrotz
> > Sent: Tuesday, July 26, 2011 12:50 PM
> > To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> > Subject: [MAXIMO List] PR Line Long Description - BIRT
> >
> >
> >
> >
> >
> > Does anyone have the code for the standard POPRINT report, with the PR
> > Line Long Description included? I'm trying to add it, but getting
> > errors.
> >
> > Thanks.
> >
> > Shannon
> >
> >
> >
> >
> >
> >
> >
>