ED40 List Names

 6 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Bill Brennenstuhl
Basic Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 1163
Veteran Member

The Lawson Value is your tpid for that vendor.

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