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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
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?
I have the same question (0)
  • Suggested answer
    Gerardo Rentería García Profile Picture
    25,169 Most Valuable Professional on at
    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
  • Suggested answer
    YUN ZHU Profile Picture
    95,331 Super User 2025 Season 2 on at
    Hi, you can also try physical inventory order.
     
    Hope this helps.
    Thanks.
    ZHU
  • MH5 Profile Picture
    25 on at
    @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
    Sasa Milanovic Profile Picture
    18 on at
    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.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans