Sort report by using Shipment date in Sales Line

Business Central/NAV User Forum
1

I developed Sales report using Sales Invoice Header table. and its Sort by posting date. Now i need to Sort the data by using shipment date in Sales Line table. I tried several ways but i couldn’t achieved it.

2

Do you have sales Line table in report dataitems or used it in globals?

3

Yes I Used Sales Line In Global

4

then try

SalesLine.SETCURRENTKEY(“Shipment Date”);

5

Sorry Mohana. Its not for Sort. I need to Filter from the shipment date in SalesLine Table. Sorry For mislead you.

6

You want to filter on Sales Line table or on Sales Invoice Header table?

and based on what field you want to filter…

7

I need to filter based on shipment date in Sales Line table.

8

then you have to filter like

SalesLine.SETRANGE(“Shipment Date”,);