Skip to main content
Question

PO Lines into Ascending /Descending Order

  • March 7, 2023
  • 1 reply
  • 46 views

Forum|alt.badge.img+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

COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • March 9, 2023

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