PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 9/6/2023 4:32 PM by  Kurt L Guldner
Inbound 856/810 Changing UoM
 13 Replies
 0 Subscribed to this topic
 45 Subscribed to this forum
Sort:
You are not authorized to post a reply.
Author Messages
EricCMH
IS Analyst II
Private
Basic Member
(16 points)
Basic Member
Posts:8


Send Message:

--
2/7/2018 3:19 PM

    We are using EDI with GHX - We are sending/receiving a UoM of "CA" for an item we are purchasing and receiving. When our translation job runs inbound the "CA" is being changed to a "CS". I have created a record in ED40.1 for that specific EDI vendor of "CA" to "CA", but we are still having the issue where these are being pulled in as "CS". In our translation script I know that the L1 values are being referenced if no other Substitution Value for the EDI vendor is found, but that's why I entered a dummy substitution value for the UoM. Is there any way I can see where this is being translated or how this issue is occuring?
    WadeYohanek
    EDI Manager
    Private
    Basic Member
    (31 points)
    Basic Member
    Posts:15


    Send Message:

    --
    2/7/2018 7:04 PM
    What does the raw EDI look like?
    EricCMH
    IS Analyst II
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:8


    Send Message:

    --
    2/7/2018 7:12 PM

    The Raw EDI has the correct UoM value when I pull it off of GHX.
    WadeYohanek
    EDI Manager
    Private
    Basic Member
    (31 points)
    Basic Member
    Posts:15


    Send Message:

    --
    2/7/2018 7:20 PM
    And you've got the L1_I_USE_TP_UOM set for the vendor and only that UOM set on the vendor? And it is only happening on that vendor? (Not that you should have to since it doesn't need translating).
    EricCMH
    IS Analyst II
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:8


    Send Message:

    --
    2/7/2018 8:18 PM
    We have a data substitution value specifically for our TPID inbound UoM currently: Lawson Value = CA External Value = CA.
    We don't have L1_I_USE_TP_UOM set up
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2972 points)
    Veteran Member
    Posts:1016


    Send Message:

    --
    2/8/2018 8:47 PM
    Is the inbound doing anything routing wise? Does it come straight from the GHX C+ box or does it go through Cloverleaf or something that might alter it?
    EricCMH
    IS Analyst II
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:8


    Send Message:

    --
    2/12/2018 7:56 PM
    Kat V - GHX is dropping the file to an FTP folder where we pick it up. I know that we use a translation file, but it should be looking to the vendor specific ED40 record for the UoM conversion. I'm not sure if the translation file is the issue as that is owned by GHX.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2972 points)
    Veteran Member
    Posts:1016


    Send Message:

    --
    2/12/2018 9:00 PM
    We have your setup, but we haven't seen anything like that. If it's not an MA531 setting, I'd call it into Infor.
    EricCMH
    IS Analyst II
    Private
    Basic Member
    (16 points)
    Basic Member
    Posts:8


    Send Message:

    --
    2/13/2018 7:33 PM
    Thanks, Kat. I have reached out to INFOR regarding this issue.
    Paul
    SCM
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    3/27/2019 1:29 PM

    Hello

     

    Can someone please send me some screenshots on how to set up the ED40.1 translation table to change the UOM for a Lawson #? Example would be PK to BX Outbound and BX to PK inbound.

     

    Thank you
    Matt_B
    Applications Analyst
    Private
    Advanced Member
    (56 points)
    Advanced Member
    Posts:22


    Send Message:

    --
    4/8/2019 3:52 PM
    Hi All,

    We don't use these substitutions but I was under the impression that you would want the Sub table to look like this:
    List Name : GHXCARD_I_USE_TP_UOM
    Lawson Value ....CS
    External Value ..CA

    Where the script will translate CA to CS for the TP specified. In the case above it would our name for Cardinal.

    Whereas Eric explained that he had (below), which theoretically would translate it but it would be a wash.
    List Name : GHXCARD_I_USE_TP_UOM
    Lawson Value ....CA
    External Value ..CA

    Unless I am missing something
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2972 points)
    Veteran Member
    Posts:1016


    Send Message:

    --
    4/9/2019 7:38 PM
    You can't do it for a specific Item number - it's setup to change per EDI vendor.

    And yes - to stop CS from coming in, the setup should be
    List Name : GHXCARD_I_USE_TP_UOM
    Lawson Value ....CA
    External Value ..CS

    I had missed this.
    Kurt L Guldner
    Private
    Private
    Advanced Member
    (71 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    9/6/2023 4:28 PM
    Would there be leading spaces before the UOM since the UOM field allows 4 characters? For example __CA vs just CA in the Lawson Value.
    Kurt L. Guldner Supervisor Supply Chain Data Informatics UnityPoint Health kurt.guldner@unitypoint.org
    Kurt L Guldner
    Private
    Private
    Advanced Member
    (71 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    9/6/2023 4:32 PM
    I had our ED40 records built to change CS to CA as seen below and we've been having issues with it working and after coming across this thread I am wanting to try how you have mentioned to build them.
    TPID_I_UOM
    External Value - CS
    Lawson Value - CA
    Kurt L. Guldner Supervisor Supply Chain Data Informatics UnityPoint Health kurt.guldner@unitypoint.org
    You are not authorized to post a reply.

    Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement