Question

PO Lines into Ascending /Descending Order

  • 7 March 2023
  • 1 reply
  • 27 views

Userlevel 4
Badge +10

Good Afternoon - Can you please advise how the PO ‘Lines No Column’ can be arranged into either ascending or descending order - Many thanks

 

 


1 reply

Userlevel 3
Badge +8

Hello,

Within the ‘Advanced’ Search ‘SQL’ tab you can enter a SQL order by.

I have entered LPAD(SOURCE_REF2,4). This will order the line no as if it was a proper number.

Thanks,

Jamie

Reply