What do I need to add to appointments custom fields so that I can Create a report for appointments that match the mobile in person translation like pay pal here card swipe. I can run a report from PayPal all the transactions but I have to manually match the appointment time with the PayPal transaction comparing both reports. is there a way to automate this to one report by adding some details to appointments custom fields?
I would use something like access or Visual Studio to sing the data tables from each server to build and run the report. But I do not know what I could add to join those transactions.