Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
38%
Installation Wizard into new VRC
41%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 37

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
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
Sponsored Links
  #2  
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
Itannous,

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.

Cheers,

-Dennis
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
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 06:08.


©2001-2017 - Baanboard.com - Baanforums.com