Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

new fields are appearing as unretrieved

Posted on by 3,024

statusandremarks.png

Dear Experts,

Created two 2 fields status and remarks on On hand form, but unretrieved, i check all post and did anything but not working for me help!! I restarted AOS client machine even server refresh cashe from tool  etc but there is no luck.

best Regards,

Shabir Ahmad

  • Suggested answer
    Vishal Dhavgaye Profile Picture
    Vishal Dhavgaye 405 on at
    RE: new fields are appearing as unretrieved

    Hi Shabir,

    This can be handled with 'Inventory status change'. I don't think adding columns on 'OnHand' is the ideal solution here. What version of AX you are on?

    Please refer this,

    community.dynamics.com/.../whs-standard-procedure-to-change-inventory-status

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: new fields are appearing as unretrieved

    RejectColumn123.png

    Nikolaos Mäenpää,

    Sorry for late reply i was busy, the purpose of this column will be to shows that warhouses which have rejected materials. When our Quality control or warehouse  wants  to change the status of inventory to "Release or Rejected " all the inventory goes to rejected for example if we reject 15 qty in that warhouse all the inventory will be rejected so to differentiate that i want to create this column.

    Best Regards,

    Shabir Ahmad

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: new fields are appearing as unretrieved

    You can't write into the fields because the grid is not showing actual records of the database, it's showing summarized data.

    The data is coming from InventSum, but you might have 50 InventSum records shown as one row in the grid.

    What would these remarks / comments be used for? What kind of information would they contain? I'm interested in the actual business requirement because perhaps it can be resolved in some other way.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: new fields are appearing as unretrieved

    Hi Nikolaos Mäenpää,

    The purpose of these fields will be just remarks are info about the row, the user will wirte some comments.

    Best Regards,

    Shabir Ahmad

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: new fields are appearing as unretrieved

    Can you explain a bit what the purpose of these fields is?

    Would the user write some comments on the On hand form?

    Because the nature of this form is that you can summarize records by different criterias, it's not so easy to add comments on the data.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: new fields are appearing as unretrieved

    Hi Nikolaos Mäenpää,

    ok, but i want to add two fields in this form inventonhandItem. How could i do i already create new fields in inventsum and drag and drop to the overview tab but no luck.

    Best Regards,

    Shabir Ahmad

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: new fields are appearing as unretrieved

    InventOnHandItem is using group by statements when fetching data. This means that any fields that are not used in the grouping will not have any value. Perhaps this explains your problem?

  • Suggested answer
    Fangyuan Hou Profile Picture
    Fangyuan Hou on at
    RE: new fields are appearing as unretrieved

    Can you please try following steps.

    1. Tools -> Caches -> Refresh elements
    2. Restart the AOS.

    If this does not resolve this issue, please capture the AX trace and check whether the sql statement will return the value for these two fields.

  • Suggested answer
    Vishal Dhavgaye Profile Picture
    Vishal Dhavgaye 405 on at
    RE: new fields are appearing as unretrieved

    This is know issue, can you try all these steps discussed here,

    community.dynamics.com/.../461149

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: new fields are appearing as unretrieved

    Hi Vishal Dhavgaye,

    InventSum table is the table where i added both fields to display it on On hand form inventory management. Yes, i successfully synchronized.

    Best Regards,

    Shabir Ahmad

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

Product updates

Dynamics 365 release plans