PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/1/2022 5:55 PM by  childs0
Special Character in Vendor Item
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Fritz Osorio
Systems Analyst
Private
New Member
(4 points)
New Member
Posts:2


Send Message:

--
11/23/2022 3:00 PM

    I'm not sure if there's another thread with a resolution on this....

    My situatiion is that a special character was uploaded as a vendor item# so I tried adding another PO13 record with the correct vendor item# and made it default (it did not automatically default as it has the same vendor#).

    I'm now trying to inactivate or at best delete the erroneous record but "Vendor item does not exist" pops up....

    Any advice....

    JMAN818
    SUPPLY CHAIN ANALYST
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    11/30/2022 7:38 PM
    Reach out to your system admin to make the fix. Our support admin verified with Infor Support that the fix needed to be done on the POITEMVEN table using SQL.
    LaDora
    Materials Management Supervisor
    Glendive Medical Center
    Veteran Member
    (115 points)
    Veteran Member
    Posts:47


    Send Message:

    --
    12/1/2022 4:11 PM
    Fritz:
    Out of curiosity, did you try to make the change in PO13 or PO13.3? You can do a replace and inactivate in PO13.3. That will pullover to PO13 and also change PO25. You would still need to manually change IC11 and IC12.
    childs0
    NA
    NA
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    12/1/2022 5:55 PM

    Yes this needs to be done in sql In most cases. We had a case where a non visible space was uploaded through req centre. Cobol would ignore the character when performing actions but wouldn't return any db records. You would also need to check related tables as the character may have been copied to these locations and cause problems later on.

    You are not authorized to post a reply.