Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

How to modify a Item Qty On Hand flow field in AL language

Posted on by 5

The Inventory flow field in the Item table doesn't include Date filter in its calculation .

How do I create an extension to modify the field to include that?

Thank you

  • YUN ZHU Profile Picture
    YUN ZHU 73,035 Super User 2024 Season 2 on at
    RE: How to modify a Item Qty On Hand flow field in AL language

    Hi, because the property 'CalcFormula' cannot be customized, you should create a new field, and then hide the original field

    pastedimage1674522644184v1.png

    Hope this helps

    Thanks.

    ZHU

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: How to modify a Item Qty On Hand flow field in AL language

    Never try to change the number in a flowfield.

  • Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: How to modify a Item Qty On Hand flow field in AL language

    Hi,
    Unfortunately we can not modify existing flow field of table.

    Thanks.

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,114 Super User 2024 Season 2 on at
    RE: How to modify a Item Qty On Hand flow field in AL language

    You cannot.

    You have to create a new flowfield with the required filters if your requirement is just to show on the page but it is difficult if you want to replace the new field in all the places of the existing flowfield in code.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans