Open Forum

Expand all | Collapse all

Lanham EDI ASN - Need help resolving issue: Same UCC for all items

Jump to Best Answer
  • 1.  Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    TOP CONTRIBUTOR
    Posted 30 days ago
    We use Lanham eShip and EDI in NAV2013R2.  For sales shipments, we pick full cases, so each item is a package.  We have a trade partner that just started to complain that we are sending the same UCC number for every package in our ASNs.

    I am not sure if this is a setup issue or a process issue.

    Can anyone add any insight?

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

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

    NAVUG/D365BC-User Group Focus
    May 18-19, 2019
    Denver, Colorado
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    SILVER CONTRIBUTOR
    Posted 27 days ago
    We have run into the same issue in our environment - Lanham EDI + E-Ship.  Full cases are our items as well and we ship everything on a pallet.  I won't say that we have a direct fix for the issue you are asking about, however, the work around we had was that the Pack level MAN is optional for the spec that we implemented to.  Since our packages didn't have unique UCC codes (our pallets do), we were able to just bypass the MAN segment completely, eliminating the sending of the duplicate UCCs at that level, which made the trade partner happy.

    Unless you are individually labeling the Cases of product, the cases don't have a visible UCC anyway, so sending them is misleasing as there really are no distinguishable marks and the GTIN is spec'd elsewhere in the item details.

    So check your specs - maybe you can work around the issue.

    ------------------------------
    Stuart Ness
    IT Coordinator
    Mrs. Gerry's Kitchen, Inc
    Albert Lea MN
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    GOLD CONTRIBUTOR
    Posted 27 days ago
    What is the format of the ASN?
    How is it being packed in E-Ship?
    LTL or Small Package Shipments?

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

    Conference-BCNAVUG_200x200


  • 4.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    TOP CONTRIBUTOR
    Posted 27 days ago
    What is the format of the ASN?   ==> Shipment-Order-Package-Item

    How is it being packed in E-Ship?  ===>  Base UOM is EA, we pick full cases (Put-away UOM=CS, Std Pack UOM=CS) and each CS is a package and gets a label.  We use //CSPP - Create Std Package & Print

    LTL or Small Package Shipments?  ==> LTL


    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

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

    NAVUG/D365BC-User Group Focus
    May 18-19, 2019
    Denver, Colorado
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    GOLD CONTRIBUTOR
    Posted 26 days ago
    Can you post a screen print of your packing rule?

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

    Conference-BCNAVUG_200x200


  • 6.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    TOP CONTRIBUTOR
    Posted 26 days ago








    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

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

    NAVUG/D365BC-User Group Focus
    May 18-19, 2019
    Denver, Colorado
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    GOLD CONTRIBUTOR
    Posted 26 days ago
    Not sure if this is causing it but on the UCC Tab, the Field "UCC 128 Sequence Nos" has a Number Series Linked to it in our system
    On the UCC Tab I also have the Option "Assign UCC Closing Package" Checked
    I also have on the "ASN" Tab "ASN Requires UCC No." is checked


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

    Conference-BCNAVUG_200x200


  • 8.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    Posted 26 days ago
    Lewis,
    Go to the Bill of Lading in question, select Navigate in the ribbon >> ASN Summary.  Do a "Show Column" for the 'UCC No.' and send a screen shot.  I am assuming the 856 mapping of the UCC # ​is coming from the "Bill of Lading Summary Line" 'UCC_No.' field.  If so, the BOLs ASN Summary page is where the values come from.  Let me know if it is mapped otherwise (but the BOL Summary Line table is the suggested way of mapping).

    ------------------------------
    Charlotte Martinez
    Sr. EDI Specialist
    Lanham Associates
    ------------------------------

    Conference-BCNAVUG_200x200


  • 9.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    TOP CONTRIBUTOR
    Posted 26 days ago
    Map:



    ASN Summary:



    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

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

    NAVUG/D365BC-User Group Focus
    May 18-19, 2019
    Denver, Colorado
    ------------------------------

    Conference-BCNAVUG_200x200


  • 10.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    GOLD CONTRIBUTOR
    Posted 26 days ago
    Looks like it was all packed in one box.  We ship Cases also and we treat each Case as Its own package in Eship.

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

    Conference-BCNAVUG_200x200


  • 11.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    TOP CONTRIBUTOR
    Posted 26 days ago
    That's exactly what we're trying to do and that is what happens with some other orders/customers.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

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

    NAVUG/D365BC-User Group Focus
    May 18-19, 2019
    Denver, Colorado
    ------------------------------

    Conference-BCNAVUG_200x200


  • 12.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    TOP CONTRIBUTOR
    Posted 26 days ago
    Edited by Lewis Rosenberg 26 days ago

    Interesting....I just tested with the same customer, different ship-to (but it uses the same packing rule) and this looks correct:



    So, I think that there is a process issue somewhere.

    My process was:
    (1) Create Whse Ship
    (2) Create Whse Pick
    (3) Register the Whse Pick
    (4)  Pack Line - Entered sales order number and attempted //BOL command, but it did not work
    (5)  Pack Line - //CSP  (usually they would do //CSPP to print labels)
    (6)  It packed 1036 of 1048 (not sure why) so I ran //PR to get 1048 of 1048
    (7) Pack Line //CP  -- I JUST REALIZED THAT I USUALLY RUN //AAP at this point to create a Pallet Label.  I forgot to do that this time.
    (8)  Posted the Whs Shipment
    (9) Created the BOL and added the Posted Shipment to it
    (10) Updated the BOL





    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

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

    NAVUG/D365BC-User Group Focus
    May 18-19, 2019
    Denver, Colorado
    ------------------------------

    Conference-BCNAVUG_200x200


  • 13.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items
    Best Answer

    Posted 25 days ago
    Lewis...yes, this appears to be an issue with the way in which the order was packed using E-Ship.  It seems like the Trade Partner does not require the TARE (pallet) level.  I say this because the Packing Rule's "ASN Summary Type" = Ship>Order>Pack>Item (no TARE represented).  If that is the case, then the easiest solution is to NOT pack the tare (ie, do not run the //AAP (Add All Packages) command).  I have attached  2 screen shots taken from the BOL >> ASN Summary to show the hierarchical level build based on the Packing Rule's ASN Summary Type.  As you can see the BOL Summary where the tare/pallet was not packed is correct in that each package reflects it's unique UCC/GS-128 ID.  The BOL Summary where the tare/pallet was packed you'll notice that the items have now inherited the pallets UCC/GS-128 number.  This is what I believe you experienced in the initial screen shot of the problematic ASN.

    Miscellaneous Notes before the suggested packing process:
    1.  You stated in your steps that you had to run the //PR (Pack Remaining) command.  Next time this occurs, I'd suggest running the //MOL (Missing Order Lines) command to see what items have NOT been packed.  I'd then go to their Item page and check out their "Std Pack UOM" quantity and companre that against what is on the sales order.  I am not sure how many EACHES are in the CASE Standard Pack setup but if it not a number that is evenly divisible by the "Std Pack Qty" located on the Item page, the remainder would be what is left over to be packed and may be packed using the //PR command.
    2.  In your reply you stated that the //BOL (Bill of Lading) command did not work.  What about it did not work or were there any error messages?  Regardless, if there is 1 shipment per BOL, I'd suggest automating the creation of the BOL as well as Release it so that the next time the Job Queue is ran, the BOL is ready and may be sent.  To do this, on the Packing Rule set "Auto Bill of Lading When Ship" and "Release Summary" = TRUE.

    Here is what I recommend assuming the Packing Rule is updated based on the above:
    (1) Create Whse Ship
    (2) Create Whse Pick
    (3) Register the Whse Pick
    (4) Open Pack Line Scanning page - Scan in the Sales Order No.
         (a)  Scan //CSPP  (Create Standard Pack Print)
         (b)  Scan //PR (Pack Remaining) and //CPP (Close Package Print), when necessary
         (c)  Scan //CO (Close Order) which post the Shipment/Whse Shipment (assuming the Packing Station >> Label & Posting fast tab >> Sales Order Close Action = Ship)

    If you wanted to get fancy, you could create a custom barcode that runs steps A-C all in 1 step/barcode using the "Standard Option Setups" but I won't get into that because I don't want to change up processes too much.  On the other hand, this would prevent the shipper from accidentally running the //AAP command which creates the tare.  So just some things to think about.

    Using the steps above, the BOL would auto create and release.  The BOLs "ASN Summary" is based on the attached "Correct" screen shot.  Each carton pack will have it's own unique UCC/GS-128 ID.  Hopefully this will work out but if the Trade Partner requires the TARE, let me know and I will send updated information.  I hope this helps you out as well as makes sense what is happening with the inherited UCC/GS-128 numbers for the individual cartons when the tare is packed but not reflected in the ASN Summary Type (as well as Stuart!).

    ------------------------------
    Charlotte Martinez
    Sr. EDI Specialist
    Lanham Associates
    ------------------------------

    Conference-BCNAVUG_200x200


  • 14.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    TOP CONTRIBUTOR
    Posted 25 days ago

    Wow Charlotte!   This is a great help!  I also want to thank you and everyone at Lanham for adding the hover-over-field documentation that I see in Business Central v13.  We don't currently have that available in NAV2013R2.

    I discovered why //BOL "did not work."  It was actually working sort of...it created the BOL, but did not pop-it open and link to the order.  I found that some of our packing rules had BOL Summary from Pack Summary checked and some did not.  It is now checked for all packing stations.

    We also learned today that if you START the Pack Line process with //BOL, it will link the BOL to the order and later when the shipment is posted, it automatically links the posted shipment to the BOL (on the BOL Worksheet).  Our Shipping team tried using //BOL after posting the shipment but still had to ADD THE POSTED SHIPMENT.


    Creating a "custom bar code" is a great idea and something we have considered, but we'll wait until we really understand and iron out the process.  I will now review to see which (if any) of out trading partners currently require the TARE.  I think we have some.


    I'm still trying to understand the Default Package Type field  on the UCC tab.  We have it set to "1" for most Trading Partners, but it is "0" for a couple.

    Thanks again for helping me to better understand this.



    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

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

    NAVUG/D365BC-User Group Focus
    May 18-19, 2019
    Denver, Colorado
    ------------------------------

    Conference-BCNAVUG_200x200


  • 15.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    TOP CONTRIBUTOR
    Posted 16 days ago
    <<I discovered why //BOL "did not work."  It was actually working sort of...it created the BOL, but did not pop-it open and link to the order.  I found that some of our packing rules had BOL Summary from Pack Summary checked and some did not.  It is now checked for all packing stations.>>

    OK, so that setting is not what makes the BOL open from Pack Line Scanning.  It creates the Bill Of Lading, but does not force it to open.
    For some of our customers, the BOL is created and opened when we use the //BOL command.  For others, it creates the BOL, but it does not open it.

    Does anyone know why?


    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

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

    NAVUG/D365BC-User Group Focus
    May 18-19, 2019
    Denver, Colorado
    ------------------------------

    Conference-BCNAVUG_200x200


  • 16.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    SILVER CONTRIBUTOR
    Posted 13 days ago
    The only place that I have had affect whether the BOL opens when closing an order has been on the packing station setup. (Not to say there couldn't be something else out there - but we didn't need to modify it.)

    In the Packing station, we have it set up to open the BOL when we close the order, not on create of the BOL, but it is two options that we have manipulated:
    Packing Rule - Bill of Lading, Open BOL on Close Order and Do not show BOL on create are checked so the BOL opens when we close the shipment.


    ------------------------------
    Stuart Ness
    IT Coordinator
    Mrs. Gerry's Kitchen, Inc
    Albert Lea MN
    ------------------------------

    Conference-BCNAVUG_200x200


  • 17.  RE: Lanham EDI ASN - Need help resolving issue: Same UCC for all items

    TOP CONTRIBUTOR
    Posted 13 days ago
    Interesting.

    All of out packing stations are set up like this:



    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

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

    NAVUG/D365BC-User Group Focus
    May 18-19, 2019
    Denver, Colorado
    ------------------------------

    Conference-BCNAVUG_200x200


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