What field is used to define a “customer contract” or a “time and material contract” in Astea v15.3 ?
We want to check and report which kind of contract is on a customer support or a service order.
Solved
contracts
Best answer by Phil Seifert
Piet,
Reviewing the SQL executed in the time and materials module, it seems that it is keying on the cconth.is_default field to determine if it is a Time and Materials contract.
There is only one in the DB copy we have from you for IMAC and it is pulled up with the following query criteria:
AND (cconth.is_default = 'Y')
When I look at the query for the Customer Contracts module, the criteria is looking for:
Where (cconth.is_default <> 'Y')
+24Piet,
Reviewing the SQL executed in the time and materials module, it seems that it is keying on the cconth.is_default field to determine if it is a Time and Materials contract.
There is only one in the DB copy we have from you for IMAC and it is pulled up with the following query criteria:
AND (cconth.is_default = 'Y')
When I look at the query for the Customer Contracts module, the criteria is looking for:
Where (cconth.is_default <> 'Y')
Please mark any comments which answered your question as Best Answer so the topic is easier recognised as answered and closed.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.