Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Setting Fields in Sales Line as mandatory

Posted on by 1,606

Hi,

                     How can I make 'Warehouse' field in Sales Order mandatory? Any Ideas?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Setting Fields in Sales Line as mandatory

    I think mine works! Will post detailed instructions soon. In this process, just to make sure in case you have other fields mandatory as well, I'll create not only Warehouse, but also Site and Sales Unit. Hope this will be helpful.

    Thanks

    TL

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Setting Fields in Sales Line as mandatory

    I actually like the solution with both the Header and Lines. Do you happen to have the details (step by step) type in AOS-->Dimensions...?

    Thanks

  • Verified answer
    RE: Setting Fields in Sales Line as mandatory

    I set the property as mandatory before posting this. It did not just take effect on the lines which are already created.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Setting Fields in Sales Line as mandatory

    Ok, if it is required at header level then SalesTable itself having InventLocationId field

    so if you need this mandatory feature in all forms using SalesTable as datasource, and warehouse field to be mandatory, then you can set the inventLocationId field mandatory at table level only

    I just did it and now I can see the warehouse field mandatory on both SalesTable form and SalesTableCreate form.

    In your case if you need it on specific for then you should set the mandatory property at for datasource level.

    Please verify and update if this information helps you.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,113 Super User 2024 Season 2 on at
    RE: Setting Fields in Sales Line as mandatory

    Hi Wenchester,

    On which exaclty control did you set the InventLocationId mandatory? Was it on the form or the table SalesTable? I would recomment to do this on the field within the table itself.

  • RE: Setting Fields in Sales Line as mandatory

    I wanted to require the "Warehouse" filed in the Sales Order level. I already tried setting the InventLocationId, mandatory=yes. But it did not work.

    But the site is required, it prompts "Site must be filled in". I wanted to be like that too.

    Btw what is "InventDimGroup" a form? a table?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Setting Fields in Sales Line as mandatory

    Warehouse is part of InventDim ID and is available in InventDim Table as InventLocationId

    to make this field as mandatory on Sales order is by updating InventLocationId as mandatory field in InventDimGroup. If you do this then Warehouse will get mandatory in all place wherever it is found (like Purchase Order, Inventory Journals or Sales Order...)

    If your requirement is to have it mandatory at SalesOrder form level then you need to modify the datasource

    In SalesOrder form Datasource you will find InventDim table

    in inventDim there is InventLocationId field, set this field property (mandatory) as 'YES'

    Please verify and update if this information helps you.

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,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans