Go Back > Forum > Baan SIGs > Archiving & Multisite

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 34

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 27th February 2002, 21:06
kclewley's Avatar
kclewley kclewley is offline
Junior Member
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 26
kclewley is on a distinguished road
Angry Finding Next Available First Free Number

Fellow Archivers:

I was wondering if anyone has gone through the process of resetting first free numbers? If so, I was wondering if someone could tell me if Baan should seek out and find the next available number in a given series, or if it just adds one to the number identified in the "First Free Number" field.

My problem is that we have many production orders that show as being available, but when I reset the "First Free Number" for this "Series," it tells me that it is "Unable to retreive first free number. Try again?" I am trying to understand how the first free number functionality works as it pertains to the production orders.

I guess I was under the impression that Baan seeked out the next 'available' number. For example, if a series was defined for number "20," and "Series" "20" had numbers "200010" and "200400" available, and I reset the "First Free Number" in this series back to "1," it would find number "200010" and then "200400."

But, in my tests, even when I have available numbers to use, it comes back and tells me that it is unable to retreive first free number. Is this standard functionality or is this a bug?

Thanks for the help,

Ken Clewley
Reply With Quote
Old 27th February 2002, 22:39
evesely's Avatar
evesely evesely is offline
Join Date: Dec 2001
Location: Lisle, Illinois USA
Posts: 412
evesely is on a distinguished road
Unhappy It acts like you suspect

First free numbers are taken sequentially. It does not truly look for "free" numbers, the are assumed to be so. I supposed that you could rewrite some of the tcmcsdll0004 functionality to do what you want. Perhaps there's another way, but I haven't seen such a thing.
Reply With Quote
Old 28th February 2002, 10:00
Neal Matthews's Avatar
Neal Matthews Neal Matthews is offline
Join Date: Sep 2001
Location: Nottingham
Posts: 483
Neal Matthews is on a distinguished road
Baan: Baan IVc4 ags0 - DB: Informix 9.40 UC4 - OS: Sun Solaris 9
Instead of trying to use a previously used series would it not be easier to set up a new series for production orders and update your RPT paramaters to use the new series.


Neal Matthews
Intier Automotive - IT Support Analyst
Reply With Quote
Old 2nd March 2002, 02:05
Karin Espelage Karin Espelage is offline
Join Date: Feb 2002
Location: Dania Beach, Florida
Posts: 79
Karin Espelage is on a distinguished road
Baan: Triton, Baan4, Baan 5 - DB: Oracle, MS SQL, Informix - OS: NT, Unix
Hi Ken,

Baan does look for the next available number.

Unfortunately though, BaaN always checks 25 numbers, then brings up this message and if you press "yes" it checks the next 25 numbers and so on.

So, if you keep pressing yes, it will eventually find the first available number.


P.S.: That only applies to manually entered SFC orders. PRP and MRP seeks the next available number without bringing up messages. I heard about problems with transferring MRP though and I believe there is a patch available for that.

Last edited by Karin Espelage : 3rd March 2002 at 02:14.
Reply With Quote
Sponsored Links
Old 27th May 2005, 14:48
darpan's Avatar
darpan darpan is offline
Senior Member
Join Date: Mar 2005
Location: Chennai
Posts: 114
darpan is on a distinguished road
Baan: Baan IV, Infor LN - DB: oracle 10g, Oracle 9i - OS: AIX, Windows server 2003
i have an option

you can go thru this session "tcmcs0147m000",

it may help u .....


Darpan Bhansali
New Delhi
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
Problem with Porting Set 7.1c.03 for BaanERP 5.0b on Sun Solaris 5.0b baaniac Tools Administration & Installation 11 5th November 2003 08:23
Changing of first free number zaidlaz Distribution, Transportation & Warehousing 1 22nd February 2003 03:46
How do you get the next free number ltannous Tools Administration & Installation 1 25th January 2003 00:20
Lot Number Vs Receipt Number in BaaN IV C4 Abuibra Distribution, Transportation & Warehousing 2 11th October 2002 18:22

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

©2001-2018 - -