Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

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 24th January 2003, 23:17
ltannous's Avatar
ltannous ltannous is offline
Senior Member
Join Date: Sep 2002
Location: Canada
Posts: 280
ltannous is on a distinguished road
Baan: 4c4 - DB: Oracle - OS: UNIX
How do you get the next free number

When using exchange, I am entering data for purchase contracts from one company to another, and I need to get the next free number to do an insert. Currently exchange is writing the contract number from the exporting company, into the importing company, even if the number series is not set up.

I am trying to figure out how to get the exchange scheme to grab the next free number.
Reply With Quote
Old 25th January 2003, 00:20
dnnslbrwn's Avatar
dnnslbrwn dnnslbrwn is offline
Senior Member
Join Date: Jan 2003
Location: Toronto
Posts: 149
dnnslbrwn is on a distinguished road
Baan: IVc4 - DB: Informix - OS: Unix

In the Maintain Field Relations (import) session, instead of linking the contract number to a data field, leave that blank and instead create a condition. In the condition, do a lookup on tcmcs047 for the next free contract table, lock it and update it with the next contract number and return the original free number.


Reply With Quote
Sponsored Links

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
Finding Next Available First Free Number kclewley Archiving & Multisite 4 27th May 2005 14:48
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
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 17:20.

©2001-2018 - -