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 :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Inventory counting

(0) ShareShare
ReportReport
Posted on by 20

Is there a way we can download the entire inventory list in Excel and perform counting and update the same excel and upload to F&O so that correct physical inventories are updated in system?

I have the same question (0)
  • Suggested answer
    saurabh bharti Profile Picture
    15,039 Moderator on at

    Yes You can download counting journal , export to excel and publish the same.

  • Deepakjoshi17 Profile Picture
    20 on at

    Can you give steps please in ax

  • Suggested answer
    saurabh bharti Profile Picture
    15,039 Moderator on at

    1. inventory MANAGMENT > counting journal >  New Batch

    2. Create Lines for counting as per your criteria

    pastedimage1626321743603v1.png

    3. Open in Excel by clicking Office button on form next to attachment 

    Note: If you don't have listed template , you can create:

    https://exploredynamics365.home.blog/2020/10/18/design-your-own-open-in-excel-template-in-microsoft-dynamics-365-finance-and-operations/

    data entity to be used :

    Inventory counting journal headers

     Inventory counting journal lines

    4. Enter your Counted quantity

    5. Publish back to D365

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 > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 256 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 205 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 128 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans