Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

SQL for last date where inventory was counted for an item

Posted on by 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

  • Mohana Yadav Profile Picture
    Mohana Yadav 59,127 Super User 2024 Season 2 on at
    Re: SQL for last date where inventory was counted for an item

    good. Thank you for letting us know..

  • Verified answer
    Martin Andersen Profile Picture
    Martin Andersen 140 on at
    Re: SQL for last date where inventory was counted for an item

    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 59,127 Super User 2024 Season 2 on at
    Re: SQL for last date where inventory was counted for an item

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

    Did you get what you are searching for?

  • Martin Andersen Profile Picture
    Martin Andersen 140 on at
    Re: SQL for last date where inventory was counted for an item

    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 59,127 Super User 2024 Season 2 on at
    Re: SQL for last date where inventory was counted for an item

    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
    Re: SQL for last date where inventory was counted for an item

    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 59,127 Super User 2024 Season 2 on at
    Re: SQL for last date where inventory was counted for an item

    What do you mean by last Counted in Inventory?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans