PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 9/22/2023 6:30 PM by  JonA
ED40 List Names
 6 Replies
 1 Subscribed to this topic
 97 Subscribed to this forum
Sort:
You are not authorized to post a reply.
Author Messages
Bill Brennenstuhl
Business Systems Analyst
Private
Basic Member
(27 points)
Basic Member
Posts:13


Send Message:

--
9/22/2023 1:14 PM

    Is there some place that has a list of all the List Name options that can be used?  ie O_VENDOR, I_COMPANY  I have a vendor that wants only a two character country code and was hoping I could setup a ED40 record to convert USA to US in the 850.

    JonA
    Private
    Private
    Veteran Member
    (3482 points)
    Veteran Member
    Posts:1160


    Send Message:

    --
    9/22/2023 1:45 PM
    I've not seen a substitution table entry for the country code. We don't populate the country code in IC02 but since you do you could just add US to the list in IN01 then update IC02. Two characters is the standard.
    Jon Athey - Sr. Supply Chain Analyst - Materials Management - MidMichigan Health
    Bill Brennenstuhl
    Business Systems Analyst
    Private
    Basic Member
    (27 points)
    Basic Member
    Posts:13


    Send Message:

    --
    9/22/2023 2:27 PM

    Hi Jon,

    Thanks for the quick reply.  The issue is that only one of our vendors is like this, all rest want USA.  That's why I thought an ED40 record would fix it.

    Thanks again,

    Bill

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2978 points)
    Veteran Member
    Posts:1018


    Send Message:

    --
    9/22/2023 2:36 PM
    The only place I've seen Infor provide the potential list names was in their EDI Trading Partner lists. But I don't have anything recent and I don't see country either.
    JonA
    Private
    Private
    Veteran Member
    (3482 points)
    Veteran Member
    Posts:1160


    Send Message:

    --
    9/22/2023 5:51 PM

    Infor documentation doesn't always show us all the possible substituions available.  Just for giggles, have you tried the usual suspects like tpid_O_COUNTRY_CODE?

    Or L1_O_COUNTRY_CODE

     

    Another thought would be to modify your process (laws_out_91_ghx or laws_out_91 or whatever you might have assigned in ED10).  With Infor support you might be able to add code to the effect of

    If tpid = XX   then shipto_country_code = US

    Jon Athey - Sr. Supply Chain Analyst - Materials Management - MidMichigan Health
    Bill Brennenstuhl
    Business Systems Analyst
    Private
    Basic Member
    (27 points)
    Basic Member
    Posts:13


    Send Message:

    --
    9/22/2023 6:26 PM
    Yep, tried O_COUNTRY_CODE and O_COUNTRYCODE and no luck. Not sure how the L1 option works, how does it know what vendor to use it for? This is all leading up to us moving to FSM on November 1. Same concept, just seemed to be more conversation about it in the S3 forum.
    JonA
    Private
    Private
    Veteran Member
    (3482 points)
    Veteran Member
    Posts:1160


    Send Message:

    --
    9/22/2023 6:30 PM

    The Lawson Value is your tpid for that vendor.

    Jon Athey - Sr. Supply Chain Analyst - Materials Management - MidMichigan Health
    You are not authorized to post a reply.