Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Inventory Best Practices - Food and Agriculture

Posted on by Microsoft Employee

Hello.

We are a National Food Distributor and are looking at implementing Lot Tracking in Dynamics GP for all of our Consumable Food products.  There is also talk of implementing Serialized tracking of our Consumable Food products as well.  Can anyone point me to beat practices in the industry for Lot Tracking and the base way to implement it especially regarding whether the product should be tracked by serial numbers as well.  Also, can anyone related their personal experiences with how lot Tracking in GP has worked out for them.  Thanks for you assistance.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Best Practices - Food and Agriculture

    Lot tracking in GP is pretty powerful. I've implemented it before in a couple of different manufacturing environments. There's a nice feature that might be useful to you that allows you to track expiration dates. I don't have much experience with that specific feature, but I do believe that there's some logic behind it that helps prevent users from using lots that are expired (or near expiration). There are also a couple of inquiry windows and reports that help when there's a product recall.

    The points at which you'll be required to enter lot numbers in a distribution environment are: order fulfillment (and returns), purchase receipts (and returns) as well as any transaction in inventory series.

    Do you already have GP up and running? Or are you in the process of implementing it? Either way, I'd recommend involving your GP partner in this process.

    I will warn you that it's a lot easier to turn on than it is to turn off, so if you've already got GP up and running I'd definitely turn it on for a few items in your test environment and see how it plays out. You should also consider how you're going to handle on-hand inventory of any item that you decide to lot track.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans