Inbound 856/810 Changing UoM - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

EricCMH

Basic Member Send Private Message

Posts: 8

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

Basic Member Send Private Message

Posts: 15

2/7/2018 7:04 PM

What does the raw EDI look like?

EricCMH

Basic Member Send Private Message

Posts: 8

2/7/2018 7:12 PM

The Raw EDI has the correct UoM value when I pull it off of GHX.

WadeYohanek

Basic Member Send Private Message

Posts: 15

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

Basic Member Send Private Message

Posts: 8

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

Veteran Member Send Private Message

Posts: 1020

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

Basic Member Send Private Message

Posts: 8

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

Veteran Member Send Private Message

Posts: 1020

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

Basic Member Send Private Message

Posts: 8

2/13/2018 7:33 PM

Thanks, Kat. I have reached out to INFOR regarding this issue.

Paul

New Member Send Private Message

Posts: 1

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

Advanced Member Send Private Message

Posts: 22

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

Veteran Member Send Private Message

Posts: 1020

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

Advanced Member Send Private Message

Posts: 35

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

Advanced Member Send Private Message

Posts: 35

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