I want help in making 1 CRM REPORT. I have a report of CRM customer contact history with 2 tables as below:
1- MK- CONTACT HISTORY 1- tarmagic 1
2- MK- CUSTOMER RECORD
i want to connect or link the vehicle record table(MK- VEHICLE RECORDS) in my current report to get the details of cars with customer contact history report.
Can you please help me , how i link vehicle record table in this report .
Your quick response will be highly appreciated
CT (company or target)
CTMAGIC (magic for company or target)
LINKTYPE (S A or D in normal setups)
VEHSTAT (Currrent, Previous)
You'd have to link using CT = T, Target number, then sift through the potential multiple VEHMAGICs. You could use the ki_ routines for this.
EDIT you could possibly link from the Vehicle Magic held on the Contact record but this will only be present if the contact is of a vehicle-related type.
Who is online
Users browsing this forum: No registered users and 1 guest