Lanham EDI 856 ASN Summary Type

  • Lanham EDI 856 ASN Summary Type

    Posted by Noreen Fujita-Sacco on May 23, 2023 at 8:03 pm

    In Dynamics NAV 2018 is anyone familiar with setting an ASN with HL priority Order-Item-Package? There are settings under the Packing Rule. But I don’t have mapping instructions for this or how they tie to the 856 HL setups. Here is a sample with multiple items and packages from the trading partner. I will say the CTT doesn’t look right to me. I feel it should be CTT*3*5. Any help is greatly appreciated!

    BSN*00*VendorShipID*20220524*2001*ZZZZ*AS

    HL*1**O

    PRF*PONumber*****VendorOrderNumber

    N1*SF*WHSE*92*WHSE

    HL*2**I

    LIN*1*SK*1617

    SN1*1*3*EA**3*EA**IA

    MAN*R*0001

    HL*3**P

    TD1******Z*23*LB

    TD5**92*UPS_GR_RES

    MAN*R*0001*99999*SM*1ZXR28900300000001

    DTM*ZZZ*20220524*1200*GM

    DTM*011*20220524*1200*GM

    HL*3**P

    TD1******Z*23*LB

    TD5**92*UPS_GR_RES

    MAN*R*0002*99999*SM*1ZXR28900300000002

    DTM*ZZZ*20220524*1200*GM

    DTM*011*20220524*1200*GM

    HL*3**P

    TD1******Z*23*LB

    TD5**92*UPS_GR_RES

    MAN*R*0003*99999*SM*1ZXR28900300000003

    DTM*ZZZ*20220524*1200*GM

    DTM*011*20220524*1200*GM

    HL*4**I

    LIN*2*SK*4927

    SN1*2*2*EA**2*EA**IA

    MAN*R*0004

    HL*5**P

    TD1******Z*23*LB

    TD5**92*UPS_GR_RES

    MAN*R*0004*99999*SM*1ZXR28900300000004

    DTM*ZZZ*20220524*1200*GM

    DTM*011*20220524*1200*GM

    HL*6**I

    LIN*3*SK*9876

    SN1*3*1*EA**1*EA**IA

    MAN*R*0005

    HL*7**P

    TD1******Z*23*LB

    TD5**92*UPS_GR_RES

    MAN*R*0005*99999*SM*1ZXR28900300000005

    DTM*ZZZ*20220524*1200*GM

    DTM*011*20220524*1200*GM

    CTT*2*5

    Charlotte Kinney replied 11 months, 2 weeks ago 3 Members · 9 Replies
  • 9 Replies
  • Charlotte Kinney

    Member
    May 24, 2023 at 10:55 am
    Up
    0
    Down
    ::

    Noreen,

    Are you using Lanham EDI? If so, yes, set the hierarchical level on the Packing Rule and apply the Packing Rule to the ship-to record. Make sure the order has the applicable ship-to record!!! Most of the mapping comes from the BOL Summary Line table so make sure after the BOL is created and released that it is in the correct format. You can Zoom on each line to see what values are behind the scenes and can map from there.

    The CTT should read CTT*8*(total of all items ordered)

    The CTT-01 can be mapped to the Database-LAX BOL Summary Line-Line No.

    The CTT-02 could be mapped to an EDI OUT-BOL Item Qty.

    Test this out and let us know if you have any other questions.

    • Lewis Rosenberg

      Member
      May 24, 2023 at 11:45 am
      Up
      0
      Down
      ::

      Charlotte is the expert, but I would have expected CTT*3*6.

      CTT01 = Number of Line items (3 LIN segments)

      CTT02 = Sum of all SN102 segments (3+2+1)

      I checked all of my EDI 856 maps and I never had to map the CTT02.

      • Noreen Fujita-Sacco

        Member
        May 24, 2023 at 5:54 pm
        Up
        0
        Down
        ::

        I agree with Lewis. There are a total of 6 units for 3 different items on the order. I’ll find out when I submit for approval.

    • Noreen Fujita-Sacco

      Member
      May 24, 2023 at 6:02 pm
      Up
      0
      Down
      ::

      Thank you, Charlotte!

      Yes, we’re on Lanham EDI.

      I have the hierarchical rule set as shipment-order-item-package and applied to customer card. Everything is brought over correctly from the 850 to the SO. . We’re bringing in addresses to the sales order as these are drop-ship. Nav automatically flags these as “custom address” on the SO. I expected the packing rule to default. Do I still need a “custom” ship-to card?

  • Charlotte Kinney

    Member
    May 24, 2023 at 5:58 pm
    Up
    0
    Down
    ::

    Sorry…that was a type-o. Try the mapping I suggested and see if you get the results you are looking for.

    If the first suggested mapping of CTT-01 doesn’t give you what you are looking for, try mapping from the EDI OUT – Total LIN Segments

    • Noreen Fujita-Sacco

      Member
      May 24, 2023 at 6:05 pm
      Up
      0
      Down
      ::

      Thanks, again, Charlotte! The CTT is working. I’m having more issues with the hierarchical settings. Still testing and will report back shortly.

      • Charlotte Kinney

        Member
        May 24, 2023 at 6:25 pm
        Up
        0
        Down
        ::

        Create a ship-to record called DROP and leave the address blank. Set the Packing Rule. Create the EDI Customer Cross Reference. The Packing Rule’s “ASN Summary Type” = Ship>Order>Item>Pack (since you really want Order>Item>Pack, this is the closest).

        Set “Increment Level 2 (ASN) = TRUE (for order)

        Set “Increment Level 3 (ASN) = TRUE (for item)

        Set “Increment Level 4 (ASN) = TRUE (for pack)

        When you do the mapping for the HL segments (01 and 02), map using the BOL Summary Line “Advanced Line No.” and “Advanced Parent Line No.”

        • Noreen Fujita-Sacco

          Member
          May 24, 2023 at 9:54 pm
          Up
          0
          Down
          ::

          Many thanks, Charlotte! I am much further along today with your help and am able to submit for approval and work through errors. Creating the ship-to was a major breakthrough.

The discussion ‘Lanham EDI 856 ASN Summary Type’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!