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

Announcements

No record found.

News and Announcements icon
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
    26,110 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
    100,212 Super User 2026 Season 1 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,012 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 986 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 659 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans