denlen
Newcomer
Member since ‎07-19-2019

User Statistics

  • 1 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

Can't use alias in a Service Layer SQLQueries ORDER BY clause

a month ago
HiI have tried to create an entry in Service Layer SQLQueries on SAP Business One 10  SP2402 with the following: select top 12 RDR1.ItemCode, sum(RDR1.Quantity) as Q from RDR1 where RDR1.DocEntry in (select top 50 ORDR.DocEntry from ORDR where ORDR.C...