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
33%
Installation Wizard into new VRC
39%
Manual into existing VRC
6%
Manual into new VRC
22%
Total votes: 49

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 11th August 2010, 18:26
becks22's Avatar
becks22 becks22 is offline
Member
 
Join Date: Aug 2008
Posts: 95
becks22 is on a distinguished road
Baan: BaaN IV - DB: sql - OS: xp
Order Number to be generated while saving
Baan: Other/Unknown
C/S: None/Unknown

Hi All,
I have a problem ..I have developed a new maintain Session ..in the order field of that session I am first inserting the series number and then after clicking on the save the order number should get generated ..How can I achieve that ?? Shall I use AFS or any thing else
Reply With Quote
  #2  
Old 11th August 2010, 19:01
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,720
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
First free numbers

Quote:
Originally Posted by becks22 View Post
Hi All,
I have a problem ..I have developed a new maintain Session ..in the order field of that session I am first inserting the series number and then after clicking on the save the order number should get generated ..How can I achieve that ?? Shall I use AFS or any thing else
Hello,

you can do it like first free order numbers in B4 standard is handled.

Create a second table for order numbers.
By save, read the last order number in the above table and increment by 1.
save this order number in the table and use it in your session/table.

Regards
__________________
//Bernd
Reply With Quote
  #3  
Old 24th August 2010, 09:02
rp.chowdary rp.chowdary is offline
Member
 
Join Date: Feb 2009
Posts: 32
rp.chowdary is on a distinguished road
Baan: ERP Ln 6.1 - DB: SQL Server 2008 R2 - OS: Windows Server 2008 R2
field.tdsel017.pono:
before.input:
tdsel017.pono = next.sr.number()


functions:

function domain tcsrnb next.sr.number()
{
last.srno = 0
search.last.used.sr.number.in.table()
search.last.used.sr.number.on.screen()
if last.srno > 98 then
return(0)
endif
return(last.srno + 10)

}

function search.last.used.sr.number.in.table()
{
select tdsel017.gpno, tdsel017.pono:last.srno
from tdsel017
where tdsel017._index1 = {:tdsel017.gpno,:tdsel017.pono}
order by tdsel017._index1 desc
as set with 1 rows
selectdo
endselect
}

function search.last.used.sr.number.on.screen()
{
| domain tcacoc occ.no | occurrence number
domain tcpono occ.no

for occ.no = 1 to (filled.occ - 1)
do.occ.without.update(occ.no,check.last.used.sr.number)
endfor
}

function check.last.used.sr.number()
{
last.srno = max(tdsel017.pono,last.srno)

}



tdsel017.pono is a seq field.

try this one..
__________________
Rp
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
Handling Unit functionality baazigar Distribution, Transportation & Warehousing 4 19th February 2012 15:54
Dal king1980 Tools Development 6 19th March 2010 12:10
Audit file structure baan_user Tools Development 8 4th May 2007 14:32
warehouse order number vishbaan Distribution, Transportation & Warehousing 7 31st March 2004 20:30
NO Transport order generated sammeer Distribution, Transportation & Warehousing 4 7th June 2003 08:02


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


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