Topic: Bank Reconciliation and Reports Header

Hello.....

As a contribution for user of this forum:

1-For Bank Reconciliation at specific date insert this code  in line 286

        AND amount != 0 AND trans_date <= '". date2sql($date) ."'

in this file gl/includes/db/gl_db_bank_accounts.inc

2-To show the header of each company, so reports will be asociated to the company info, insert this code:

//Display Header
start_table(TABLESTYLE, "width='90%'");
    $company = get_company_prefs();    
    start_row();
   echo '<td colspan = "6" > <center> <img src="'.company_path().'/images/'.$company['coy_logo'].'" > </center></td> ';
    end_row();
end_table();
br(2);
//Display Header    

At the beginning of

  a)-GL reports:

/gl/view/deposit
/gl/view/payment
/gl/view/transaction
/gl/view/transference

  b)-Sales reports:

/sales/view/view_receipt.php
/sales/view/view_invoice.php

  c)-Purchase reports:

/purchasing/view/view_po    
/purchasing/view/view_supp_payment 
/purchasing/view/view_supp_invoice.php
/includes/ui/ ui_view.inc

It would be great if the FA team include this improvements in next upgrade.

Regards...

Rafael

Re: Bank Reconciliation and Reports Header

I will look into this asap.

Joe

Re: Bank Reconciliation and Reports Header

Great!...thanks....

Re: Bank Reconciliation and Reports Header

I've moved this topic to FA Modifications.

I think this will be an options for Company Setup.

Joe

Re: Bank Reconciliation and Reports Header

Is this the way you want all the Views to look like.

Joe

Post's attachments

GL trans with company logo.png 28.2 kb, file has never been downloaded. 

GL trans without company logo.png 22 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

Re: Bank Reconciliation and Reports Header

Joe may be a little header like the logo address, email, phone instead of just a logo.

Subscription service based on FA
HRM CRM POS batch Themes

Re: Bank Reconciliation and Reports Header

@Rmendez

I have now implemented the company logo/or name if no logo/ on views, if a checkbox in company setup is marked. I have for a start implemented it in the views you suggested.

I have not yet committed it to stable repo, but will soon. I hope it will be appreciated. It is possible to easily change the content of the header, but I think it should be as small as possible to give space for the subject to be shown.

Joe

Re: Bank Reconciliation and Reports Header

Committed to stable repo.

Joe

Re: Bank Reconciliation and Reports Header

Thanks...That's great Joe.  It  will solve a problem when FA users has more than one company, so reports could be identified to which company belong with the company logo.

I apreciate you consider this improvement.  Hope it help another users.

Thanks....

10 (edited by apmuthu 01/02/2023 12:47:57 pm)

Re: Bank Reconciliation and Reports Header

@joe: you might want to update the commit with the following insertions in the sys_prefs initial data in the default sql files with:

,('company_logo_on_views', 'setup.company', 'tinyint', '1', '0')

The Company Setup Wiki page has been updated.

Post's attachments

CoSetup.png 60.3 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

Re: Bank Reconciliation and Reports Header

Willdo. Thanks @apmuthu.

Joe

Committed