Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 45

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 28th August 2017, 06:02
ren_bsi ren_bsi is offline
Junior Member
Join Date: Dec 2015
Posts: 9
ren_bsi is on a distinguished road
Baan: LN 10.3 - DB: SQL Server 2008 - OS: Win Server 2008 R2
Sort Order advice needed
Baan: ERP LN 6.1 FP9 (Infor ERP 10.3)
C/S: Both

Hi to All,

I'm newbie to LN Programming and i have the following Code :
   select tdsls401.*
   from tdsls401
   where tdsls401.ptpa inrange {:orno.f} and {:orno.t}
   and tdsls401.item inrange {:item.f} and {:item.t}
   and tdsls401.qoor > 0
   order by tdsls401.orno asc, tdsls401.item desc |# -> Sort Order No.1
      no.pabean = tdsls401.orno
      tgl.pabean = tdsls401.prdt
      no.seri = tdsls401.item
      select tdsls400.*
      from tdsls400
      where tdsls400.orno = {:no.pabean}
         mata.uang = tdsls400.ccur
         select tcibd001.*
         from tcibd001
         where tcibd001.item = {:no.seri}
         and tcibd001.citg inrange {:citg.f} and {:citg.t}
            nama.barang = tcibd001.dsca
            select tdsls406.*
            from tdsls406
            where tdsls406.orno = {:no.pabean}
            and tdsls406.pono = {:tdsls401.pono}
            and tdsls406.sqnb = {:tdsls401.sqnb}
            and tdsls406.dldt inrange {:rcdt.f} and {:rcdt.t}
            and tdsls406.ttyp <> ""
            and tdsls406.invn <> 0
            order by tdsls406.shpm desc |# -> Sort Order No.2
               nilai.barang = tdsls406.damt
               jumlah = tdsls406.qidl
               no.receipt = tdsls406.shpm
               tgl.receipt = tdsls406.dldt
               ship.line = tdsls406.shln
            nama.barang = ""
The sort order no.1 is working fine but for sort order no.2 does not take effect.
Is there any other way to make the sort order no.2 working ?
Really appreciate your advice.
Thank you.

Best regards,
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Generate Purchase Order advice from sales order SoerenH Distribution, Transportation & Warehousing 2 5th March 2012 11:46
Dal king1980 Tools Development 6 19th March 2010 12:10
Sort Order on Baan Forms jcook331 Tools Development 7 2nd April 2008 23:00
Cannot generate Purchase Order Advice for Sales Order Moynao Distribution, Transportation & Warehousing 0 29th January 2007 19:24
NO Transport order generated sammeer Distribution, Transportation & Warehousing 4 7th June 2003 08:02

All times are GMT +2. The time now is 12:07.

©2001-2017 - -