Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Serial Numbers
Microsoft Dynamics NAV (Archived)

Serial Numbers

(0) ShareShare
ReportReport
Posted on by spena 1,495

Hi!

How can I see a list of serial numbers on hand and the serial numbers that have been reserved?

When I open sales quote line or sales order line and go into Item Tracking Lines, and click the ellipsis next to Serial No, I see the the information I need. However, when looking at the corresponding table, the Entry Summary table (338), the table is empty. The Entry Summary is a temp table.

I need to find the correct source to pull a list of serial numbers in the system and the serial numbers that have already been reserved.

Thanks,

Steve

*This post is locked for comments

  • Suggested answer
    Saurabh Shah Profile Picture
    Saurabh Shah 4,560 on at
    RE: Serial Numbers

    Hi.

    Can you please verify the answer if it helps to solve your question.

  • spena Profile Picture
    spena 1,495 on at
    RE: Serial Numbers

    Yes, I think I will need to use the Item Ledger Entry table, and remove the serial number currently in the Item Reservation table.  Thanks.

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Serial Numbers

    If you want to see the reserved serial no. then you need to check reservation entry table.

  • spena Profile Picture
    spena 1,495 on at
    RE: Serial Numbers

    Hi Suresh,

    Thanks for the reply, but the Item Ledger Entry table does not show reserved serial numbers.  Imagine you're selling a serialized item.  If there are two on hand, but one serial number already exists on a sales order or sales quote, I need a way of seeing that there are two serial numbers on hand, but only one available to promise.

    Thanks,

    Steve

  • spena Profile Picture
    spena 1,495 on at
    RE: Serial Numbers

    Hi Saurabh,

    Thanks for the quick reply.  The item ledger shows the quantity and the remaining quantity, but it does not show a reserved quantity, so this table will not work for me.  I need to see the quantity reserved on an unposted quote or order.

    Thanks,

    Steve

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Serial Numbers

    The source for the Entry Summary table is Item Ledger Entry table, it has the serial no. information

  • Verified answer
    Saurabh Shah Profile Picture
    Saurabh Shah 4,560 on at
    RE: Serial Numbers

    why dont you look at the item ledger entry table. here you can get the item serial number wise ledger entry and where remaining qty is 1 are available in inventory. now if any serial number is reserved then you will also get the reserved qty from the same table against the ledger line.

    I hope you will get your information from here.

    Regards,

    Saurabh Shah

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