FrontAccounting forum — FA Modifications

Error Handler not working for php 8.2

2023-12-08T05:34:10Z

When we even turn on the go_debug 2. that doesnt get the mysql errors like 1062 duplicate entry, 1054 column not found errors are not showing the query which get this error. But in php 8.0 it works fine.

We need to update the error handler or fix it work based on php 8.2

Can we use the set_icon function in db_pager_view.inc as well

2023-11-19T09:30:14Z

from db_pager_view.inc file, we have a function navi_button which actually passes the img tag to get icons like this.

function navi_button($name, $value, $enabled=true, $icon = false) {
    global $path_to_root;
      return "\n";
}

Change it to like this.

function navi_button($name, $value, $enabled=true, $icon = false) {
    global $path_to_root;
      return "\n";
}

Adding delivery-date for each item in sales-invoice

2023-10-28T09:08:55Z

Hi,

I want the 'delivery date' for each item in salesinvoice ((new) column 'Date' ('tran_date' of delivery)). I know I have to change the function 'get_customer_trans_details' in '/sales/includes/db/cust_trans_details_db.inc', but how to select the 'tran_date' of the delivery in the sql-syntax ?

This is the function :

function get_customer_trans_details($debtor_trans_type, $debtor_trans_no)
{
if (!is_array($debtor_trans_no))
$debtor_trans_no = array( 0=>$debtor_trans_no );
$sql = "SELECT line.*,
line.unit_price+line.unit_tax AS FullUnitPrice,
line.unit_price AS UnitPriceExTax,
line.description AS StockDescription,
item.long_description AS StockLongDescription,
item.units, item.mb_flag
FROM "
.TB_PREF."debtor_trans_details line,"
.TB_PREF."stock_master item
WHERE (";
$tr=array();
foreach ($debtor_trans_no as $trans_no)
$tr[] = 'debtor_trans_no='.db_escape($trans_no);
$sql .= implode(' OR ', $tr);

$sql.= ") AND debtor_trans_type=".db_escape($debtor_trans_type)."
AND item.stock_id=line.stock_id
ORDER BY id";
return db_query($sql, "The debtor transaction detail could not be queried");
}

Thanks,

2 unused function in types.inc

2023-09-14T16:43:59Z

As i can see two functions inside types.inc which is never wused inside our FA program.

payment_person_currency
payment_person_has_items

includes/types.inc

@joe, is these functions used anywhere or any future plan with this.

How can i get Each invoice status like paid, unpaid, overdue, etc ?

2023-08-27T10:00:59Z

As of now, only the overdue has the status of red color highlight. But is there any solution to put each transaction status in the Customer Transaction Inquiry?

XUMM Payment Link in Customer Invoice Printing

2023-07-05T03:58:18Z

I've created a pull request for the Xumm payment link to be added to be committed to the main repository on GitHub.

I'm no coder but the proposed works fine. I would appreciate if it could be reviewed, checked and confirmed ok, to be committed.

Not sure if the process to update documentation to explain process.

Would like to look at exporting supplier payment file next, has anyone done any work in that regard?

Thanks.

Wanna add Signature Option on Invoice

2023-06-10T06:57:41Z

I wanna add Customer and Company Signature Option on Invoice. So that I can sign after printing the invoice. Please Help me, How Can I do that?

Emailed reports only use last name

2023-03-31T11:28:02Z

I found this thread from 2014 but didn't have permission to reply:

https://frontaccounting.com/punbb/viewtopic.php?id=5254

The issue they bring up is that reports emailed from FA start with "Dear" and then the person's last name, with no title or first name.

I just wanted to say that I agree with the OP in the thread that "Dear First Last" is much better than simply "Dear Last". In the UK the current arrangement would be a very strange way to start an email or letter. I also agree that "Dear Title Last" is even better in a formal setting.

I have modified my own installation but wondered if it's worth making it default that way.

Is it usual in other parts of the world to start a letter "Dear Last"?

Posting payments automatically

2023-03-19T06:25:38Z

I've used REST API to post sales, however, it only creates direct invoices which needs to be paid for and allocated, has anyone ever achieved this.

Thanks.

PHP 8.1 onwards db_set_charset needs second parameter

2023-02-24T06:31:51Z

While activating an extension from php 8.1 onwards, we have an issue with

mysqli_set_charset second parameter cant be null, This happens from db_import function from maintenance_db.inc

$encoding = null; // UI encoding for default site language is the default

With

$encoding ='utf8'; // UI encoding for default site language is the default

Or a valid $encoding needs to be passed here.

Opening Year - 2017

2023-01-29T14:48:37Z

Upon setting up a new company, one is defaulted to 2017. This should be updated to at least 2021. Can I get an Amen? Thank you.

No backup of attachments of a company

2022-12-27T22:45:20Z

Hi,

The backup-functionality only makes a backup of the database-data.

Is it possible to download the (renamed) attachments of a company from the FA-application, perhaps in a zip-file called [date]_[companynumber]_backup_attachments.zip ? Can it be made possible ?

Thanks,

Bank Reconciliation and Reports Header

2022-12-23T21:32:00Z

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 '    ';
    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

location transfers with standard cost

2022-10-19T14:01:07Z

the standard cost of item from one location to another are not visible.
Except po is done for that item in that location.
Is there a way to fix this?

Table paging for data not from SQL

2022-09-24T02:19:54Z

Hi,

I am aware of db_pager functionality. Now I need to make a table with paging functionality from already queried data.
Is there any way to do this?