0

Sort Line

Benoit

March 30, 2018 00:07

None

Follow

Hi,

 

I use Jet express for work to create sales document in NAV.

But I can not find any way to sort the line item I wanted.

Where in the layout I can choose how to sort lines item?

 

Thank you

Ben

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Harry Lewis April 02, 2018 14:29

  Hello Ben -

  The NL(Table) function returns records in the same order as they appear in the NAV table.

   

  

  If you use Excel's Pivot capabilities, you can use the Pivot Table's sort feature:

  

• 0
  
  Benoit April 04, 2018 23:54

  Hi Harry,

   

  Thank you for your reply

  Sorry I am not clear in my post.

  The report I run is in Jet Express for word. And it do not have the sort function

   

  Thank you

  Ben

• 0
  
  Harry Lewis April 05, 2018 13:43

  Thank you, Ben.

  Just for future reference, you will probably want to post any future questions in the Jet Express for Word forum:

  

   

  Jet Express for Word provides MS Word-based editing capabilities for your NAV reports.  Since those reports use the existing datasets that are created within NAV, itself, any sorting would have to be done within the dataset on which your report is based.