FrontAccounting forum — Include comments /memo (from database) in Customer / Supplier Reports

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

null@example.com (joe) — Sun, 26 Jul 2020 16:31:46 +0000

I will check this.

Joe

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

null@example.com (apmuthu) — Sun, 26 Jul 2020 13:46:57 +0000

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

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

null@example.com (kvvaradha) — Sat, 25 Jul 2020 09:14:55 +0000

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.

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

null@example.com (musadaqm) — Fri, 24 Jul 2020 15:19:22 +0000

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