Item Engineering Data effective date blank

(0) Share

Report

Posted on by Linda Brock

Hi,

My client just upgraded from GP10 to GP2013 and now are getting the error "This item is not effective, do you want to use it anyway?"

When we open the Item Engineering window, the effective date is blank and the status is blank. So they have to go into each item and set the effective date and mark it as active.

These were all set on GP10 so it looks like the upgrade blanked it out.

I know they can go in one-at-a-time and fix the engineering data window.

Is there any way to globally fix these two fields? Thanks!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

I would run a SQL script on the IVR10015 table to update the ITEMSTATUS_I and EFFECTIVEDATE_I values. Of course, backup the database first.

Was this reply helpful? Yes No
Linda Brock 18 on at

Like (0)

Report

Thank you - that worked!!

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

You're quite welcome Linda. Happy to help :)

Was this reply helpful? Yes No