ED40 List Names

 6 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Bill Brennenstuhl
Basic Member
Posts: 16
Basic Member

    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
    Veteran Member
    Posts: 1163
    Veteran Member
      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 - MyMichigan Health
      Bill Brennenstuhl
      Basic Member
      Posts: 16
      Basic Member

        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
        Veteran Member
        Posts: 1020
        Veteran Member
          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
          Veteran Member
          Posts: 1163
          Veteran Member

            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 - MyMichigan Health
            Bill Brennenstuhl
            Basic Member
            Posts: 16
            Basic Member
              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
              Veteran Member
              Posts: 1163
              Veteran Member

                The Lawson Value is your tpid for that vendor.

                Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health