Hi,
How can I make 'Warehouse' field in Sales Order mandatory? Any Ideas?
*This post is locked for comments
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
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 set the property as mandatory before posting this. It did not just take effect on the lines which are already created.
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.
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.
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156