Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / On-hand inventory to e...
Microsoft Dynamics AX (Archived)

On-hand inventory to excel

(0) ShareShare
ReportReport
Posted on by sri17 340

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 340 on at
    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 at
    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 340 on at
    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 at
    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 340 on at
    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 at
    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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans