Skip to Content
0
Feb 10, 2011 at 04:29 PM

CRM - linking billing and order (Service Contracts) tabels ?

61 Views

HI

I have a Customer that wants to report on CRM Service Contracts. He wants to be able to display settlement rule (Year, month, etc.) for each Contract. I havenu2019t been able to identify a DataSouce that deliver this information, which means that I have to enhance one of the existing ones. In doing so, I need to be able to link billing information together with order information (contracts numbers).

I havenu2019t found a way to link CRMD_BILLu2026. together with CRMD_ORDERADMu2026, is there any way to do that?

I have been looking for a table to put in between, but I have found one, I canu2019t get the keys to match.

I still havenu2019t found the table field that will give me the information about the Settlement rule (listed under the tab u201Cbilling planu201D in CRM), any help here will also be very much appreciated?

Kind regards

Anders Toft