Microsoft Dynamics NAV (Archived)

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

(0) Share

Report

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

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

keoma 32,729 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Lars Hædersdal 750 on at

Like (0)

Report

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 .

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Rajasekhar@MS 5,569 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Lars Hædersdal 750 on at

Like (0)

Report

Hmm i dont have that report?

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Rajasekhar@MS 5,569 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Lars Hædersdal 750 on at

Like (0)

Report

ok thx :-)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No