Skip to main content
Post a question

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id : cmft1OG7A48SKqjWjsI9n6
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / On-hand inventory to e...
Microsoft Dynamics AX (Archived)

On-hand inventory to excel

Like (0) ShareShare
ReportReport
Posted on 19 Nov 2018 04:44:33 by sri17 346

Hi All ,

The business users use on-hand inventory form to export the required inventory data by applying different filters and they also added some additional fields to on-hand inventory form by personalizing form views in Microsoft Dynamics AX to speed up the data entry or filter for required data.

While exporting the data, they have log out issues or screen freezes every time, which required to log out AX application and re-login.

Do you have any similar experience or what is the root cause of the issue and a possible solution to mend the issue?

*This post is locked for comments

  • sri17 Profile Picture
    sri17 346 on 19 Nov 2018 at 10:08:28
    RE: On-hand inventory to excel

    Thanks for the reply Magic.

    The form has couple of customized fields and they are not added to standard report , since users required more than 30 fields for reconcilation purpose and management report.

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on 19 Nov 2018 at 08:35:40
    RE: On-hand inventory to excel

    Why not print the on hand report to excel?

    Inventory management > Reports > On- hand > On-hand inventory:

    Select the information to ‘Print’. Use the Select button to setup the filter query for the data you need

    Click the Destinations… button. Enter a filename and select the File format Microsoft Excel:

    https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/on-hand-inventory-report-inventonhand

  • sri17 Profile Picture
    sri17 346 on 19 Nov 2018 at 06:41:25
    RE: On-hand inventory to excel

    Thanks again Ludwig for reply and help .

    The business users who tries to export data as cited above having issues .

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on 19 Nov 2018 at 06:09:49
    RE: On-hand inventory to excel

    Hi sri17,

    Do all users see the same system behavior or are only some affected by the freezing panes?

    Best regards,

    Ludwig

  • sri17 Profile Picture
    sri17 346 on 19 Nov 2018 at 05:35:52
    RE: On-hand inventory to excel

    Thanks for the reply.

    I'm very interesting to know the reason for logout  and screen freeze issues . Any insights on these ?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on 19 Nov 2018 at 04:47:47
    RE: On-hand inventory to excel

    Hello sri17,

    Can't you export all data from the on-hand inventory form and apply the filters in Excel?

    Would that be a workaround that help overcoming the problems you face?

    Best regards,

    Ludwig

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,440 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,575 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans