Define defaultSort on Invoice

Description

User would like the AP Invoice grid sorted by default as is with the other transaction grids. 

Improve sorting of Invoice grid by defining a default sort on the Invoice. The grid is currently being sorted when the grid is created via UI code and will not apply if the user does not have the date and/or PO # in the grid.

LegacyInvoice has a formula for purchaseOrderNumber while the super class Source has a getter: getPurchaseOrderNumber(). QueryBuilder is getting the property as just "purchaseOrderNumber", not the expected "source.purchaseOrderNumber" when setting the defaultSort to ["date=DESC","source.purchaseOrderNumber=DESC"]. The property descriptor for purchaseOrderNumber is a VUIMethodPropertyDescriptor, which is to be expected due to the getter on Source.

Research and fix.

Environment

None

Activity

Former user December 19, 2019 at 4:45 PM

Updated Transaction > AP Invoices > Search/View AP Invoices section

Robin Fronk November 15, 2019 at 6:18 PM
Edited

Testing Notes:

The invoice grid will sort on the date in descending order, then purchase order number in descending order even when the date and PO # are not in the grid. 

  • Navigate to the AP Invoice UI and verify the grid is sorted correctly.

  • Remove the date column from the grid and verify the grid is still sorted.

  • Remove the PO # column from the grid and verify the grid is still sorted.

Fixed

Details

Assignee

Reporter

Story Points

Fix versions

Documentation Required

Completed

Time tracking

4h logged

Sprint

Priority

Better PDF Exporter

Created September 30, 2019 at 6:23 PM
Updated December 19, 2019 at 4:45 PM
Resolved December 19, 2019 at 4:45 PM