Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Inventory

(2) ShareShare
ReportReport
Posted on by 90
Hello,
New to BC365. I'm trying to verify my inventory the problem is my products have a part number, lot and expiration date and a bin location. All of these including the quantity for each lot needs to be verified. some part numbers may have multiple lots.
I am unable to find any document or list that I can use to verify my inventory. Not just the quantity. I need lots, Expiration dates and bin locations. I've tried Physical Inventory, Count sheets and pretty much anything that has inventory in it. 
The Physical inventory count sheet gives me Item# but no bins, no quantities, no lots or Expiration dates.
I'm coming from an SAP background where just a couple clicks and I can print out my entire inventory, where each item is and their lots + expiration dates. Then I can physically verify and record anything that doesn't match.
Does anyone have any insight into something like this? I'm stuck and can't seem to find any answers to this relatively simple task.
Thanks
  • Brad613 Profile Picture
    Brad613 90 on at
    Inventory
    Thank for the reply.
    In the personalize/configure I don't have the fields Lot and EXP date to add.
    There is no LOT or EXP to add...
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 5,127 Super User 2025 Season 1 on at
    Inventory
    You may not be showing the fields on your Physical Inventory Journal.  You can use the Personalize/Configure option to display the Lot and Expiration Date fields, as shown in the below example (Warehouse Physical Inventory Journal):
     
    Hope this helps get you moving in the right direction.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Martin Dráb Profile Picture
    Martin Dráb 230,817 Most Valuable Professional on at
    Inventory
    Moved from Integration, Dataverse, and general topics forum.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans