Filter inventSum datasource on physicalInventCalculated method

(0) Share

Report

Posted on by Hassan Akhtar Khan

240

I have a form where InventSum table is being used as one of the data sources. I need to remove the lines from the form where InventSum.physcialInventCalculated() is 0.

The method has the following calculation in it:

display public InventQtyPhysicalOnhand physicalInventCalculated()
{
return this.PostedQty + this.Received - this.Deducted + this.Registered - this.Picked;
}

So in other words if the above-mentioned calculation equals 0 then that line of InventSum should not be displayed in the form.

Is there any way to achieve this functionality through form code?

I have the same question (0)

All responses (8)

Answers (1)

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

Like (1)

Report

Hi Hassan,

You posted the question in the Dynamics 365 Finance forum and also used the tag "AX2012". What version are you using?

Was this reply helpful? Yes No
Hassan Akhtar Khan 240 on at

Like (0)

Report

Oh sorry, posted in wrong forum.. It is related to AX 2012.

Is there any way to change the forum or I should ask the question again in different forum?

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

Like (1)

Report

I have moved it for you now.

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

Like (0)

Report

Hi Hassan,

On the Dimension display settings (button usually on all forms using data based on InventDim), there is an option to set quantities <> 0.

Was this reply helpful? Yes No
Hassan Akhtar Khan 240 on at

Like (0)

Report

Thanks Andre for your help.

As for your answer, I need to apply filter on the basis of some custom control, besides there is no such option available in the Dimension display settings of this form.

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

Like (0)

Report

Hi Hassan,

Which exact form do you want to apply the filter or is it a custom form?

Was this reply helpful? Yes No
Hassan Akhtar Khan 240 on at

Like (0)

Report

Hi Andre,

Its "Shelf advice as of date" form in inventory management. (AOT name: PdsInventBatchShelfAdvice)

BTW can we add 'quantity <> 0' option if it is not already available?

Was this reply helpful? Yes No
Verified answer

Hassan Akhtar Khan 240 on at

Like (0)

Report
I have achieved the output through following steps:

Created a view for InventSum table.

Added a computed column 'physicalInventCalculated' in the view and implement the same calculation in that method as the display method with the same name in InventSum table.

Joined the InventSumView with InventSum table datasource in my form and applied the filter on the physicalInventCalculated field of the view.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Filter inventSum datasource on physicalInventCalculated method

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Filter inventSum datasource on physicalInventCalculated method

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 > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates