• From: Pakistan, Peshawar
  • Registered: 07/24/2020
  • Posts: 1

Topic: Include comments /memo (from database) in Customer / Supplier Reports

Hi I am trying to include comments / memo(from database table comments) in customer / supplier reports. I am trying to edit rep101.php to update customer report but any changes I am making is producing errors. Can you please guide me steps on how to include comments / memo(from database table comments) in Customer Reports

Thanks

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,181

Re: Include comments /memo (from database) in Customer / Supplier Reports

There is a function get comment string. From there if you pass the trans no and type. It will get you the comment. After that create a column in rep101.php and add this value to it.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Include comments /memo (from database) in Customer / Supplier Reports

@joe: can the SQL to get customer / supplier details be modified to retrieve the comments field too?

apmuthu's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Include comments /memo (from database) in Customer / Supplier Reports

I will check this.

Joe