User login
|
|
|
Frontpage Sponsor
|
|
|
Poll
|
Would you like to see a separate forum on Baanboard for the ION product? No 14% Yes 86% Total votes: 80 |
Baanboard at LinkedIn
|

|
|
|
 |

13th August 2012, 04:02
|
|
Member
|
|
Join Date: Jul 2007
Posts: 63
|
|
|
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
|

13th August 2012, 09:15
|
 |
Guru
|
|
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,327
|
|
|
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
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
|

13th August 2012, 10:44
|
|
Member
|
|
Join Date: Jul 2007
Posts: 63
|
|
|
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,
|

13th August 2012, 11:34
|
|
Member
|
|
Join Date: Feb 2008
Location: Shropshire
Posts: 41
|
|
|
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
|

13th August 2012, 13:17
|
 |
Guru
|
|
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,327
|
|
|
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
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
|

14th August 2012, 07:39
|
|
Member
|
|
Join Date: Jul 2007
Posts: 63
|
|
|
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,
|

14th August 2012, 08:50
|
 |
Guru
|
|
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,327
|
|
|
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
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
__________________
//Bernd
|

14th August 2012, 09:01
|
|
Member
|
|
Join Date: Jul 2007
Posts: 63
|
|
|
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,
|

14th August 2012, 11:06
|
 |
Guru
|
|
Join Date: Aug 2001
Location: Germany
Posts: 529
|
|
|
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
|

14th August 2012, 11:07
|
|
Member
|
|
Join Date: Jul 2007
Posts: 63
|
|
|
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,
|

14th August 2012, 11:28
|
 |
Guru
|
|
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,327
|
|
|
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
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
__________________
//Bernd
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|