Disabling the first free number

[Ash Gajjar]

I have some external data that will populate the cluster table (tsbsc100). It has its own unique key. I would very much like that to be the key in Baan.

Is there any way I can disable the series ? I know programmically I should be able to , but very much like to control it with parameters, settings etc
We run 5.2a but believe it is similar in LN

Grateful for any assistance

ash

[David Eagar]

you could possibly reset your first free number, import your data, and then reset your FFN to where it was, but WITH CARE, duplicates would cause chaos

[Ash Gajjar]

What I would like to do is permanently disable the FFN. We already have loads of records generated by the FFN. now external records have their own numbers which I want to have as the key.

Thanks

[shah_bs]

Unfortunately, First Free numbers cannot be disabled - the concept is embedded (at least in BAAN IV) in all the Order Type documents. You can, however, choose (at least in BAAN IV) between "No Series", "One Digit Series", or "Two Digit Series", taking an example from Purchase Order Parameters.

The other assumption is that your document number is numeric and sequential starting from some start number.

If you were lucky enough to have chosen "No Series" in your parameters, and you do not have any data yet in the system, then you just have to load the data, and then adjust the First Free Number to the maximum document number loaded.

It becomes more complicated if you have chosen other than "No Series".

It would be even more difficult to recommend a process where you already have data in the system.

[Darren Phillips]

I did something like this in 4c4, I was loading data via exchange. Initially I had a condition script that looked up the first free number for a specific series then used that number to create the number and then updated the first free number table. But I later changed it so the external program created the number. So that the number series I used in my program couldn't be used in Baan, in the first free number session I changed that series to be blocked for input. If the data is loaded externally to baan then the block on the series just stops it from being used in a baan session. But your external application generating the data will have to take care of any duplication of the series number. The best way to start this is to create a specific order series for the external application. Block this series and then configure the external application to use this order series.