web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Lot number reporting

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Verified answer
    Rabin Profile Picture
    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

  • Suggested answer
    Ashwini Tripathi Profile Picture
    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

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,096 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.

  • Community Member Profile Picture
    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.  

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#2
SC666 Profile Picture

SC666 1

#2
SC666 Profile Picture

SC666 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans