Maximo Open Forum

 View Only

 Condition code in Item Master vendor (INVVENDOR Table)

  • Inventory
  • Procurement
Robin Sons's profile image
Robin Sons posted 02-29-2024 05:34

Dear community, I wonder if anyone knows this behaviour. 

When an item is selected in a purchase order, some information will be derived from the item master (INVVENDOR table)

I am facing an issue, where when the user selects the condition code on the purchase order, the catalog number will be deleted. I then find out, that in the table INVVENDOR, there is in fact a column "Condition Code" in the table INVVENDOR, but this field does not exist on the GUI. 

Anyone know, where this field exists actually? or do we need a customization for this?

Also, can the behaviour of taking information from item master into the purchase order line disabled?

Thanks,

Robin

Travis Herron's profile image
Travis Herron

If the Item is condition enabled, you'll want to make your INVVENDOR entries to include the Condition Code, e.g. I can buy the Widget from VendorX for $20 in NEW condition, or $15 in PREOWNED condition.

The CONDITIONCODE field exists on the INVVENDOR table, as you said, so just go into Application Designer and add it to the GUI, wherever needed -- Item Master, Tools, Inventory, Stocked Tools, Receiving, Purchase Orders, Purchase Requisitions, Materials Requisitions, Invoices, maybe others too.

You shouldn't want to disable the functionality.  If you're spending the extra effort to make the Item condition enabled and configuring the available conditions for that item, then when you buy that item you'd need to also know the condition. This has ramifications for how much it costs, how it affects your inventory average costs, the quantity you have in-stock in any of the available conditions, the cost that is charged to a Work Order when you use that item, etc.

Michael Marsonet's profile image
Michael Marsonet

Robin,

Interesting that the Condition Code is not visible in the GUI as out of the box it is there on PO Lines, Inventory (Vendors under 'Reorder Details' tab) and many other applications. It is possible that someone removed them or hide them from the UI. 

You mention that when the condition code is selected on the Purchase Order (I'm assuming PO Line), the catalog number is deleted, this is because it is being pulled from the INVVENDOR table as you see and the catalog number is likely null which is over-writing the value on the PO Line. You can verify this as well from the GUI by going to the Inventory for the application, Reorder Details tab and expand the Vendor's table/section. Find the Vendor with the Condition code and you will likely notice the catalog number is blank and this is why it is overwriting/deleting the value on the POLine. If you re-enter the catalog # it will save it to the INVVENDOR table for the next time I believe. 

Mike