Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor

Main

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

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 9th May 2007, 16:04
metropoj metropoj is offline
Senior Member
 
Join Date: Feb 2004
Location: Oshawa
Posts: 223
metropoj is on a distinguished road
Baan: LN FP7 - DB: MSSQL - OS: Win 7
Question Changing / Deleting an Order Type
Baan: Other/Unknown

tcmcs0142m000

We have just started off a new company. A Sales order was entered into the system using an Order Type called SB.

We then realized that we wanted different Order Steps to follow for that Order Type, they cannot be changed.

I created a New Order Type with the Steps I wanted ( called SRB ), copied the Sales Order to new Order Type and deleted old Sales Order.

Now I want to kill off old Order Type SB ...

I cannot change or delete the old SB Order Type. I presume history written somewhere is preventing this.

Anyone have any ideas where I should be looking at editing tables to allow me to change / delete the old Order Type ?
Reply With Quote
Sponsored Links
  #2  
Old 9th May 2007, 17:37
Juergen's Avatar
Juergen Juergen is online now
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 566
Juergen is on a distinguished road
Baan: IVc4, ERP LN - DB: Oracle - OS: Linux, Unix
Check the sales history tables tdsls050 (Headers) and tdsls051 (Lines).

Rgds,
Juergen
Reply With Quote
  #3  
Old 9th May 2007, 20:03
metropoj metropoj is offline
Senior Member
 
Join Date: Feb 2004
Location: Oshawa
Posts: 223
metropoj is on a distinguished road
Baan: LN FP7 - DB: MSSQL - OS: Win 7
OK. I deleted the references in 050 and 051. Unfortunately, the order Type is still locked ...

Any additional tables I should look into ?

Last edited by metropoj : 9th May 2007 at 20:05. Reason: Additional COmment
Reply With Quote
  #4  
Old 9th May 2007, 22:53
learner's Avatar
learner learner is offline
Guru
 
Join Date: Dec 2002
Location: New zealand
Posts: 562
learner is on a distinguished road
Baan: BaaN Vc with sp 28 - DB: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit - OS: HP-UX B.11.31
Use Tools session to figure out

Hi,

Try executing session Print Ref. to Parent , session code in baan 5 is ttaad4229m000

This session is also available in baan 4. In case there is a diff. in session code due to baan 4 and baan 5, look out for session under Menu

Quote:
Database Manageent --- > Misc ----> Print Ref. to Parent
This session will expect a base table to start of where the data is still present, then it gives a output as to where all places the Particular Sales
Order Type is used.


Hope it helps to some extent.

Regards

Learner
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
Deleting Lines In Servicxe Order after making PO riazsayeed Project & Services 2 6th July 2004 06:14
Baan & Connectware Driver Hangs Rajasekhar Tools Administration & Installation 2 18th February 2004 21:32
Changing Order Type benito Manufacturing & Supply Chain 2 28th August 2003 22:19


All times are GMT +2. The time now is 11:53.


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