• From: Ghana
  • Registered: 05/28/2012
  • Posts: 51

Topic: Searching Journal Inquiry by user not working? FA 2.4.2

Hi all,

When I want to see transactions only by a specific user, I go to Banking and General Ledger > Journal Inquiry, then select that user. But the result doesn't filter.

How do fix this?

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

Re: Searching Journal Inquiry by user not working? FA 2.4.2

I have a solution for this issue,

goto file manager and followed by this path

[Root_of_your_fa/gl/inquiry/journal_inquiry.php edit this file and find this below code.

 $sql = get_sql_for_journal_inquiry(get_post('filterType', -1), get_post('FromDate'),
    get_post('ToDate'), get_post('Ref'), get_post('Memo'), check_value('AlsoClosed'));

Here change this code to 

 $sql = get_sql_for_journal_inquiry(get_post('filterType', -1), get_post('FromDate'),
    get_post('ToDate'), get_post('Ref'), get_post('Memo'), check_value('AlsoClosed'),get_post('userid'));

than it will work.

@joe commit this change on your next commit.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

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

Re: Searching Journal Inquiry by user not working? FA 2.4.2

Will do later this evening.
Committed

Joe

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

Re: Searching Journal Inquiry by user not working? FA 2.4.2

ok smile

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Ghana
  • Registered: 05/28/2012
  • Posts: 51

Re: Searching Journal Inquiry by user not working? FA 2.4.2

About to try now. Thanks, you're awesome.

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

Re: Searching Journal Inquiry by user not working? FA 2.4.2

Glad to fix a simple bug

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website