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?
1. inventory MANAGMENT > counting journal > New Batch
2. Create Lines for counting as per your criteria
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
Can you give steps please in ax
Yes You can download counting journal , export to excel and publish the same.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 260
André Arnaud de Cal... 203 Super User 2025 Season 2
Yng Lih 142
