Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Lewis Rosenberg]

Hello All,

I am trying to get an ASN properly mapped for a Trading Partner (NAV 2013r2, Lanham EDI).  The ASN is actually working for other tranding partners but this partner wants it to work differently.  The partner orders in the EA unit of measure and we ship in the EA unit of measure but only in full case quantities.

One item, for example, is packed in cases on 4 EA and the order quantiity was 36 EA, so we shipped nine cases of product.

The ASN has a repeating HL-Item loop with a LIN and SN1 segment.  The ASN has nine LIN and SN1 segments for this item and the SN1 quantity is 4 EA (9 * 4 = 36).

The ASN we are sending looks something like this:

HL*3*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*4*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*5*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*6*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*7*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*8*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*9*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*10*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*11*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~

The trading partner is saying that they want to see one Item LIN with an SN1 quantity of 36 EA:

HL*3*2*I~LIN**UP*999999999999*CB*999999~SN1**36*EA~

I have tried changing the packing rule fields and changing the rule from SOPI to SOI, etc. I have also tried altering the map.

Any ideas?

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————

[Bill Solano]

Hi Lewis,

Have you tried the Package Summary Type: on the packing rule, there’s a couple options there that may help:

Only Item by Item looks promising.

I haven’t had a need for these in our ASNs but looks like it may do the trick.

Hope it helps.

——————————
Bill Solano
SR EDI Technical Specialist
CCA & B, LLC (The Elf on The Shelf)
Atlanta GA
——————————
——————————————-

[Justin Falconer]

This is most likely caused by the way the item is packed in Eship, If they scan each case the package will have a line for each time you scan the item.

Using the Packing Rule to setup the ASN from Package Summary and/or setting the Package Summary Type should resolve this problem.

We also Map the ASN using the “Bill of Lading Summary Line” table.

——————————
Justin Falconer
IT Manager
Tender Corporation
Littleton NH
——————————
——————————————-

[Lewis Rosenberg]

Thanks for the responses.  I am also mapping using the “Bill of Lading Summary Line” table.  Unfortunately, changing the “Packing Summary Type” value has not helped nor has checking “Lines from Pack Summary Lines” or “ASN Summary from Pack summary”.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Ruthie Moshos]

Hi, Lewis-

I would set the ASN Summary Type on the Packing Rule to Shipment-Order-Item-Package, then set the Increment Levels (Advanced) 1, 2 and 3. On your 856 map, make sure to change the HL segments to use Advanced Line No. and Advanced Parent Line No. You may need to include the Command only for HL Pack Begin right before the HL End command. You’ll need to test it.
What this will do is summarize the item count in the HL-Item level and normally would list all the packages in the HL-Pack level, but you can skip the entire HL-Pack levels in the map by using the Advanced Line Nos. in the HL segments. The HL numbering will use only the levels you set in the Increment Levels on the Packing Rule.

——————————
Ruthie Moshos
EDI Specialist
Western Computer
Canyon Country CA
——————————
——————————————-

[Lewis Rosenberg]

Thanks, Ruthie.

I understand where to make the Packing Rule changes, but how do I change the HL segments on the map to use Advanced Line No. and Advanced Parent Line No.?

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Bill Solano]

Hi Lewis,

You would just update the mapping in the HL-ITEM segment and just pick the correct Advanced field in the Field Name.

——————————
Bill Solano
SR EDI Technical Specialist
CCA & B, LLC (The Elf on The Shelf)
Atlanta GA
——————————
——————————————-

[Ruthie Moshos]

Hi, Lewis-

In your 856 map, just change the segments to the Advanced fields. They are fields numbers 87 and 88 when you use the lookup on the element.

——————————
Ruthie Moshos
EDI Specialist
Western Computer
Canyon Country CA
——————————
——————————————-

[Lewis Rosenberg]

Thanks – We’re getting closer.

I now have a HL-ITEM/LIN segment for each item that appears to be correct (one LIN per item), but that is followed by more HL-ITEM//LIN segments for each item for each case.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Lewis Rosenberg]

So originally I was getting this on my ASN for 9 cases with four per case:

HL*3*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*4*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*5*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*6*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*7*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*8*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*9*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*10*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~
HL*11*2*I~LIN**UP*999999999999*CB*999999~SN1**4*EA~

Now after making suggested changes I still get 9 repeat occurrences of the HL Item loop but with the correct quantity of 36 EA.  What do I need to do so that it does not repeat?

HL*4*3*I~LIN**UP*999999999999*CB*999999~SN1**36*EA~
HL*5*3*I~LIN**UP*999999999999*CB*999999~SN1**36*EA~
HL*6*3*I~LIN**UP*999999999999*CB*999999~SN1**36*EA~
HL*7*3*I~LIN**UP*999999999999*CB*999999~SN1**36*EA~
HL*8*3*I~LIN**UP*999999999999*CB*999999~SN1**36*EA~
HL*9*3*I~LIN**UP*999999999999*CB*999999~SN1**36*EA~
HL*10*3*I~LIN**UP*999999999999*CB*999999~SN1**36*EA~
HL*11*3*I~LIN**UP*999999999999*CB*999999~SN1**36*EA~
HL*12*3*I~LIN**UP*999999999999*CB*999999~SN1**36*EA~

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Lewis Rosenberg]

?The above repeating issue was fixed by making sure EVERY HL segment used the ADVANCED LINE NO. and not the LINE NO. field.

NOW, the partner wants a MAN segment, but the UCC field is empty when I create the ASN.  The MAN-02 is mapped to the UCC NO. field on the Bill of Lading Summary Line table.  Is there something on the Packing Rule that will trigger this field to be populated?

In the Bill Of Lading Summary table, all of the PACKAGE and ITEM TYPE lines appear to have the UCC populated, but it not populated for lines of TYPE  = “Bill Of Lading”, “Order”, “Shipment”, or “Purchase Order”.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-