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 :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / SQL for last date wher...
Microsoft Dynamics NAV (Archived)

SQL for last date where inventory was counted for an item

(0) ShareShare
ReportReport
Posted on by Martin Andersen 140

I need the date where an item was last counted in inventory.

I can see the field inside dynamics on the "item card"'s "inventory" tab. 

I've found the table "Item Journal Line" to contain information about inventory counts but the information doesn't completely match the data inside dynamics. Therefore I'm thinking I'm looking in the wrong place/table.

In what table and column should I look to find the information I'm searching for?

*This post is locked for comments

I have the same question (0)
  • Mohana Yadav Profile Picture
    Mohana Yadav 61,204 Super User 2026 Season 1 on at

    What do you mean by last Counted in Inventory?

  • Martin Andersen Profile Picture
    Martin Andersen 140 on at

    Sorry my english. It could be better. I'll try to rephrase.

    Every year we do a status count of all items in stock. I need the date when the item was last counted to be updated with the actual amount in stock.

  • Mohana Yadav Profile Picture
    Mohana Yadav 61,204 Super User 2026 Season 1 on at

    You can go to Item Card

    Click Item-->Statistics-->Entry Statistics

    You can find when it was last Purchased or sold etc.

  • Martin Andersen Profile Picture
    Martin Andersen 140 on at

    Actually the date I need is on the "Warehouse" tab on the item card. I have a danish version. So it's a bit hard for me to explain exactly where.

    Here is an image that shows it:

    :

  • Mohana Yadav Profile Picture
    Mohana Yadav 61,204 Super User 2026 Season 1 on at

    I am not sure whether its a standard field or custom field.

    Did you get what you are searching for?

  • Verified answer
    Martin Andersen Profile Picture
    Martin Andersen 140 on at

    Actually I found the answer myself. I thought I was lost but found my way anyway. The table I was looking for was named: "Phys_ Inventory Ledger Entry".

  • Mohana Yadav Profile Picture
    Mohana Yadav 61,204 Super User 2026 Season 1 on at

    good. Thank you for letting us know..

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans