Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
14%
200 - 500 GB
32%
500 - 800 GB
4%
800 - 1200 GB
4%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
21%
Total votes: 28

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 11th August 2010, 19: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, 20:01
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,725
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
Sponsored Links
  #3  
Old 24th August 2010, 10: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
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 16:54
Dal king1980 Tools Development 6 19th March 2010 13:10
Audit file structure baan_user Tools Development 8 4th May 2007 15:32
warehouse order number vishbaan Distribution, Transportation & Warehousing 7 31st March 2004 21:30
NO Transport order generated sammeer Distribution, Transportation & Warehousing 4 7th June 2003 09:02


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


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