Skip to main content

Notifications

Announcements

No record found.

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

Inventory count - report on last count date?

(1) ShareShare
ReportReport
Posted on by 25
Company is new to Business Central and so am I, we've recently counted a large section of our inventory and would now want to complete the task by counting all the items that do not yet have a last counted date.
We're trying to follow the information available in Count, Adjust, and Reclassify Inventory - Business Central | Microsoft Learn , our location does not use directed put away/pick.
The goal is to implement cycle counting for our inventory.
 
 
When we try to calculate the inventory from the physical inventory journal's tasks page, I can't find an option in the filters to target this date field.
I tried using the calculate counting period action, but running it gives us a list of all items, even if the quantity in inventory is 0
 
 
How can we print a document or assign tasks to our warehouse staff to count items that have not yet been counted, of which our inventory is not 0?
  • Suggested answer
    Sasa Milanovic Profile Picture
    Sasa Milanovic 18 on at
    Inventory count - report on last count date?
    Hello,
     
    As one of the comments said before, you could try to use Phys. Inv Orders.
    I'm sending you the link, there are some variations on this proces, so you could look some of them How to use Physical Inventory Orders for structured Inventory Counting - Dynamics 365 Business Central (usedynamics.com)
    It is in video form, so it will be easy for you to setup it in your database.
  • MH5 Profile Picture
    MH5 25 on at
    Inventory count - report on last count date?
    @gdrenteria , do I understand correctly, there's no direct filter for the 'Last Phys Invt Date' field, but using inventory orders will output items when their next counting start date < posting date?
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,802 Super User 2024 Season 2 on at
    Inventory count - report on last count date?
    Hi, you can also try physical inventory order.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 13,011 Most Valuable Professional on at
    Inventory count - report on last count date?
    Hi
    If you can identify the products by a field, or category, or location, you could filter them from the report.
     
    Implementing cycle counting functionality will help you a lot.
    BR
    GR

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans