Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
Would you like to see a separate forum on Baanboard for the ION product?
No
13%
Yes
87%
Total votes: 90

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th August 2012, 04:02
baanspider baanspider is offline
Member
 
Join Date: Jul 2007
Posts: 63
baanspider is on a distinguished road
Baan: Baan LN - DB: Oracle - OS: HP UNIX
Reported problem and Expected solution
Baan: Other/Unknown
C/S: None/Unknown

Hi everyone

I am using LN6.
Just would like to know where these two fields are kept.
In tssoc2110m000, in the Call page, you will see these two fields
but they are not in tssoc210 table.
Where are they kept?

When I go to Edit Form in DFE, I see these two fields are variables.
But they must be kept somewhere because when i exit and enter back
a specific order, the values in these two remains the same.
So it must be kept in a table too.
Please advise.


thanks n regards
Reply With Quote
  #2  
Old 13th August 2012, 09:15
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,334
bdittmar is on a distinguished road
Baan: 2.2/3.1/4c4/LN6.1 FP6/HiDox - DB: bisam, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Which fields ?

Quote:
Originally Posted by baanspider View Post
Hi everyone

I am using LN6.
Just would like to know where these two fields are kept.
In tssoc2110m000, in the Call page, you will see these two fields
but they are not in tssoc210 table.
Where are they kept?

When I go to Edit Form in DFE, I see these two fields are variables.
But they must be kept somewhere because when i exit and enter back
a specific order, the values in these two remains the same.
So it must be kept in a table too.
Please advise.


thanks n regards
Hello,
which fields from service order do you mean ?
Be more specific, please.
Regards
__________________
//Bernd
Reply With Quote
  #3  
Old 13th August 2012, 10:44
baanspider baanspider is offline
Member
 
Join Date: Jul 2007
Posts: 63
baanspider is on a distinguished road
Baan: Baan LN - DB: Oracle - OS: HP UNIX
two fields

Hi

Sorry for the confusion

The two fields are "Reported Problem" and "Expected Solution"
When we go to DFE and edit the form, we see that these are variables.
They are not table fields.
But they must be saved somewhere because when we re-enter the same order, the values on this two fields remains the same.

thanks n regards,
Reply With Quote
  #4  
Old 13th August 2012, 11:34
searocket searocket is offline
Member
 
Join Date: Feb 2008
Location: Shropshire
Posts: 41
searocket is on a distinguished road
Baan: ERP LN 6.1 - DB: 11g - OS: Aix 6.1
Hi, I think you are referring to the "Call" fields.

The design intention for service is that everything starts with creating a service call, then the call can be "transferred" to a service order.
So you should find those fields in tsclm100.
Also bear in mind that calls use tsclm180.

hope that helps
Reply With Quote
Sponsored Links
  #5  
Old 13th August 2012, 13:17
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,334
bdittmar is on a distinguished road
Baan: 2.2/3.1/4c4/LN6.1 FP6/HiDox - DB: bisam, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Call managment

Quote:
Originally Posted by baanspider View Post
Hi

Sorry for the confusion

The two fields are "Reported Problem" and "Expected Solution"
When we go to DFE and edit the form, we see that these are variables.
They are not table fields.
But they must be saved somewhere because when we re-enter the same order, the values on this two fields remains the same.

thanks n regards,
Hello,
searocket is right.

The fields are from the Call-Managment tables.

Problems : tsclm330 a.s.o.

tsclmxxx

Regards
__________________
//Bernd
Reply With Quote
  #6  
Old 14th August 2012, 07:39
baanspider baanspider is offline
Member
 
Join Date: Jul 2007
Posts: 63
baanspider is on a distinguished road
Baan: Baan LN - DB: Oracle - OS: HP UNIX
answer

Hi

Sorry for double posting.

I created the service order in tssoc2110m000 in co. 810 and entered the Reported Problem and Expected Solution in this screen.

But when i go see the table tsclm100 for co.810, the table is empty with no records.
So where is it being kept, i still do not know
Please advise

thanks n regards,
Reply With Quote
  #7  
Old 14th August 2012, 08:50
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,334
bdittmar is on a distinguished road
Baan: 2.2/3.1/4c4/LN6.1 FP6/HiDox - DB: bisam, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
See attachment

Quote:
Originally Posted by baanspider View Post
Hi

Sorry for double posting.

I created the service order in tssoc2110m000 in co. 810 and entered the Reported Problem and Expected Solution in this screen.

But when i go see the table tsclm100 for co.810, the table is empty with no records.
So where is it being kept, i still do not know
Please advise

thanks n regards,
Hello,
have a look at the attachment !

The tables are tsclm330 and tsclm335 !

Regards
Attached Files
File Type: doc Service Order.doc (86.5 KB, 6 views)
__________________
//Bernd
Reply With Quote
  #8  
Old 14th August 2012, 09:01
baanspider baanspider is offline
Member
 
Join Date: Jul 2007
Posts: 63
baanspider is on a distinguished road
Baan: Baan LN - DB: Oracle - OS: HP UNIX
not master tables

Hi

The two tables tsclm330 and tsclm335 are the master tables for problems and solutions.
User zooms to the master tables to select the problem and solution.

My question is where is the values kept for the service order line?

In the service order lines table tssoc210, there is only two fields there
- actual problem and actual solution.

But tssoc210 does not have reported problem, expected problem and expected solution.

Hope you understand better now.

thanks n regards,
Reply With Quote
  #9  
Old 14th August 2012, 11:06
Juergen's Avatar
Juergen Juergen is offline
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 530
Juergen is on a distinguished road
Baan: IVc4, ERP LN - DB: Oracle - OS: Linux, Unix
Hi Baanspider,

actually we don't using the service in ERP Ln, but I think that fields must be filled based on entries in the clm (Call Management) module.
Please check table tsclm350 - Service resolution and probability analysis

Regards,
Juergen
Reply With Quote
  #10  
Old 14th August 2012, 11:07
baanspider baanspider is offline
Member
 
Join Date: Jul 2007
Posts: 63
baanspider is on a distinguished road
Baan: Baan LN - DB: Oracle - OS: HP UNIX
one more thing

Hi

For your info, what user wants is to put
Reported Problem and Expected Solution in the report.

But I could not solve this for them because i cannot find the two fields in tssoc210 table.

Hope this info helps you to understand our requirement

thanks n regards,
Reply With Quote
  #11  
Old 14th August 2012, 11:28
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,334
bdittmar is on a distinguished road
Baan: 2.2/3.1/4c4/LN6.1 FP6/HiDox - DB: bisam, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
The data is stored in tsclm350 !

Quote:
Originally Posted by baanspider View Post
Hi

For your info, what user wants is to put
Reported Problem and Expected Solution in the report.

But I could not solve this for them because i cannot find the two fields in tssoc210 table.

Hope this info helps you to understand our requirement

thanks n regards,
Hello,

the data is stored in table tsclm350 with reference to the origin and order number and activity (Position).
In your reporting, you have to read this table by reference fields.

See attachment !

Regards
Attached Files
File Type: doc Service Order.doc (148.0 KB, 4 views)
__________________
//Bernd
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
Reported problem and Expected solution baanspider Project & Services 6 15th August 2012 10:36
What's the link between allocated and expected inventory Bartth Distribution, Transportation & Warehousing 3 5th January 2005 04:11
Problem in Running a Report Sudipta Tools Development 2 17th November 2004 07:48
Problem in Compiling the Script of a report Sudipta Tools Development 4 20th October 2004 07:47
bdb_errno 215 r_nagu Tools Development 7 19th December 2003 20:07


All times are GMT +2. The time now is 09:24.


©2001-2013 - Baanboard.com - Baanforums.com