Notifications
Announcements
No record found.
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
What table you have added these fields or are these display fields? I hope you completed synchronization successfully.
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,
This is know issue, can you try all these steps discussed here,
community.dynamics.com/.../461149
Can you please try following steps.
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.
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?
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.
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.
The purpose of these fields will be just remarks are info about the row, the user will wirte some comments.
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.
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.
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 449 Super User 2025 Season 2
Martin Dráb 422 Most Valuable Professional
BillurSamdancioglu 239 Most Valuable Professional
