Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
32%
Installation Wizard into new VRC
40%
Manual into existing VRC
6%
Manual into new VRC
22%
Total votes: 50

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 14th August 2018, 09:32
Premahari Premahari is offline
Member
 
Join Date: Mar 2018
Posts: 50
Premahari is on a distinguished road
Baan: InforLN 10.5 - DB: SQL Server - OS: Windows
Get last two records
Baan: ERP LN 6.1 FP11 (Infor ERP 10.5)
C/S: None/Unknown

Hi,
I want one report which contains item,item.type,transaction1,transaction2.
From warehouse Item Transaction,for particular item last transaction i want to update in transaction1 and last before record i want to update for transaction2.
Can anyone tell how to get this?
I tried this. Its fetching last two records but don know how to assign those to transaction 1 and transaction2.

select whinr110.*
from whinr110
where whinr110._index1 = {:whwmd210.item,:tiesc000.cwar}
order by whinr110.trdt DESC
as set with 2 rows
selectdo
endselect
Reply With Quote
  #2  
Old 14th August 2018, 14:00
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,114
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Setup some record buffers or just use temp variables to assign the fields you need for transaction 1 and transaction 2. For example you could have a trans.item(2) for the item - inside the select do set trans.item(1) to the first record then trans.item(2) to the second record. Then on the report you could print trans.item(1) and trans.item(2) on the same layout. Not really sure if I am answering your question.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
Reply


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
Can i get the non condition matched records in selectempty pralash Tools Development 3 22nd November 2017 10:42
Select distinct records thru query extension?? arajasek Tools Development 5 25th August 2010 07:24
Selecting Records for First Forms Post tslaton Tools Development 1 6th April 2006 23:18
PCS records not transfered from WIP to Cogs baanitm Finance, Invoicing and Integration 2 16th December 2005 09:26
Losed tfgld418 records - Urgent Help Please mprakash Finance, Invoicing and Integration 13 25th September 2004 09:26


All times are GMT +2. The time now is 04:56.


©2001-2018 - Baanboard.com - Baanforums.com