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 Apr 07, 2021 05:21 PM
    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 Apr 08, 2021 09:14 AM
    <<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 Apr 08, 2021 10:35 AM
    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 Apr 08, 2021 10:56 AM
    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 Apr 08, 2021 02:27 PM
    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
    ------------------------------



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

    Posted Apr 20, 2021 04:19 PM
    Hi Stuart,

    I am running into the exact same permissions issue with our system and I was curious if you had more info on what the license requirement is?
    We purchased the Lanham EDI Extended Document Module from our ERP partner with the understanding that this license was required to start processing 860's.

    We are on SE0.60.18

    Thanks in advance!
    Alexander

    ------------------------------
    Alexander Schenkel
    Haliburton International Foods
    ------------------------------



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

    SILVER CONTRIBUTOR
    Posted Apr 20, 2021 07:58 PM
    Hi Alexander!
    It sounds like you are licensed appropriately for the i860 to update a Sales Order (where the "Navision Document" = I_SLSORD) as it is licensed under EDI Extended Document.  I'd make sure that you see this module in the license file and perhaps rebooting of the service tier so it can see the new license file.  Let us know if you still can't process your 860.
    BTW - A quick way to see if you can access a page that is licensed under the EDI Extended Documents is to try to open the Sales Price Catalog or Inventory Advice pages...if you can't open them, then the new fin.flf is not recognized.  If you can open them, then you are licensed correctly and perhaps something else is going on.
    Keep us posted please!

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



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