Item Adds/Changes Best Practice

You can also use PO115 to remove the these items from your templates. If you have new items that are replacing items to be inactivated you can use the PO115 and IC331 jobs to replace the old item with the new item.

I have Inactivated the Items from PO13.3. So now I checked in IC12 all the items Status is I. But in IC11 the status is A so do I have to changes in IC11 If it is right do let me know. And can anyone share what to select in Upload Add-ins for IC11?

The add in for inactivating the IC11 is only a few fields.

Item Group Item Status

Michelle

 

I was able to Inactive the Item In PO13.3 but IC12 In few of the Results after Upload it is showing Cannot Change; Item has stock on-hand at this location(_f16). Can anyone tell me what to do with this?

You need to either issue out the stock on hand or make the adjustment. There is still a GL value to the product you are removing and it needs to be resolved.

I have to correct an Item in PO13. I have to Active the Item again I inactivated the Wrong One is there any way to that and can any share the PO13.3 Upload procedure which options to select.

Can you plz tell me the procedure to make changes in Po13.3 for Item change while making changes in Add-inns like which field to select from in PO13.3

 

The key field here is the PT-PIV-VEN-ITEM.  This is the field to "Position To" the specific vendor item you want to change.

And One more question If an Items gets by mistake Inactive In PO13.3. So whats the procedure to Make it Active. Actually, there are 6 items that I have to make Active again. Can anyone Share the Procedure Plz?

Use V in the FC field to Activate.

How to Inactive the Items In IC11. I tried doing it but my result shows that f(0) can not found. Can anyone tell me what steps to follow and what I have to select while making changes in Add-ins.

Using Addins, to make IC11 records inactive. Using the IC table IC11.1

Company  (f3 ITE-ITEM-GROUP)

Item #       (f7 ITE-ITEM)

Status       (f37 ITE-ACTIVE-STATUS)   

 *you need to upload I into the status fields (I=Inactive)

 

 

So should I upload as change only or Add Only In Add-ins as I want to Inactive few of the Items In IC11.

Use Change only, that should change the Status code from A to I.

 

Hello all. To piggyback on this topic, what are everyones' approaches to item descriptions? We are working on an item master cleanup and I'd like to standardize how we name/give-description-to our items.

We have GHX's NuVia product so we use the "Memorial Optimized" that we designed with them many years ago. If they cannot identify an item/provide a description, we create one NOUN first followed by type then size/distinguishing attribute.

We use the same method, Noun, specific description, size. For the 1st Description, the Manufacturer # and Order UOM/QTY for the 2nd description, any other pertinent item information in the 3 Description field.

Ex;

Description:PATCH HERNIA KUGEL OVAL SMALL

Description2: 10101 CA/2

Description3: SELF-EXPANDING 3X4.6

 

I would caution you about using commas in the description.  We use Cerner as well and it seems that having commas in the descriptions causes issues when trying to run reports in Cerner.

Commas also eat valuable character space, but you also need to be wary of ' or " for foot or inch as well as & for any items that are going to be sent "downstream" to external systems. I did not mention - we have Description 2 as the "downstream" description where if they want it to say BALLOON [brand] 10x5.6 instead of CATH BALLOON - the feeds will use D2 first. Description 3 is for the full, gloriously unabbreviated, description

What's everyone's thoughts/processes on deleting items from an item master? We have SEVERAL items that were created during a conversion that have never been used and are just clutter. We are looking to 1.) delete unused items 2.) clean up descriptions on remaining items 3.) standardize when a new item is created vs changing an item. We don't deal in inventory: we mostly do large capital purchases. So, if a laptop model slightly changes (processor bump) do we enter a new item, or just update the item we've been using?

We keep the "VOID NO USAGE" items to prevent having to recreate them in the future and to have a trail. But it sounds like you don't have the problem of people asking for an item and then not using it/asking for it again - so yes, I'd delete the item the way I would any other "added in error" item. If an item is a non-stock and the UOM Conversion isn't changing, we will just change the existing item to the converted one. If it's in inventory or if the conversion factor is going to make PO History too weird, we give it a new item. "What impact does this have when looking at PO54?" is our standard then.

Hi everyone. Would anyone be willing to share the addins excel sheet to add lawson numbers to IC11, IC12,PO13,Po25? Looking for a mass upload. Thank you

I don't mind sharing - but for us, the excel sheet is documenting the process, so several of the columns never get loaded into Lawson and are not mapped at all.  Also - we're insane. :)  We are loading a ton of things that are likely unique to us.

 

We also don't load to PO13 and PO25 - we load with FC B(Both) to PO25.6 and it creates the PO13 record for us.

And the upload maps for the excel sheet are attached here (I was having issue with file size)  There are several maps for the various IC12s we upload to on the sheet - I'm just adding the one for the column marked "ERAD" that's our epic interface location.  We upload as Inventory Tracked N - you'd likely want to change that value.

Has anyone else encountered errors from their AP side when they are trying to pay for an item that has been inactivated in PO13? 

We currently change the IC11 to read INACTIVE (USE XXXXXX) and mark the record "I", and change all templates. We were inactivating in PO13, but it was causing fatal errors on the AP side, so now we wait until the invoices for all have been paid. But that makes it possible for people to try to requisition the item, who don't notice that the description says "Inactive", so they get annoyed because the order doesn't fill.