Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Is there a way to show...
Microsoft Dynamics NAV (Archived)

Is there a way to show Shelf No from the Item Card on the Pick List Repport?

(0) ShareShare
ReportReport
Posted on by Lars Hædersdal 750

I have a simple Item the Shelf No. to F4.

When I use that item on a Sales Order and prints the Pick Instruction it is not displayed.

Microsoft says

The Shelf No. field can be used as a basic manual storage system in environments without bins. It is copied from the item card to document lines and reports, but it is only informational. It is not used in warehouse activities requests or in availability calculations.

You can use the field to filter and sort the Inventory Picking List report according to the placement of items.


Anybody knows how that works?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is there a way to show Shelf No from the Item Card on the Pick List Repport?

    We have a simple warehouse layout. 700 items in 700 pick locations. We use 1 Picking List per Sales Order, bring all items together, palletise and then wrap / package up. Similar to Lars we would like the Shelf No to print out on the Picking List so our warehouse staff can go to the Correct Location rather than have a good memory of where things are stored. We don't need the hassle of creating Locations / Zones / Bins etc. as we do have and want to keep our warehouse operations and picking simple. Q - Can the Sales Order Picking List be configured to show the Shelf No or not?

    Thanks

    P

  • Lars Hædersdal Profile Picture
    Lars Hædersdal 750 on at
    RE: Is there a way to show Shelf No from the Item Card on the Pick List Repport?

    ok thx :-)

  • Verified answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: Is there a way to show Shelf No from the Item Card on the Pick List Repport?

    Please check if there is any other report available for the picking list with the shelf no, if not add the shelf no to your report.

    Regards

    Rajasekhar.Y

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Is there a way to show Shelf No from the Item Card on the Pick List Repport?

    create whse. shipment out of the sales order. then you can print the created whse. shipment. this report shows the shelf. no.

  • Lars Hædersdal Profile Picture
    Lars Hædersdal 750 on at
    RE: Is there a way to show Shelf No from the Item Card on the Pick List Repport?

    Hmm i dont have that report?

  • Suggested answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: Is there a way to show Shelf No from the Item Card on the Pick List Repport?

    Hi

    if you want to display the shelf no. you have to use the report Picking List by Order (10153) from the sales Orders

    Regards

    Rajasekhar.Y

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Is there a way to show Shelf No from the Item Card on the Pick List Repport?

    then a little change of the report is needed.

    add the column/field "shelf no." to the dataitem and then add the new report field to the rdl report.

    best regards

  • Lars Hædersdal Profile Picture
    Lars Hædersdal 750 on at
    RE: Is there a way to show Shelf No from the Item Card on the Pick List Repport?

    But the Shelf no is not displayed on the report and that is what I need :-)

    I know its easy to get the report to show Shelf No if you add it yourself to the report. I was just wondering if NAV had a standard way to do it .

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Is there a way to show Shelf No from the Item Card on the Pick List Repport?

    hi,

    i tried it with the item 1896-S "ATHENS Desk" using the demo database cronus. this item has a "shelf no." = "D2". i created a new sales order and added a sales line with that item.  i ran the report "pick instruction". the item is shown correctly.

    try this example and then create a new item similiar to that sample item. then check your item again.

    best regards

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans