2 vendor items set as default in PO13.3

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1348
Roger French	1311
mark.cook	1244

Bev Edwards

Veteran Member

Posts: 366

4/23/2014 7:36 PM

One of our items somehow was set to have 2 vendor items as the default. Lawson will not allow me to inactivate or delete either one.
When I attempt to delete, I get a message saying "another vendor item must be set as default."
When I try to inactivate, the action is not allowed because I'm trying to inactivate an item set as a default item.

Anyone ever run into this?

See attachment...

Attachments

2_ven_items_set_as_default.docx

Stephanie

Veteran Member

Posts: 86

4/23/2014 7:45 PM

Hi Bev,

We temporarily had the same issue in our system and thankfully there were only 4 records that were affected. Lawson had us install a new CTP and instructed us to create a paint screen to correct the records. This was the only way to fix the issue in my experience.

Hope this helps!

Stephanie

Bev Edwards

Veteran Member

Posts: 366

4/23/2014 7:54 PM

Yep, that helps!

Kinda what I thought would be the fix.

Thank you!!

Kat V

Veteran Member

Posts: 1020

4/23/2014 7:59 PM

I've had some success replacing the items with "AAAAAA" and then inactivating the "new" value.

The Alchemist

Advanced Member

Posts: 34

4/23/2014 8:07 PM

We had the same issue. Required the solution Stephanie mentioned, a patch from Lawson.

Bev Edwards

Veteran Member

Posts: 366

4/23/2014 8:42 PM

I think I"m going to have to follow Stephanie's direction as well.

Kat - I tried your suggestion, but the item I try to do the Replace/Inactivate on just barks at me saying it can't inactivate because its the default item.

Bev Edwards

Veteran Member

Posts: 366

4/23/2014 8:44 PM

I dumped POVENITEM, but is there a quicker/better way to identify what other items there may be that would have 2 default vendor items in PO13?

Stephanie

Veteran Member

Posts: 86

4/24/2014 10:59 AM

Hi Bev, Do you use Crystal Reports? I have a report you can utilize if so.

Stephanie

Stephanie

Veteran Member

Posts: 86

4/24/2014 11:08 AM

I've attached the report. I suppose you could do the same in excel but this was created to help monitor ongoing, rather than complete an analysis each time.

Attachments

DuplicatePO13DefaultItem.rpt

Bev Edwards

Veteran Member

Posts: 366

4/24/2014 11:17 AM

Hi Stephanie,
I'm a novice with Crystal but I'm familiar with manipulating some of the reportswe have for my own purposes. Can you send me what you have?

Thanks!
Bev

Stephanie

Veteran Member

Posts: 86

4/24/2014 11:35 AM

Hi Bev,

The attachment was sent in the previous post. If you have any issues, feel free to contact me at stephanie.kowal@bhs.org.

Thanks!

JonA

Veteran Member

Posts: 1162

4/24/2014 11:45 AM

I would dump all records in POITEMVEN where DEFAULT_FLG = 1 into Excel. The only fields you need are ITEM, VENDOR and VEN_ITEM. Then concatenate ITEM and VENDOR: =A1&B1 in column D and sort the data by this column.

Write an IF statement in E1: =IF(D1=D2,TRUE,FALSE) and copy and paste this down the rows of data. Highlight/select the entire column E and run a FIND to search for the cells where the formula results in TRUE. This will identify the records with more than one default.

Attachments

Finding_Duplicate_Default_Vendor_Items_in_PO13.doc

JonA

Veteran Member

Posts: 1162

4/24/2014 11:53 AM

But the Crystal report will work better if you have that ability.