Microsoft Dynamics AX (Archived)

Setting Fields in Sales Line as mandatory

(0) Share

Report

Posted on by blue_dreamer61@yaho...

1,606

Hi,

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

*This post is locked for comments

All responses (7)

Answers (2)

Community Member Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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

blue_dreamer61@yaho... 1,606 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

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.
blue_dreamer61@yaho... 1,606 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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.