acumatica generic inquiry MAX , MIN

Question

When writing a generic inquiry is there any way to include a clause for max, min filter. For example how do you write a generic inquiry to get last purchase order for suppliers. or last purchase price for items which is a typical example.

Supplier A PO005 Supplier B PO007

Thanks

Answer 1

There is a hidden column with Aggregate function on the GI Designer. You can use for define function for each separate field. Default function is Max()