Open Forum

We recently have been asked to start supporting 860 documents for EDI for one of our Trade partners.  I'm in the process of setting up the mapping using Lanham EDI.

I've written the mapping, however, must be missing a somewhat basic piece in connecting the NAV Sales Order to the sales order referred to in the POC.

I have mapped the Sales Header External Document No. on the BCH segment, but receive the error "Unable to find an EDI field mapped to the Sales Order No."

The 860 doesn't have our Sales Order No., which makes sense, as the 860 doesn't have that information, but it does have the external document number, which I have mapped.  I'm sure I am missing something fairly basic on how to get it to match up, but wondering if there is any guidance on what I am missing.

The Test Retail example shows using an I_SLSORD rather than a U_SLSORD, but I'm not sure if that would make the difference?


Post
Thanks in advance,
Stuart

------------------------------
Stuart Ness
Director of IT and Project Management
Mrs. Gerry's Kitchen, Inc
Albert Lea, MN
------------------------------

<<The Test Retail example shows using an I_SLSORD rather than a U_SLSORD, but I'm not sure if that would make the difference?>>

It might make a difference.  My 860 has a "Navision Document" set to I_SLSORD.



------------------------------
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA
www.apifishcare.com
------------------------------------------------------------------------
D365UG-BC/NAVUG All-Star
D365UG-BC/NAVUG Board of Advisors, Chairperson Emeritus
D365UG-BC/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
------------------------------------------------------------------------
------------------------------

Original Message:
Sent: Apr 07, 2021 05:21 PM
From: Stuart Ness
Subject: Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

We recently have been asked to start supporting 860 documents for EDI for one of our Trade partners.  I'm in the process of setting up the mapping using Lanham EDI.

I've written the mapping, however, must be missing a somewhat basic piece in connecting the NAV Sales Order to the sales order referred to in the POC.

I have mapped the Sales Header External Document No. on the BCH segment, but receive the error "Unable to find an EDI field mapped to the Sales Order No."

The 860 doesn't have our Sales Order No., which makes sense, as the 860 doesn't have that information, but it does have the external document number, which I have mapped.  I'm sure I am missing something fairly basic on how to get it to match up, but wondering if there is any guidance on what I am missing.

The Test Retail example shows using an I_SLSORD rather than a U_SLSORD, but I'm not sure if that would make the difference?


Post
Thanks in advance,
Stuart

------------------------------
Stuart Ness
Director of IT and Project Management
Mrs. Gerry's Kitchen, Inc
Albert Lea, MN
------------------------------

Hi Stuart!
Yes, please use the I_SLSORD "Navision Document" and you are correct to map to the Sales Header "External Document No."  That is what Lanham EDI uses to determine the Sales Order to link to.  Test that out and if you are still experiencing an issue, please reply back where this issue stands and what is the Lanham EDI version which is located in E.D.I. Setup >> About EDI in the ribbon (it's the SE0.xx.xx # that I would need).
Have a great day!​

------------------------------
Charlotte Kinney
Sr. EDI Specialist & Product Evangelist
Lanham Associates
------------------------------

Original Message:
Sent: Apr 07, 2021 05:21 PM
From: Stuart Ness
Subject: Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

We recently have been asked to start supporting 860 documents for EDI for one of our Trade partners.  I'm in the process of setting up the mapping using Lanham EDI.

I've written the mapping, however, must be missing a somewhat basic piece in connecting the NAV Sales Order to the sales order referred to in the POC.

I have mapped the Sales Header External Document No. on the BCH segment, but receive the error "Unable to find an EDI field mapped to the Sales Order No."

The 860 doesn't have our Sales Order No., which makes sense, as the 860 doesn't have that information, but it does have the external document number, which I have mapped.  I'm sure I am missing something fairly basic on how to get it to match up, but wondering if there is any guidance on what I am missing.

The Test Retail example shows using an I_SLSORD rather than a U_SLSORD, but I'm not sure if that would make the difference?


Post
Thanks in advance,
Stuart

------------------------------
Stuart Ness
Director of IT and Project Management
Mrs. Gerry's Kitchen, Inc
Albert Lea, MN
------------------------------

Hi Lewis and Charlotte,
Thanks for the direction.  I changed it back to the I_SLSORD, and noticed that the functional group was PO instead of PC, so thinking that caused an initial issue, as it does look like it is moving further now.

It has now moved farther in processing, however, I have now received the error:
"You do not have the following permissions on CodeUnit Sales Document Change: Execute".

Since I am in as a Super user, is there a licensing that I might be missing for handling the 860?  I was thinking we had the advanced, since we are doing ASNs.

I am running SE0.60.19 in NAV 2018.


Thanks,
Stuart

------------------------------
Stuart Ness
Director of IT and Project Management
Mrs. Gerry's Kitchen, Inc
Albert Lea, MN
------------------------------

Original Message:
Sent: Apr 08, 2021 10:35 AM
From: Charlotte Kinney
Subject: Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

Hi Stuart!
Yes, please use the I_SLSORD "Navision Document" and you are correct to map to the Sales Header "External Document No."  That is what Lanham EDI uses to determine the Sales Order to link to.  Test that out and if you are still experiencing an issue, please reply back where this issue stands and what is the Lanham EDI version which is located in E.D.I. Setup >> About EDI in the ribbon (it's the SE0.xx.xx # that I would need).
Have a great day!​

------------------------------
Charlotte Kinney
Sr. EDI Specialist & Product Evangelist
Lanham Associates

Original Message:
Sent: Apr 07, 2021 05:21 PM
From: Stuart Ness
Subject: Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

We recently have been asked to start supporting 860 documents for EDI for one of our Trade partners.  I'm in the process of setting up the mapping using Lanham EDI.

I've written the mapping, however, must be missing a somewhat basic piece in connecting the NAV Sales Order to the sales order referred to in the POC.

I have mapped the Sales Header External Document No. on the BCH segment, but receive the error "Unable to find an EDI field mapped to the Sales Order No."

The 860 doesn't have our Sales Order No., which makes sense, as the 860 doesn't have that information, but it does have the external document number, which I have mapped.  I'm sure I am missing something fairly basic on how to get it to match up, but wondering if there is any guidance on what I am missing.

The Test Retail example shows using an I_SLSORD rather than a U_SLSORD, but I'm not sure if that would make the difference?


Post
Thanks in advance,
Stuart

------------------------------
Stuart Ness
Director of IT and Project Management
Mrs. Gerry's Kitchen, Inc
Albert Lea, MN
------------------------------

Just a follow up for anyone looking, the permission is indeed a licensing requirement to allow changing of the PO automatically.  Charlotte mentioned that without the license, the use of the I_SLSGEN can be used as well.  So depending on your needs you can go either way.

The original issue was the document type.

Thanks for the assistance!

------------------------------
Stuart Ness
Director of IT and Project Management
Mrs. Gerry's Kitchen, Inc
Albert Lea, MN
------------------------------

Original Message:
Sent: Apr 08, 2021 10:55 AM
From: Stuart Ness
Subject: Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

Hi Lewis and Charlotte,
Thanks for the direction.  I changed it back to the I_SLSORD, and noticed that the functional group was PO instead of PC, so thinking that caused an initial issue, as it does look like it is moving further now.

It has now moved farther in processing, however, I have now received the error:
"You do not have the following permissions on CodeUnit Sales Document Change: Execute".

Since I am in as a Super user, is there a licensing that I might be missing for handling the 860?  I was thinking we had the advanced, since we are doing ASNs.

I am running SE0.60.19 in NAV 2018.


Thanks,
Stuart

------------------------------
Stuart Ness
Director of IT and Project Management
Mrs. Gerry's Kitchen, Inc
Albert Lea, MN

Original Message:
Sent: Apr 08, 2021 10:35 AM
From: Charlotte Kinney
Subject: Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

Hi Stuart!
Yes, please use the I_SLSORD "Navision Document" and you are correct to map to the Sales Header "External Document No."  That is what Lanham EDI uses to determine the Sales Order to link to.  Test that out and if you are still experiencing an issue, please reply back where this issue stands and what is the Lanham EDI version which is located in E.D.I. Setup >> About EDI in the ribbon (it's the SE0.xx.xx # that I would need).
Have a great day!​

------------------------------
Charlotte Kinney
Sr. EDI Specialist & Product Evangelist
Lanham Associates

Original Message:
Sent: Apr 07, 2021 05:21 PM
From: Stuart Ness
Subject: Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

We recently have been asked to start supporting 860 documents for EDI for one of our Trade partners.  I'm in the process of setting up the mapping using Lanham EDI.

I've written the mapping, however, must be missing a somewhat basic piece in connecting the NAV Sales Order to the sales order referred to in the POC.

I have mapped the Sales Header External Document No. on the BCH segment, but receive the error "Unable to find an EDI field mapped to the Sales Order No."

The 860 doesn't have our Sales Order No., which makes sense, as the 860 doesn't have that information, but it does have the external document number, which I have mapped.  I'm sure I am missing something fairly basic on how to get it to match up, but wondering if there is any guidance on what I am missing.

The Test Retail example shows using an I_SLSORD rather than a U_SLSORD, but I'm not sure if that would make the difference?


Post
Thanks in advance,
Stuart

------------------------------
Stuart Ness
Director of IT and Project Management
Mrs. Gerry's Kitchen, Inc
Albert Lea, MN
------------------------------