Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
34%
Installation Wizard into new VRC
41%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 29

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 11th August 2017, 09:21
kingsley143's Avatar
kingsley143 kingsley143 is offline
Member
 
Join Date: Feb 2008
Location: INDIA
Posts: 32
kingsley143 is on a distinguished road
Baan: Baan LN 6.1 - DB: Microsoft SQL server 2000 - OS: windows server 2003
Displaying data after zoom on session

Hi,

I have developed new maintain session on which input will be project No. and based on that i want to display all the invoice numbers for that project and user will enter RA Bill no. against any invoice no.
In this case, only last invoice is getting displayed. How can I display all the invoices related to project.

Screenshot of session is attached.
Below is my code:

Please help
Code:
field.cprj:
after.input:
	serial.num = serial.num + 1	
	get.details()
	get.contract()
	get.invoice.number()
	sern = serial.num
	serial.num = 0


function get.invoice.number()
{
	select	cisli310.*
	from	cisli310
	where	cisli310.cprj = {:cprj}
	selectdo
		invn = cisli310.tran&(str$(cisli310.idoc))
		display.curr.occ()
		select	cisli305.*
		from	cisli305
		where	cisli305._index1 = {:cisli310.sfcp,:cisli310.tran,:cisli310.idoc}
		selectdo
			if cisli305.stat = tcsli.stat.posted then
				flag = true
			endif
			bdte = cisli305.idat
		selectempty
			bdte = 0
		endselect	
	selectempty
		invn = ""
		bdte = 0
		serial.num = 0
		sern = 0
	endselect	
	
}
Attached Images
File Type: png Invoice_no.PNG (21.0 KB, 6 views)

Last edited by mark_h : 11th August 2017 at 21:47. Reason: add code tags
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
zoom to session and find record automatically timb25 Tools Development 11 25th April 2012 22:21
Handling Unit functionality baazigar Distribution, Transportation & Warehousing 4 19th February 2012 15:54
How to call AFS in sp24? PV Ramone AFS/DDC/OLE: Function servers 4 2nd September 2008 11:06
get data from tfgld3501m000 display session jmathew AFS/DDC/OLE: Function servers 10 31st October 2004 09:20
zoom to different session trchandra Tools Development 2 19th March 2002 03:58


All times are GMT +2. The time now is 22:19.


©2001-2017 - Baanboard.com - Baanforums.com