The Warn property only works on detail views, it won’t stop or warn the number of records on an overview screen or tab. When you are on the Purchase Order Line Part tab, that is why it is greyed out. On the detail view, like the Purchase Order header, that number in the field will control when the warning appears.
I’m not sure what the Extended Field Validation does however.
Thank you @ShawnBerk . I got “The Warn property” works, i missed this option before. It is so usefull.
So is there anyway to fetch only 40 rows purchase order lines instead of all lines when opening the “Purchase Order” screen? For example, “Purchase Order Lines” list screen works like this, i mean it fetches few lines first, then if we go to under zones fetches more lines.
Maybe we can set this option on somewhere but i dont know this.
Best Regards.
I don’t know of a way on a regular overview screen to limit the rows on the result, you will get whatever the query returns. You can’t limit on the SQL expression because it starts with the WHERE clause and to limit the number of results requires inserting additional parameters before the WHERE statement which isn’t accessible.
It is at this point that I would train the users to learn how to narrow their search criteria rather than attempting to find a system solution. Artificially limiting the rows has the potential for blocking or hiding important information when it is needed, so I feel it is of limited benefit.
I got it @ShawnBerk . Thank you so much.
Best regards.
I found the other one after posting this but thanks for the helpful instruction. Hopefully it didn't confuse you too much. They should write instructions on how to handle two questions on the same topic.