Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Lot number reporting
Microsoft Dynamics NAV (Archived)

Lot number reporting

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi I am trying to figure out a way to be able to drill into a lot number to see the flow that the item attached to the lot number traveled.  So basically I am

  • setting an item to require lot tracking (all)
  • creating a purchase order, posting and receiving
  • creating a sales order for an item that uses the lot tracked item, creating a released production order
  • Using the consumption journal to post the components against the production order
  • Using the output journal to post the finished production

 

So what I want is the easiest way to enter the lot number, and see all of these documents that the related lot number passed through

 

Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Lot number reporting

    Thanks Alexander. Quick question I hope you can help me with. I've posted components in the production journal, when trying to post in the output journal, I get the error that the component I posted (with lot numbers), requires lot numbers.  

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Lot number reporting

    You can use Item Tracing functionality (e.g., Departments/Warehouse/History/Item Tracing) and enter lot number there. Also, you can try to filter the Item Ledger Entry table by the Lot No. field to get the related records.

  • Suggested answer
    Ashwini Tripathi Profile Picture
    Ashwini Tripathi 4,624 on at
    RE: Lot number reporting

    Checkout this MSDN link if it helps you in any way : msdn.microsoft.com/.../hh174273(v=nav.90).aspx

  • Verified answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: Lot number reporting

    Hi Matt,

    To understand this first you have to understand LOT concept...

    The interesting part is you can create an example that includes, Purchase, Manufacturing and Sales and then Track any item from the time of Purchase. It is complex to understand all the different setup and its implications.  So the best way is to read out the blogs first...

    In short i can say that when you purchase any item, before purchase complete the item card setup with LOT Tracking on. And then while purchasing use the LOT TRACK, while manufacturing as well use the Lot of different components and finally see how the consumption of item is guided by lot tracking...

    Try reading out following blogs:

    www.archerpoint.com/.../lot-and-serial-tracking-microsoft-dynamics-nav-clarified

    msdn.microsoft.com/.../hh174273(v=nav.90).aspx

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans