Announcements
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 achieved the output through following steps:
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?
Hi Hassan,
Which exact form do you want to apply the filter or is it a custom form?
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.
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.
I have moved it for you now.
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?
Hi Hassan,
You posted the question in the Dynamics 365 Finance forum and also used the tag "AX2012". What version are you using?
André Arnaud de Cal...
294,095
Super User 2025 Season 1
Martin Dráb
232,866
Most Valuable Professional
nmaenpaa
101,158
Moderator