Moving or adding Sorting Filter

rico1931
rico1931 Member Posts: 295
in NAV Three Tier
Hi Everyone,

is there a way to add or move a sorting filter on a report? I want to add/move the sorting filter from Customer to Sales Order Line instead. vhp6068lu71i.jpg

Thank you
-rico1931

Best Answer

  • Aluan
    Aluan Member Posts: 164
    edited 2022-06-08 Answer ✓
    Hello rico1931,
    in the Report you have to remove the Key (DataItemTableView), from the Sales Line.
    So it should look like this afterwards: 
    WHERE(Document Type=CONST(Order),Outstanding Quantity=FILTER(<>0))

Answers

  • Aluan
    Aluan Member Posts: 164
    edited 2022-06-08 Answer ✓
    Hello rico1931,
    in the Report you have to remove the Key (DataItemTableView), from the Sales Line.
    So it should look like this afterwards: 
    WHERE(Document Type=CONST(Order),Outstanding Quantity=FILTER(<>0))

Categories