Item Long Descriptions in the Purchase Order

[ericsd]

We have a test installation of Maximo 7 and I'm trying to figure out it's capabilities.  Some of the complaints on our current Purchasing system is that the description fields are too small and the long description is not searchable.

Is the item long description searchable and more importantly, can it be printed on the purchase order?

Thanks!

[Ethen]

long description is a seperate table known as longdescription in Maximo. unfortunately to my knowledge this field is not searchable because in maximo only parent object fields are searchable. thought for convenience you can increase the length of description (also known as short description field) in PO so they can enter some more data in there..

As for printability is concerned Yes its printable provided you use proper joins in the table.

[mkb]

The long description is searchable if you have access to the WHERE clause. This can be found on the advanced search tab from the inventory list screen. The WHERE clause to get you to the long description requires a 3 table join. Below is a sample that will search the long description. By changing test to the phrase your will be looking for, you will be searching for your phrase anywhere in the long description.

WHERE inventory.itemnum IN (SELECT itemnum FROM item WHERE itemid  IN (SELECT ldkey FROM longdescription WHERE ownertable=’item’ AND ldtext like ‘%test%’))

[Ethen]

he he he.. 
I didnt think of this long approach. but yeah It would give u results.

[Angie]

I put the Long Description field in Advanced Search and can search that way.

[Yesterday]

• Not able to access the ma... by Dileep Kumar [Yesterday at 06:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]
• Enabling Attachment on CL... by G Jeevan [May 11, 2012, 12:24:33 pm]
• Data insertion in Work Or... by Sarbjeet.Jassal [May 09, 2012, 09:06:53 am]
• Want userdefined name whi... by G Jeevan [May 08, 2012, 10:43:40 am]
• my newly created continio... by G Jeevan [May 08, 2012, 10:41:22 am]
• All User Account unable t... by bphome [May 03, 2012, 05:09:47 pm]