Open Forum

Expand all | Collapse all

Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

Jump to Best Answer
  • 1.  Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

    SILVER CONTRIBUTOR
    Posted 5 days ago
    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
    ------------------------------


  • 2.  RE: Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.
    Best Answer

    NAVUG ALL STAR
    Posted 4 days ago
    <<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
    ------------------------------------------------------------------------
    ------------------------------



  • 3.  RE: Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

    SILVER CONTRIBUTOR
    Posted 4 days ago
    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
    ------------------------------



  • 4.  RE: Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

    SILVER CONTRIBUTOR
    Posted 4 days ago
    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
    ------------------------------



  • 5.  RE: Lanham EDI 860 (SE0.60.19) PO Change Unable to find an EDI field mapped to the Sales Order No.

    SILVER CONTRIBUTOR
    Posted 4 days ago
    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
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role