iDempiere: Limit the Number of Records Shown

Go to

Window Tab & Field on the System Role search for your desired document (in my case Purchase Order) and on the {{Sql WHERE}} field add your condition.

In my case:

C_Order.IsSOTrx=’N’ AND C_Order.em_mg_procurement=’Y’

Leave a Reply

Your email address will not be published. Required fields are marked *