Search options (Page 45 of 247)

After the $xr_providers array declaration in config.php see that the line below is appropriately assigned like:

$dflt_xr_provider = 0;

You can also upload the post release FA files in the announcement post. Some folders will need write permissions for the webserver user in case you get permission denied errors.

The missing sys_prefs table records can be put in in any order and their sane default values can be found in the sql/en_US-new.sql file.

The config.php file can be compared with the new config.default.php file and the missing entries put into the former.

There may be duplicate lines - maybe a DISTINCT is needed somewhere. Try to make the INNER JOIN using an ON statement rather than in WHERE like:

        case ST_BANKPAYMENT :
        case ST_BANKDEPOSIT :
            $sql = "SELECT trans.debtor_no as person_id, 
            CONVERT(debtor.name using utf8) as name
            FROM ".TB_PREF."debtor_trans trans INNER JOIN ".TB_PREF."debtors_master debtor USING (debtor_no)
            WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
            ."
            UNION
                SELECT trans.supplier_id as person_id, 
            CONVERT(supp.supp_name using utf8) as name
            FROM ".TB_PREF."supp_trans trans INNER JOIN ".TB_PREF."suppliers supp USING (supplier_id)
            WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
            ."
            UNION
                SELECT IF (person_type_id=0, 0 ,NULL) as person_id, 
            IF (person_type_id=0, CONVERT(person_id using utf8),NULL) as name 
            FROM ".TB_PREF."bank_trans
            WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
            ;
            break;

From FA 2.4.4 to 2.4.7:

* FTP the new files
* Put in the missing sys_prefs table records
    print_dialog_direct
    ref_no_auto_increase
* Update the config.php file

- there are no db changes.

Don't forget to update to the latest changes after the release of FA 2.4.7 too.

The install.html and update.html files have been removed.
The files in the "install" folder will need to be deleted.

Then, FA would need some automatic means of assimilating the current purchasing price whenever it changes from the vendor end. Something like the daily Exchange rates!

To start with, we can make a report that lists the supplier in descending order of price for a specific item. If the last purchased price is very long ago, it will distort the order's inference. Hence a last purchased date too will need to form part of the report.

Generally the default bank account with have more transactions.

Try making the target bank account (the one with few transactions) as the default bank account temporarily and see if it now generates more transactions, before reverting back.

If we now get more transactions, then the devs can re-evaluate the code for it or reason it accordingly.

This may be so as reconciliation is based on downloadable statement from the banks.

@joe: your take?

Attach the outstanding balance report along with the Invoice or edit the rep107 to add another page to show the ledger summary of last few transactions. FA cannot assume that all payments will be in full to match Invoice value.

The Previous Balance / Arrears do not form part of the Invoice and if done as per your request, will be subject to change when printed again after some payments are received.

Hardcode the value attribute of the form's input field in the appropriate form and make it hidden - this will apply globally.