Showing Date of Batches Form on On-Hand Form

(0) Share

Report

Posted on by Shabir Ahmad

3,110

Dear Experts,

I want to show a date field name is "Retest Date" on On-Hand form( field the "Retest Date" Date is on Batches form inventory Management Module. )The field is on Batches form but i want same on (On hand Form) as well.

Thanks and Regards,

Shabir Ahmad

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

André Arnaud de Cal... 301,146 Super User 2025 Season 2 on at

Like (1)

Report

Hi Shabir,

To get the correct results, you have to go deep in coding. The reason is that the form is not showing direct table result sets, but is showing calculated data based on aggregated queries. One row could potentially summarize multiple batch numbers. What is the business requirement to have this field on the on-hand form/what would be the purpose?

Was this reply helpful? Yes No
Verified answer

Shabir Ahmad 3,110 on at

Like (0)

Report

Thanks André Arnaud de Calavon for your reply and your view, the purpose of my this question was just to show a date of Batches form on On-Hand form same as this was our warehouse requirement. But the issue has been resolved by writing the below code on table then create a field on the certain grid and reference to table datasource(on that field property ) and data method:

display InventBatchExpDate findInventBatchExpDate()

{

InventBatch inventBatch;

InventSum inventSum;

InventBatchId InventBatchId;

InventBatchExpDate InventBatchExpDate;

select * from InventBatch where inventBatch.itemId == this.ItemId;

return InventBatch.mod2RetestDate;

}

Thanks and Regards,

Shabir Ahmad

Was this reply helpful? Yes No
André Arnaud de Cal... 301,146 Super User 2025 Season 2 on at

Like (1)

Report

Hi Shabir,

Thanks for your feedback. I don't think the coding is correct for some reasons. I'm sorry to say there are some major issues here:

- It will return an unpredicted batch as this is not part of the where clause; you are only using the item ID as input.

- You are getting as result a set with all records of the batches which belongs to this item. (performance degradation as no firstonly command is used in the select statement)

- You are asking for all columns (*) and you are using only the mod2RetestDate. This is also a performance degradation.

I would recommend to review and test carefully.

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

Dear André Arnaud de Calavon,
Thanks for sharing your valuable view and suggestion, i would like to know the correct code for this. Please would you share because the code which i shared has already done my work please check in the screenshot.As this was my requirement, if you have some other kind of code, so share i would definitely use that code as well.

Thanks and Regards,
Shabir Ahmad

Was this reply helpful? Yes No
André Arnaud de Cal... 301,146 Super User 2025 Season 2 on at

Like (1)

Report

Hi Shabir,

I don't have an example available. Usually, I try to avoid adding it on this form, but make use of other forms for date information related to batch numbers. On e.g. a new form, you can join the Items, Batches, InventSum with the additional opportunity to sort and filter on date fields from the batch table. With a display method it is not possible.

Was this reply helpful? Yes No

Community site session details

Showing Date of Batches Form on On-Hand Form

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Showing Date of Batches Form on On-Hand Form

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates