Announcements
No record found.
Hi,
How can I make 'Warehouse' field in Sales Order mandatory? Any Ideas?
*This post is locked for comments
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.
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?
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.
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.
I set the property as mandatory before posting this. It did not just take effect on the lines which are already created.
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
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.
TL
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
