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

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: 18

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 20th April 2005, 14:41
kogelman kogelman is offline
Junior Member
Join Date: Jul 2003
Location: Holland
Posts: 16
kogelman is on a distinguished road
Baan: Baan IVc4 & Ln - DB: SQL - OS: Windows 2003
adjust first free number (tcmcs047)

We have a custummade table with transport-orderlines which constantly will be used by about 20 people.

What I want to achieve is this :

When I change a customer in one of the orderlines, the script checks for an orderline in the same serie with the new customer. If there is one, use that ordernumber with a new line. (this works already).

When there is no order with the same customer in the serie the first free number in tcmcs047 has to be upnumbered with one (+1). The problem is that I have a multi-occurence form where several customers can be used
The first free number must be upnumbered inmediatly while several orderlines can be changed (by 20 people at the same time). How can I achieve that ?
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
Finding Next Available First Free Number kclewley Archiving & Multisite 4 27th May 2005 13:48
Changing of first free number zaidlaz Distribution, Transportation & Warehousing 1 22nd February 2003 02:46
How do you get the next free number ltannous Tools Administration & Installation 1 24th January 2003 23:20
Lot Number Vs Receipt Number in BaaN IV C4 Abuibra Distribution, Transportation & Warehousing 2 11th October 2002 17:22

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

©2001-2018 - -